fastCRW Pergamon
Government
data.orcities.org
data.orcities.org
Socrata open data portal at data.orcities.org, publishing 67 public datasets from the publishing organisation, led by the City Financial Data category.
Showing the catalogue
GET /v1/data/data-orcities-org/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/data-orcities-org/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.orcities.org.
JSON
{
"results": [
{
"resource": {
"name": "2018 Salary Survey Data",
"id": "yh2y-34u7",
"resource_name": null,
"parent_fxf": [],
"description": "This data comes from the 2018 salary survey data. Please notethe following:\n\n1. Where able, the data has been altered to reflect the annual pay of the average employee in this city and in this position based on the city's salary range.\n2. Not all salaries and wages of less than 1 FTE could be confirmed. As a result, some salaries for positions with less than 1 FTE are either the annual equivelant or the actual pay of the employee throughout a year (ex. if an employee would make $50,000 as a full time employee but only works half-time, some cities marked this as $50,000 or $25,000. \n3. Educational attainment often was provided with a minimum education and experience as well as a preferred level. The minimum of both categories are provided.",
"attribution": "League of Oregon Cities",
"attribution_link": "http://www.orcities.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-04-23T03:41:12.000Z",
"createdAt": "2018-02-22T20:57:20.000Z",
"metadata_updated_at": "2019-04-23T03:41:12.000Z",
"data_updated_at": "2018-02-27T18:36:34.000Z",
"page_views": {
"page_views_last_week": 11,
"page_views_last_month": 39,
"page_views_total": 5743,
"page_views_last_week_log": 3.5849625007211565,
"page_views_last_month_log": 5.321928094887363,
"page_views_total_log": 12.487840033823051
},
"columns_name": [
"Public Relations Manager - Average Annual Sick Days",
"Superintendent of Streets - # of FTE in City",
"City Planner - Average Salary or Annual Wage",
"City Planner - # of FTE in City",
"Planning Director - Average Salary or Annual Wage",
"Municipal Judge - # of FTE in City",
"Librarian - # of FTE in City",
"IT Manager - Is This Position Contracted Out? (Y/N)",
"IT Manager - Average Salary or Annual Wage",
"IT Manager - # of FTE in City",
"… 236 more items"
],
"columns_field_name": [
"public_relations_manager_average_annual_sick_days",
"superintendent_of_streets_of_fte_in_city",
"city_planner_average_salary_or_annual_wage",
"city_planner_of_fte_in_city",
"planning_director_average_salary_or_annual_wage",
"municipal_judge_of_fte_in_city",
"librarian_of_fte_in_city",
"it_manager_is_this_position_contracted_out_y_n",
"it_manager_average_salary_or_annual_wage",
"it_manager_of_fte_in_city",
"… 236 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Text",
"Number",
"Number",
"… 236 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 236 more items"
],
"columns_format": [
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"precision": "2",
"decimalSeparator": ".",
"currencyStyle": "CAD",
"groupSeparator": ",",
"precisionStyle": "currency"
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"precision": "2",
"decimalSeparator": ".",
"currencyStyle": "CAD",
"groupSeparator": ",",
"precisionStyle": "currency"
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{
"precision": "2",
"decimalSeparator": ".",
"currencyStyle": "CAD",
"groupSeparator": ",",
"precisionStyle": "currency"
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
"… 236 more items"
],
"download_count": 869,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-02-27T18:36:48.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Financial Data",
"domain_tags": [
"myrtle point",
"monroe",
"molalla",
"medford",
"mcminnville",
"malin",
"madras",
"lyons",
"lowell",
"lostine",
"… 103 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/yh2y-34u7",
"link": "https://data.orcities.org/City-Financial-Data/2018-Salary-Survey-Data/yh2y-34u7",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "City financial data",
"id": "n3gy-ac7h",
"resource_name": null,
"parent_fxf": [],
"description": "Dataset contains selected budget information from 2006 to 2014 for 50 cities. The data includes: property tax revenue, public safety expenditure, governmental fund revenue and expenditure and general fund revenue and expenditure.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2016-08-08T22:38:58.000Z",
"createdAt": "2016-01-14T16:06:07.000Z",
"metadata_updated_at": "2016-08-08T22:38:58.000Z",
"data_updated_at": "2016-04-19T15:12:46.000Z",
"page_views": {
"page_views_last_week": 21,
"page_views_last_month": 65,
"page_views_total": 4752,
"page_views_last_week_log": 4.459431618637297,
"page_views_last_month_log": 6.044394119358453,
"page_views_total_log": 12.214622686302336
},
"columns_name": [
"Region",
"County",
"Location 1",
"Counties",
"Cities",
"Location 1 (address)",
"Inflation Adjusted to 2014",
"Amount",
"Year",
"Budget Category",
"… 7 more items"
],
"columns_field_name": [
"region",
"county",
"location_1",
":@computed_region_6i9h_2rt9",
":@computed_region_u39g_jjf9",
"location_1_address",
"inflation_adjusted_to_2014",
"amount",
"year",
"budget_category",
"… 7 more items"
],
"columns_datatype": [
"Text",
"Text",
"Point",
"Number",
"Number",
"Text",
"Number",
"Number",
"Number",
"Text",
"… 7 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 7 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{
"precision": "0",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "0",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
"… 7 more items"
],
"download_count": 745,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-04-19T15:13:28.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Financial Data",
"domain_tags": [
"revenue",
"public safety",
"property tax",
"powers",
"portland",
"philomath",
"pendleton",
"myrtle creek",
"medford",
"manzanita",
"… 47 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org"
},
"permalink": "https://data.orcities.org/d/n3gy-ac7h",
"link": "https://data.orcities.org/City-Financial-Data/City-financial-data/n3gy-ac7h",
"owner": {
"id": "exib-bdyy",
"user_type": "interactive",
"display_name": "Charlie Conrad"
},
"creator": {
"id": "exib-bdyy",
"user_type": "interactive",
"display_name": "Charlie Conrad"
}
},
{
"resource": {
"name": "Police Departments and Total Employees",
"id": "2wew-eeq2",
"resource_name": null,
"parent_fxf": [],
"description": "List of Cities with Police Departments and respective FTE as of 2013.",
"attribution": "League of Oregon Cities",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-04-23T03:41:16.000Z",
"createdAt": "2016-04-06T16:29:03.000Z",
"metadata_updated_at": "2019-04-23T03:41:16.000Z",
"data_updated_at": "2016-04-06T16:36:08.000Z",
"page_views": {
"page_views_last_week": 24,
"page_views_last_month": 64,
"page_views_total": 4342,
"page_views_last_week_log": 4.643856189774724,
"page_views_last_month_log": 6.022367813028454,
"page_views_total_log": 12.084476237453893
},
"columns_name": [
"2013 Population",
"Officers per 1000",
"Location (state)",
"Location (zip)",
"Location (city)",
"Location (address)",
"City",
"Total law enforcement employees",
"Total officers",
"Total civilians",
"… 3 more items"
],
"columns_field_name": [
"_2013_population",
"officers_per_1000",
"location_state",
"location_zip",
"location_city",
"location_address",
"city",
"total_law_enforcement_employees",
"total_officers",
"total_civilians",
"… 3 more items"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number",
"Number",
"Number",
"… 3 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 3 more items"
],
"columns_format": [
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"precision": "3",
"align": "right"
},
{},
{},
{},
{},
{},
{},
{},
{},
"… 3 more items"
],
"download_count": 550,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-04-06T16:36:24.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Services",
"domain_tags": [
"silverton",
"sherwood",
"seaside",
"scappoose",
"sandy",
"salem",
"roseburg",
"rogue river",
"rockaway beach",
"reedsport",
"… 114 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/2wew-eeq2",
"link": "https://data.orcities.org/City-Services/Police-Departments-and-Total-Employees/2wew-eeq2",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "Economic Demographics",
"id": "gfdb-jbxz",
"resource_name": null,
"parent_fxf": [],
"description": "Data from the American Communities Survey 2014. This data includes information on household income, city industries composition, and class of workers.",
"attribution": "US Census Bureau",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2017-01-09T17:17:43.000Z",
"createdAt": "2017-01-09T17:06:27.000Z",
"metadata_updated_at": "2017-01-09T17:17:43.000Z",
"data_updated_at": "2017-01-09T17:09:06.000Z",
"page_views": {
"page_views_last_week": 19,
"page_views_last_month": 54,
"page_views_total": 4015,
"page_views_last_week_log": 4.321928094887363,
"page_views_last_month_log": 5.78135971352466,
"page_views_total_log": 11.971543553950772
},
"columns_name": [
" EMPLOYMENT STATUS - Own children of the householder 6 to 17 years - All parents in family in labor force",
" EMPLOYMENT STATUS - Own children of the householder under 6 years - All parents in family in labor force",
" EMPLOYMENT STATUS - Population 16 years and over - In labor force",
" EMPLOYMENT STATUS - Population 16 years and over - In labor force - Civilian labor force - Unemployed",
" EMPLOYMENT STATUS - Population 16 years and over - Not in labor force",
" INCOME AND BENEFITS (IN 2015 INFLATION-ADJUSTED DOLLARS) - Per capita income (dollars)",
" INCOME AND BENEFITS (IN 2015 INFLATION-ADJUSTED DOLLARS) - Total households - $100,000 to $149,999",
" INCOME AND BENEFITS (IN 2015 INFLATION-ADJUSTED DOLLARS) - Total households - $200,000 or more",
" INCOME AND BENEFITS (IN 2015 INFLATION-ADJUSTED DOLLARS) - Total households - $25,000 to $34,999",
" INCOME AND BENEFITS (IN 2015 INFLATION-ADJUSTED DOLLARS) - Total households - $35,000 to $49,999",
"… 66 more items"
],
"columns_field_name": [
"employment_status_own_children_of_the_householder_6_to_17_years_all_parents_in_family_in_labor_force",
"employment_status_own_children_of_the_householder_under_6_years_all_parents_in_family_in_labor_force",
"employment_status_population_16_years_and_over_in_labor_force",
"employment_status_population_16_years_and_over_in_labor_force_civilian_labor_force_unemployed",
"employment_status_population_16_years_and_over_not_in_labor_force",
"income_and_benefits_in_2015_inflation_adjusted_dollars_per_capita_income_dollars",
"income_and_benefits_in_2015_inflation_adjusted_dollars_total_households_100_000_to_149_999",
"income_and_benefits_in_2015_inflation_adjusted_dollars_total_households_200_000_or_more",
"income_and_benefits_in_2015_inflation_adjusted_dollars_total_households_25_000_to_34_999",
"income_and_benefits_in_2015_inflation_adjusted_dollars_total_households_35_000_to_49_999",
"… 66 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 66 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 66 more items"
],
"columns_format": [
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
"… 66 more items"
],
"download_count": 606,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2017-01-09T17:17:43.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"milwaukie",
"mitchell",
"molalla",
"monmouth",
"monroe",
"monument",
"moro",
"mosier",
"mt. angel",
"mt. vernon",
"… 238 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/gfdb-jbxz",
"link": "https://data.orcities.org/dataset/Economic-Demographics/gfdb-jbxz",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "System Development Charge Survey Data",
"id": "nb7c-wkjq",
"resource_name": null,
"parent_fxf": [],
"description": "Data for the 2016 SDC Survey.\r\n\r\nNOTE: Some data (such as residential and non-residential fees) are based on an example given to member cities in the survey. The example is provided in the attached survey.",
"attribution": "League of Oregon Cities",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2016-09-02T22:00:04.000Z",
"createdAt": "2016-07-01T18:52:13.000Z",
"metadata_updated_at": "2016-09-02T22:00:04.000Z",
"data_updated_at": "2016-09-02T21:59:05.000Z",
"page_views": {
"page_views_last_week": 8,
"page_views_last_month": 33,
"page_views_total": 3921,
"page_views_last_week_log": 3.1699250014423126,
"page_views_last_month_log": 5.08746284125034,
"page_views_total_log": 11.93737382019215
},
"columns_name": [
"Transportation SDC Rev.: FY2015",
"Total Residential Fees",
"Parks SDC-Example Non-Residential-Reimbursement Fee",
"Transportation SDC-Reimbursement Fee",
"Transporation SDC-Example Non-Residential-Reimbursement Fee",
"Transportation SDC-Example Non-Residential-Other Fee 2",
"Has your City issued SDC accomodations in last 3 Year?",
"City",
"Does the City have SDCs?",
"Total SDC Revenue FY2013",
"… 86 more items"
],
"columns_field_name": [
"transportation_sdc_rev_fy2015",
"total_residential",
"parks_sdc_example_non_residential_reimbursement_fee",
"transportation_sdc_reimbursement_fee",
"transporation_sdc_example_non_residential_reimbursement_fee",
"transportation_sdc_example_non_residential_other_fee_2",
"has_your_city_issued_sdc_accomodations_in_last_3_year",
"city",
"does_the_city_have_sdcs",
"total_sdc_revenue_fy2013",
"… 86 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text",
"Number",
"… 86 more items"
],
"columns_description": [
"",
"Based on Example Building",
"",
"",
"",
"",
"",
"",
"",
"",
"… 86 more items"
],
"columns_format": [
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"precision": "2",
"align": "right"
},
{},
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"precision": "2",
"align": "right"
},
"… 86 more items"
],
"download_count": 1563,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-09-02T22:00:04.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Financial Data",
"domain_tags": [
"yoncalla",
"yamhill",
"yachats",
"wood village",
"wilsonville",
"west linn",
"westfir",
"waterloo",
"wasco",
"warrenton",
"… 130 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/nb7c-wkjq",
"link": "https://data.orcities.org/City-Financial-Data/System-Development-Charge-Survey-Data/nb7c-wkjq",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "City Governance Information",
"id": "39pj-mz5x",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset outlines details of city governance compiled from 242 city charters.",
"attribution": "League of Oregon Cities",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2020-03-06T21:43:50.000Z",
"createdAt": "2016-08-22T21:25:08.000Z",
"metadata_updated_at": "2020-03-06T21:43:50.000Z",
"data_updated_at": "2016-08-29T19:24:59.000Z",
"page_views": {
"page_views_last_week": 25,
"page_views_last_month": 95,
"page_views_total": 3249,
"page_views_last_week_log": 4.700439718141093,
"page_views_last_month_log": 6.584962500721156,
"page_views_total_log": 11.666224002803178
},
"columns_name": [
"Other Elected Positions: Treasurer",
"Reason for Vacancy: Destruction of Public Records",
"Reason for Vacancy: Absence from Meetings (# days or mtgs.)",
"Reason for Vacancy: Upon declaration by the council of the vacancy",
"Other Vacancy Procedure Information",
"Election Nomination Procedure: Filing Fee($)",
"Election Nomination Procedure: Prescribed by Ordinance",
"Election Qualifications: Review by Court of Competent Jurisdiction",
"Voter Approval Required: Utility Rate Increases",
"Purchasing Agent Designated: Mayor",
"… 161 more items"
],
"columns_field_name": [
"other_elected_positions_treasurer",
"reason_for_vacancy_destruction_of_public_records",
"reason_for_vacancy_absence_from_meetings_days_or_mtgs",
"reason_for_vacancy_upon_declaration_by_the_council_of_the_vacancy",
"other_vacancy_procedure_information",
"election_nomination_procedure_filing_fee",
"election_nomination_procedure_prescribed_by_ordinance",
"election_qualifications_review_by_court_of_competent_jurisdiction",
"voter_approval_required_utility_rate_increases",
"purchasing_agent_designated_mayor",
"… 161 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 161 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 161 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 161 more items"
],
"download_count": 2092,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-08-29T19:25:03.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"lostine",
"long creek",
"lonerock",
"lincoln city",
"lexington",
"lebanon",
"la pine",
"lakeview",
"lakeside",
"lake oswego",
"… 248 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/39pj-mz5x",
"link": "https://data.orcities.org/dataset/City-Governance-Information/39pj-mz5x",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "2019 Certified City Population Estimates",
"id": "ycuw-wfr6",
"resource_name": null,
"parent_fxf": [],
"description": "Population Estimates from Portland State University's Center for Populations Statistics. Estimates published December 2018.",
"attribution": "League of Oregon Cities",
"attribution_link": "http://www.orcities.org/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-01-02T20:43:45.000Z",
"createdAt": "2019-01-02T20:37:16.000Z",
"metadata_updated_at": "2019-01-02T20:43:45.000Z",
"data_updated_at": "2019-01-02T20:43:44.000Z",
"page_views": {
"page_views_last_week": 18,
"page_views_last_month": 78,
"page_views_total": 3218,
"page_views_last_week_log": 4.247927513443585,
"page_views_last_month_log": 6.303780748177103,
"page_views_total_log": 11.652396861477678
},
"columns_name": [
"Population",
"City"
],
"columns_field_name": [
"population",
"city"
],
"columns_datatype": [
"Number",
"Text"
],
"columns_description": [
"",
""
],
"columns_format": [
{},
{}
],
"download_count": 441,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2019-01-02T20:43:45.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"cities",
"city",
"estimates",
"population",
"psu"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/ycuw-wfr6",
"link": "https://data.orcities.org/dataset/2019-Certified-City-Population-Estimates/ycuw-wfr6",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "Transient Lodging Tax Revenues",
"id": "xvs2-d76x",
"resource_name": null,
"parent_fxf": [],
"description": "Transient Lodging Tax Revenues (in thousands of dollars) provided by Dean Runyan Associates",
"attribution": "Dean Runyan Associates",
"attribution_link": "http://www.deanrunyan.com/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2018-01-10T16:43:35.000Z",
"createdAt": "2016-10-10T18:02:11.000Z",
"metadata_updated_at": "2018-01-10T16:43:35.000Z",
"data_updated_at": "2018-01-10T16:43:04.000Z",
"page_views": {
"page_views_last_week": 10,
"page_views_last_month": 53,
"page_views_total": 2894,
"page_views_last_week_log": 3.4594316186372978,
"page_views_last_month_log": 5.754887502163469,
"page_views_total_log": 11.4993476328766
},
"columns_name": [
"2016",
"2015",
"2014",
"2012",
"2011",
"2010",
"2009",
"2008",
"2007",
"2005",
"… 7 more items"
],
"columns_field_name": [
"_2016",
"_2015",
"_2014",
"_2012",
"_2011",
"_2010",
"_2009",
"_2008",
"_2007",
"_2005",
"… 7 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 7 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 7 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 7 more items"
],
"download_count": 519,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-01-10T16:43:35.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Financial Data",
"domain_tags": [
"condon",
"central point",
"cascade locks",
"cannon beach",
"burns",
"brookings",
"bend",
"bandon",
"astoria",
"ashland",
"… 79 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/xvs2-d76x",
"link": "https://data.orcities.org/City-Financial-Data/Transient-Lodging-Tax-Revenues/xvs2-d76x",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "Annual Financial Report (ACFR) Data 2018",
"id": "cv56-ynmk",
"resource_name": null,
"parent_fxf": [],
"description": "This is the City Financial Data for fiscal year 2017. Note that this data has been expanded for FY2018 to include more detailed breakdown of city finances.",
"attribution": "League of Oregon Cities",
"attribution_link": "http://www.orcities.org/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-10-28T23:37:31.000Z",
"createdAt": "2018-10-08T19:41:57.000Z",
"metadata_updated_at": "2021-10-28T23:37:31.000Z",
"data_updated_at": "2018-10-08T20:01:31.000Z",
"page_views": {
"page_views_last_week": 14,
"page_views_last_month": 96,
"page_views_total": 2764,
"page_views_last_week_log": 3.9068905956085187,
"page_views_last_month_log": 6.599912842187128,
"page_views_total_log": 11.43306376512207
},
"columns_name": [
"Property Tax General",
"Urban Renewal District General Taxes",
"Total Property Tax Revenue",
"Rentals and Leases",
"Transient Lodging Tax",
"Permits/ Licenses/ Fees",
"SSR Streets",
"SSR General",
"SSR Tobacco",
"SSR Liquor",
"… 37 more items"
],
"columns_field_name": [
"property_tax_general",
"urban_renewal_district_general",
"total_property_tax_revenue",
"rentals_and_leases",
"transient_lodging_tax",
"permits_licenses_fees",
"ssr_streets",
"ssr_general",
"ssr_tobacco",
"ssr_liquor",
"… 37 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 37 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 37 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
"… 37 more items"
],
"download_count": 5684,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-10-08T20:01:32.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Financial Data",
"domain_tags": [
"toledo",
"troutdale",
"tualatin",
"turner",
"ukiah",
"umatilla",
"union",
"unity",
"vale",
"veneta",
"… 231 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/cv56-ynmk",
"link": "https://data.orcities.org/City-Financial-Data/Annual-Financial-Report-ACFR-Data-2018/cv56-ynmk",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
{
"resource": {
"name": "State Of The Cities 2017",
"id": "n9hh-kmv5",
"resource_name": null,
"parent_fxf": [],
"description": "This is the survey responses for the 2017 State of the Cities Report. This data has been coded based on survey response choices. Please consult the attached copy of the survey for more information.",
"attribution": "League of Oregon Cities",
"attribution_link": "http://www.orcities.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-02-15T20:08:13.000Z",
"createdAt": "2016-12-06T21:18:39.000Z",
"metadata_updated_at": "2019-02-15T20:08:13.000Z",
"data_updated_at": "2016-12-06T21:19:07.000Z",
"page_views": {
"page_views_last_week": 9,
"page_views_last_month": 26,
"page_views_total": 2711,
"page_views_last_week_log": 3.3219280948873626,
"page_views_last_month_log": 4.754887502163469,
"page_views_total_log": 11.405141463136344
},
"columns_name": [
"Q15_2 - Libraries",
"Q12 - Has your city seen an increase, decrease, or no change in city service dema...",
"Q15_8 - Social services",
"Q15_4 - Planning/permitting",
"Q22_1 - Mayor",
"Q18 - What are some of the most significant fiscal and operational challenges fac...",
"Q27_13 - Wage/Salary Costs",
"Q27_2 - Employee Healthcare",
"Q28 - As a result of increasing PERS rates, do you foresee (mark all that apply):",
"Q27_8 - Law Enforcement",
"… 68 more items"
],
"columns_field_name": [
"q15_2_libraries",
"q12_has_your_city_seen_an_increase_decrease_or_no_change_in_city_service_dema",
"q15_8_social_services",
"q15_4_planning_permitting",
"q22_1_mayor",
"q18_what_are_some_of_the_most_significant_fiscal_and_operational_challenges_fac",
"q27_13_wage_salary_costs",
"q27_2_employee_healthcare",
"q28_as_a_result_of_increasing_pers_rates_do_you_foresee_mark_all_that_apply",
"q27_8_law_enforcement",
"… 68 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Text",
"Text",
"Number",
"Number",
"Text",
"Number",
"… 68 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 68 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 68 more items"
],
"download_count": 730,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-12-06T21:28:37.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"amity",
"adams",
"sumpter",
"survey",
"sweet home",
"talent",
"tangent",
"the dalles",
"tigard",
"troutdale",
"… 142 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.orcities.org",
"license": "Public Domain"
},
"permalink": "https://data.orcities.org/d/n9hh-kmv5",
"link": "https://data.orcities.org/dataset/State-Of-The-Cities-2017/n9hh-kmv5",
"owner": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
},
"creator": {
"id": "qrvr-trm4",
"user_type": "interactive",
"display_name": "paljets"
}
},
"… 10 more items"
],
"resultSetSize": 67,
"timings": {
"serviceMillis": 41,
"searchMillis": [
21,
5
]
},
"warnings": []
}Attribution: Source: data.orcities.org. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Public Domain" in their Socrata metadata; the portal publishes no separate API licence and different datasets may carry different terms. Quoted as found in the portal's own catalogue.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Catalogue search
Use data.orcities.org (data-orcities-org) from fastCRW Pergamon, capability "Catalogue search" (catalog-search). You want to find a dataset on this portal by keyword and do not know its four-by-four id. Example options: q=taxi, offset=0, order=page_views_total DESC. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-orcities-org" and capability "catalog-search". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset metadata
Use data.orcities.org (data-orcities-org) from fastCRW Pergamon, capability "Dataset metadata" (dataset). You already hold a dataset id and need its columns, licence or description before querying rows. Example options: id=quxh-dcsg. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-orcities-org" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset inventory
Use data.orcities.org (data-orcities-org) from fastCRW Pergamon, capability "Dataset inventory" (datasets). You need to enumerate what this portal publishes, or page through its newest datasets. Example options: offset=0, order=createdAt, category=Transportation. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-orcities-org" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Row count
Use data.orcities.org (data-orcities-org) from fastCRW Pergamon, capability "Row count" (row-count). You need to know how large a dataset is before downloading it, or want a cheap liveness check. Example options: id=quxh-dcsg. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-orcities-org" and capability "row-count". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>