fastCRW Pergamon
Government · US
data.cambridgema.gov
data.cambridgema.gov
Socrata open data portal at data.cambridgema.gov, publishing 447 public datasets from the publishing organisation, led by the Public Safety category.
Showing the catalogue
GET /v1/data/data-cambridgema-gov/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-cambridgema-gov/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.cambridgema.gov.
JSON
{
"results": [
{
"resource": {
"name": "COVID-19 Cases in Cambridge (Historical)",
"id": "inw8-ircw",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset is no longer being updated as of 12/8/2020. It is being retained on the Open Data Portal for its potential historical interest.\n\nA more current (but also no longer active) version of the dataset is available here: https://data.cambridgema.gov/dataset/COVID-19-Cases-in-Cambridge-Daily-Snapshot/5dms-3pz8/data \n\nCOVID-19 cases in the City of Cambridge as reported by the Cambridge Public Health Department. This dataset summarizes cases by age cohort and gender.\nCambridge Public Health Department (CPHD) data regarding case counts come directly from MDPH and their surveillance system (MAVEN). We use the language and terminology per the Centers for Disease Control and Prevention (CDC) guidance, and recent guidance categorizes all confirmed or presumptive positive cases as positive. CPHD understands that case counts may be higher, due to a number of factors:\n\n(1) Testing capabilities have been increased by other area lab organizations and hospitals and not all of the test results are reported to MDPH or CPHD.\n\n(2) People may be asymptomatic (or have very mild symptoms) and do not realize that they may have COVID-19 and need to be tested.\n\n(3) Providers may be offering diagnoses based on symptoms and history (rather than testing) and telling patients that they are likely positive and should stay home and self-quarantine for 14 days. (e.g, Someone might call their provider with a few symptoms and indicate that they were with someone from Biogen. In this case, the doctor may assume positive for COVID-19 and ask the patient to self-isolate at home for two weeks).\n\nThis is the process that the CPHD, and all local health departments, is following.\n\nTotal positive cases include total deaths. Any count <5 will be suppressed for privacy reasons",
"attribution": "Cambridge Department of Public Health",
"attribution_link": "https://www.challiance.org/help-center/covid-19-alert",
"contact_email": null,
"type": "dataset",
"updatedAt": "2024-04-18T20:25:49.000Z",
"createdAt": "2020-04-01T21:55:07.000Z",
"metadata_updated_at": "2024-04-18T20:25:49.000Z",
"data_updated_at": "2020-12-07T21:06:38.000Z",
"page_views": {
"page_views_last_week": 5,
"page_views_last_month": 26,
"page_views_total": 410291,
"page_views_last_week_log": 2.584962500721156,
"page_views_last_month_log": 4.754887502163469,
"page_views_total_log": 18.646291498828493
},
"columns_name": [
"Category",
"Percentage",
"Measure",
"Count"
],
"columns_field_name": [
"category",
"percentage",
"measure",
"count"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
""
],
"columns_format": [
{},
{
"precisionStyle": "percentage",
"percentScale": "1"
},
{},
{}
],
"download_count": 1016,
"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": "2020-04-15T22:25:11.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Health",
"domain_tags": [
"health and safety",
"covid-19"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Maintenance-Plan-Details",
"value": "This dataset is no longer being updated. It is being retained on the Open Data Portal for its potential historical interest."
},
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Historical Data"
},
{
"key": "Specific-Limitations_Limitations",
"value": "This dataset only displays confirmed cases of COVID-19. Total positive cases include total deaths. Any count <5 will be suppressed for privacy reasons. Starting on April 12, Cambridge Public Health Department began counting cases in nursing home and long term care facilities separately from cases among residents outside of those facilities. This impacted case counts going back to April 2, as we had previously reported a single aggregate number."
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/inw8-ircw",
"link": "https://data.cambridgema.gov/Public-Health/COVID-19-Cases-in-Cambridge-Historical-/inw8-ircw",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
{
"resource": {
"name": "Budget - Salaries",
"id": "ixg8-tyau",
"resource_name": null,
"parent_fxf": [],
"description": "Budgeted salary amounts by position for City of Cambridge departments and Cambridge Public Schools. Each row represents a budgeted position for a fiscal year and includes service area, department, division, position number, job title, and total budgeted salary. Cambridge's fiscal year runs from July 1 to June 30. Data currently covers FY2017 through FY2027. For more information, please visit www.cambridgema.gov/budget.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-05-05T20:29:15.000Z",
"createdAt": "2015-05-27T19:54:14.000Z",
"metadata_updated_at": "2026-05-05T20:29:15.000Z",
"data_updated_at": "2026-05-05T19:49:25.000Z",
"page_views": {
"page_views_last_week": 105,
"page_views_last_month": 373,
"page_views_total": 56070,
"page_views_last_week_log": 6.727920454563199,
"page_views_last_month_log": 8.546894459887637,
"page_views_total_log": 15.774967179372865
},
"columns_name": [
"Job Title",
"Total Salary",
"Fiscal Year",
"Service",
"Department",
"Division",
"Position Number"
],
"columns_field_name": [
"job_title",
"total_salary",
"fiscal_year",
"service",
"department",
"division",
"position_number"
],
"columns_datatype": [
"Text",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"Dollar amount",
"Cambridge's Fiscal Year (FY) runs from July 1 through June 30. For example, the start of FY17 is July 1, 2016.",
"The service program that each salary under. Service programs include general government, public safety, community maintenance & development, human resource development, education, and intergovernmental.",
"The name of the relevant city department",
"",
""
],
"columns_format": [
{},
{
"precision": "0",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{},
{}
],
"download_count": 2880,
"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": "2026-05-05T19:49:39.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Budget/Finance",
"domain_tags": [
"fiscal year",
"budget",
"government and finance"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Annually"
},
{
"key": "Specific-Limitations_Limitations",
"value": "The amounts listed in the “total salary” column includes only base wages and does not include benefits, pension, or overtime. "
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/ixg8-tyau",
"link": "https://data.cambridgema.gov/Budget-Finance/Budget-Salaries/ixg8-tyau",
"owner": {
"id": "swwb-x4qd",
"user_type": "interactive",
"display_name": "Jeana Franconi"
},
"creator": {
"id": "swwb-x4qd",
"user_type": "interactive",
"display_name": "Jeana Franconi"
}
},
{
"resource": {
"name": "Dogs of Cambridge Data Story",
"id": "qjvj-bebc",
"resource_name": null,
"parent_fxf": [
"h7p5-fjms",
"emzx-awst"
],
"description": "Based on the Dogs of Cambridge open dataset, which displays the name, breed, and approximate location of dogs in Cambridge.\n\nFor the open dataset, visit https://data.cambridgema.gov/General-Government/Dogs-of-Cambridge/sckh-3xyx",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-09-22T12:22:16.904Z",
"createdAt": "2017-09-21T18:24:37.000Z",
"metadata_updated_at": "2026-09-22T12:22:16.000Z",
"data_updated_at": "2026-09-22T12:22:16.904Z",
"page_views": {
"page_views_last_week": 46,
"page_views_last_month": 149,
"page_views_total": 29619,
"page_views_last_week_log": 5.554588851677638,
"page_views_last_month_log": 7.22881869049588,
"page_views_total_log": 14.85428402017621
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2017-09-21T18:24:38.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "As Needed"
}
]
},
"metadata": {
"domain": "data.cambridgema.gov"
},
"permalink": "https://data.cambridgema.gov/stories/s/qjvj-bebc",
"link": "https://data.cambridgema.gov/stories/s/qjvj-bebc",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
{
"resource": {
"name": "Crime Reports",
"id": "xuad-73uj",
"resource_name": null,
"parent_fxf": [],
"description": "List of crime incidents featured in the Cambridge Police Department’s Annual Crime Reports and reported in the City of Cambridge since 2009. Includes more than 40 crime types. Certain crime types are excluded due to confidentiality and/or protection of privacy. Please Note: Addresses do not represent the actual location of the crime, but a near approximation within 100 block ranges. For reports published by the Cambridge Police Department’s Crime Analysis Unit, visit https://www.cambridgema.gov/departments/cambridgepolice/publications\n\n\nBest Data at the Time: All statistics, including yearly totals and weighted averages, are calculated using the best available data at the time. Occasionally, after our reports are published, factors determined during investigation will cause us to reclassify a crime to a higher or lower category, and thus you may see slight discrepancies between current and past reports. In all cases, the more recent data is the more correct data.\n\nThis dataset will be periodically revised to ensure compliance with all local, state and federal privacy rights and legal requirements.",
"attribution": "City of Cambridge Police Department",
"attribution_link": "http://www.cambridgepolice.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-15T04:07:05.000Z",
"createdAt": "2014-05-30T14:33:29.000Z",
"metadata_updated_at": "2026-09-22T13:22:33.000Z",
"data_updated_at": "2026-10-15T04:07:05.000Z",
"page_views": {
"page_views_last_week": 170,
"page_views_last_month": 599,
"page_views_total": 28478,
"page_views_last_week_log": 7.417852514885899,
"page_views_last_month_log": 9.228818690495881,
"page_views_total_log": 14.797610868537408
},
"columns_name": [
"Crime Date Time",
"File Number",
"Police Response Districts",
"cambridge_neighborhoods",
"cambridge_cdd_zoning",
"Census Blocks 2010",
"Crime",
"Reporting Area",
"Reporting Area Lon",
"Reporting Area Lat",
"… 5 more items"
],
"columns_field_name": [
"crime_date_time",
"file_number",
":@computed_region_v7jj_366k",
":@computed_region_rffn_qbt6",
":@computed_region_swkg_bavi",
":@computed_region_e4yd_rwk4",
"crime",
"reporting_area",
"reporting_area_lon",
"reporting_area_lat",
"… 5 more items"
],
"columns_datatype": [
"Text",
"Text",
"Number",
"Number",
"Number",
"Number",
"Text",
"Number",
"Number",
"Number",
"… 5 more items"
],
"columns_description": [
"",
"",
"This column was automatically created in order to record in what polygon from the dataset 'Police Response Districts' (v7jj-366k) the point in column 'reporting_area_location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"This column was automatically created in order to record in what polygon from the dataset 'cambridge_neighborhoods' (rffn-qbt6) the point in column 'reporting_area_location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"This column was automatically created in order to record in what polygon from the dataset 'cambridge_cdd_zoning' (swkg-bavi) the point in column 'reporting_area_location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"This column was automatically created in order to record in what polygon from the dataset 'Census Blocks 2010' (e4yd-rwk4) the point in column 'reporting_area_location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"",
"",
"Longitude (east–west coordinate) of the centroid of the police reporting district associated with this record. This is not the location of the incident itself.",
"Latitude (north–south coordinate) of the centroid of the police reporting district associated with this record. This is not the location of the incident itself.",
"… 5 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
{},
"… 5 more items"
],
"download_count": 2507,
"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": "2025-08-18T21:56:54.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"health and safety",
"police",
"crime"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Monthly"
},
{
"key": "Specific-Limitations_Limitations",
"value": "This dataset will be periodically revised to ensure compliance with all local, state and federal privacy rights and legal requirements."
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/xuad-73uj",
"link": "https://data.cambridgema.gov/Public-Safety/Crime-Reports/xuad-73uj",
"owner": {
"id": "339j-yv65",
"user_type": "interactive",
"display_name": "StephenMaywalt"
},
"creator": {
"id": "339j-yv65",
"user_type": "interactive",
"display_name": "StephenMaywalt"
}
},
{
"resource": {
"name": "Police Department Crash Data - Updated",
"id": "gb5w-yva3",
"resource_name": null,
"parent_fxf": [],
"description": "List of crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge since 2015. \n\nAny data or text that may identify specific persons or companies has been omitted. Please see attached MassTRAC documentation for additional explanation about crash reporting data elements.\n\nNote: crashes involving pedestrians are indicated in the “P1 Non Motorist Desc” and “P2 Mon Motorist Desc” columns. When using Socrata's built in visualization tools to map crashes, please use the geocoded \"Location\" column. The column \"May involve cyclist\" specifies whether a given incident may involve a bicycle operator.",
"attribution": "City of Cambridge Public Safety",
"attribution_link": "http://www.cambridgepolice.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-15T04:11:35.000Z",
"createdAt": "2016-10-25T13:22:54.000Z",
"metadata_updated_at": "2025-01-13T19:53:03.000Z",
"data_updated_at": "2026-10-15T04:11:35.000Z",
"page_views": {
"page_views_last_week": 143,
"page_views_last_month": 490,
"page_views_total": 25309,
"page_views_last_week_log": 7.169925001442313,
"page_views_last_month_log": 8.939579214314692,
"page_views_total_log": 14.627419886998048
},
"columns_name": [
"P2 Drivers Lic Class 2",
"P1 Non Motorist Desc",
"P1 Drivers Lic Restrict",
"P1 Drivers Lic Class 2",
"P1 Injury",
"V2 Driver Distracted",
"V2 Is Hazmat",
"V2 Has Trailer",
"V2 Driver Contribution 2",
"V2 Driver Contribution",
"… 159 more items"
],
"columns_field_name": [
"p2_drivers_lic_class_2",
"p1_non_motorist_desc",
"p1_drivers_lic_restrict",
"p1_drivers_lic_class_2",
"p1_injury",
"v2_driver_distracted",
"v2_is_hazmat",
"v2_has_trailer",
"v2_driver_contribution_2",
"v2_driver_contribution",
"… 159 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 159 more items"
],
"columns_description": [
"",
"When Role of involved person is NON-MOTORIST (CYCLIST, PEDESTRIAN, etc.)",
"",
"",
"",
"",
"",
"",
"",
"",
"… 159 more items"
],
"columns_format": [
{},
{
"displayStyle": "plain",
"align": "left"
},
{},
{},
{},
{},
{},
{},
{},
{},
"… 159 more items"
],
"download_count": 2399,
"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": "2022-08-23T17:02:46.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"health and safety",
"crash",
"transportation",
"motor vehicles",
"vision zero",
"accidents"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Quarterly"
},
{
"key": "Civic-Innovation_Problem-Statements-Related-to-this-Data",
"value": "What are the significant trends in Cambridge crashes? How might Cambridge reduce crash rates?"
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/gb5w-yva3",
"link": "https://data.cambridgema.gov/Public-Safety/Police-Department-Crash-Data-Updated/gb5w-yva3",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
{
"resource": {
"name": "Daily Police Log",
"id": "3gki-wyrb",
"resource_name": null,
"parent_fxf": [],
"description": "The Daily Police Log offers a comprehensive overview of incidents reported to and by the Cambridge Police Department (CPD). Each entry represents a distinct call for service or police report, encompassing a wide range of public safety activities, from criminal offenses to non-criminal matters.\n\nTo protect the privacy of individuals involved, personal identifiers are omitted from the dataset, and location information is limited to the street or block level rather than precise addresses.\n\nThis dataset serves as a resource for community members, researchers, and policymakers interested in public safety trends, incident patterns, and the operational scope of the Cambridge Police Department.",
"attribution": "Cambridge Police Department",
"attribution_link": "https://www.cambridgema.gov/Departments/cambridgepolice/datacenter",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-20T21:00:54.000Z",
"createdAt": "2025-02-19T21:43:46.000Z",
"metadata_updated_at": "2026-10-20T21:00:53.000Z",
"data_updated_at": "2026-10-20T21:00:54.000Z",
"page_views": {
"page_views_last_week": 635,
"page_views_last_month": 2913,
"page_views_total": 22162,
"page_views_last_week_log": 9.312882955284357,
"page_views_last_month_log": 11.508785162064513,
"page_views_total_log": 14.435865558417737
},
"columns_name": [
"Type",
"ID",
"Last Updated",
"Date & Time",
"Subtype",
"Description",
"Location"
],
"columns_field_name": [
"type",
"id",
"last_updated",
"date_time",
"subtype",
"description",
"location"
],
"columns_datatype": [
"Text",
"Text",
"Calendar date",
"Calendar date",
"Text",
"Text",
"Text"
],
"columns_description": [
"A broad classification of the report (e.g., \"INCIDENT\").",
"A unique identifier assigned to each police report or incident log entry.",
"The timestamp of when the ETL (Extract, Transform, Load) process last detected a new input file for this record from the Police Department’s reviewer. This field does not indicate when the incident occurred or was modified by a human; it reflects technical update activity.",
"The date and time the police response or report was initiated.",
"A more specific classification of the report, often referencing Massachusetts General Laws (MGL). For example, “SHOPLIFTING BY ASPORTATION C266 S30A” refers to Chapter 266, Section 30A of the MGL.",
"A brief narrative summary of the incident as reported by the responding officer or staff.",
"The street or intersection where the incident occurred or was reported."
],
"columns_format": [
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{},
{},
{}
],
"download_count": 693,
"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": "2025-03-10T19:50:05.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"police",
"crime"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Maintenance-Plan-Details",
"value": "Logs are typically updated M-F for the previous business day(s)"
},
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Daily"
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/3gki-wyrb",
"link": "https://data.cambridgema.gov/Public-Safety/Daily-Police-Log/3gki-wyrb",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
{
"resource": {
"name": "Eco-Totem Broadway Bicycle Count",
"id": "q8v9-mcfg",
"resource_name": null,
"parent_fxf": [],
"description": "NOTE: Due to construction on Broadway, we have paused data collection on the Eco-Totem as of June 30, 2024. When construction is complete we will resume updating this dataset.\n\nThe “Eco-Totem” counter (made by the Montreal-based company Eco-Counter) counts cyclists via in-ground loop detectors embedded under the pavement of Broadway near Kendall Square. The device displays on a monitor how many cyclists pass by, and data is transferred in 15 minute increments daily from the device to Cambridge's Open Data Portal. Funding for this project was generously provided by the Helen & William Mazer Foundation.",
"attribution": null,
"attribution_link": "https://www.cambridgema.gov/CDD/Transportation/gettingaroundcambridge/bikesincambridge/ecototem",
"contact_email": null,
"type": "dataset",
"updatedAt": "2025-09-17T13:52:24.000Z",
"createdAt": "2016-02-01T16:06:55.000Z",
"metadata_updated_at": "2025-09-17T13:52:24.000Z",
"data_updated_at": "2024-09-05T16:00:15.000Z",
"page_views": {
"page_views_last_week": 29,
"page_views_last_month": 130,
"page_views_total": 21612,
"page_views_last_week_log": 4.906890595608519,
"page_views_last_month_log": 7.03342300153745,
"page_views_total_log": 14.399611719434427
},
"columns_name": [
"Date",
"Time",
"Day",
"Total",
"Eastbound",
"Westbound",
"DateTime"
],
"columns_field_name": [
"date",
"time",
"day",
"total",
"exits",
"entries",
"datetime"
],
"columns_datatype": [
"Calendar date",
"Text",
"Text",
"Number",
"Number",
"Number",
"Calendar date"
],
"columns_description": [
"The date (MM-DD-YYYY) that the counts were made.",
"The Ecototem counts the number of bicyclists that pass by in 15 minute increments. This column indicates the starting time (HHMMSS) of each 15 minute increment.",
"The day of the week that the counts were made.",
"The total number of bicyclists riding through the Kendall Square area on Broadway, both eastbound and westbound.",
"The total number of bicyclists riding eastbound through Kendall Square on Broadway.",
"The total number of bicyclists riding westbound through Kendall Square on Broadway.",
"The Broadway Eco Totem tracks the number of bicycles that pass by during fifteen minute increments. Numbers in this column signify the start of each increment. This field is used as a unique ID for the data."
],
"columns_format": [
{
"view": "date",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"view": "date_time",
"align": "left"
}
],
"download_count": 3358,
"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-03T21:19:51.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Transportation",
"domain_tags": [
"vision zero",
"bicycle count",
"kendall square",
"transportation",
"bicycles",
"eco-totem"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Maintenance-Plan-Details",
"value": "Automatic daily updates"
},
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "As Needed"
},
{
"key": "Specific-Limitations_Limitations",
"value": "All information that is presented here is accurate to the best of our knowledge at the time of publication. All information stated is subject to revision or retraction at any time. The Eco-Totem under-counts bicyclists to a small but significant degree, because it can only count people that ride over the in-ground tracking loop."
}
]
},
"metadata": {
"domain": "data.cambridgema.gov"
},
"permalink": "https://data.cambridgema.gov/d/q8v9-mcfg",
"link": "https://data.cambridgema.gov/Transportation/Eco-Totem-Broadway-Bicycle-Count/q8v9-mcfg",
"owner": {
"id": "q8ma-sa6g",
"user_type": "interactive",
"display_name": "Scott Walker"
},
"creator": {
"id": "q8ma-sa6g",
"user_type": "interactive",
"display_name": "Scott Walker"
}
},
{
"resource": {
"name": "Building Permits: Addition/Alteration",
"id": "qu2z-8suj",
"resource_name": null,
"parent_fxf": [],
"description": "List of permits related to the construction or the alteration of existing buildings in Cambridge. These permits cover construction that changes the structure, the footprint, or the volume of the building. This includes decks, porches, and additions, as well any reconstruction, renovation or repair to an existing structure. This dataset derives from Cambridge's ViewPoint permitting system.",
"attribution": "City of Cambridge Inspectional Services Department",
"attribution_link": "https://www.cambridgema.gov/inspection.aspx",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T09:45:38.000Z",
"createdAt": "2018-10-30T14:36:26.000Z",
"metadata_updated_at": "2026-10-23T09:44:05.000Z",
"data_updated_at": "2026-10-23T09:45:38.000Z",
"page_views": {
"page_views_last_week": 215,
"page_views_last_month": 1049,
"page_views_total": 21424,
"page_views_last_week_log": 7.754887502163469,
"page_views_last_month_log": 10.036173612553485,
"page_views_total_log": 14.387007583887224
},
"columns_name": [
"Building Cost",
"proposed HERS rating",
"Owner-Occupied",
"commercial high hazard",
"Location of Deck",
"Public Right-of-Way",
"FEMA earthwork description",
"Open Air Windows",
"Longitude",
"Balcony/Landing/Porch Construction",
"… 127 more items"
],
"columns_field_name": [
"building_cost",
"proposed_hers_rating",
"owner_occupied",
"commercial_high_hazard",
"location_of_deck",
"public_right",
"fema_earthwork_description",
"open_air_cafe",
"longitude",
"porch_balcony_dormer",
"… 127 more items"
],
"columns_datatype": [
"Number",
"Text",
"Checkbox",
"Text",
"Text",
"Checkbox",
"Text",
"Checkbox",
"Number",
"Checkbox",
"… 127 more items"
],
"columns_description": [
"Building Cost of Construction",
"",
"Is the property owner-occupied?",
"Commercial: high hazard",
"",
"Will the proposed work result in a new, abandoned or modified curb cut into the public right-of-way?",
"FEMA: Please describe the earthwork/regrading",
"Will the food establishment include open air cafe windows?",
"",
"Construction of dormers, bays, balconies, landings and/or porches",
"… 127 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "0",
"align": "left"
},
{},
{
"align": "left"
},
{},
{
"align": "left"
},
{
"align": "left"
},
{},
{
"align": "left"
},
{
"precisionStyle": "standard",
"align": "left"
},
{
"align": "left"
},
"… 127 more items"
],
"download_count": 2437,
"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": "2026-08-05T15:07:37.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Inspectional Services",
"domain_tags": [
"construction",
"permits",
"housing and development",
"alteration"
],
"domain_metadata": [
{
"key": "Civic-Innovation_Problem-Statements-Related-to-this-Data",
"value": "What can the permits’ application dates reveal about patterns of economic activity in the city?"
},
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Daily"
},
{
"key": "Specific-Limitations_Limitations",
"value": "Only completed applications are listed in this dataset. "
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/qu2z-8suj",
"link": "https://data.cambridgema.gov/Inspectional-Services/Building-Permits-Addition-Alteration/qu2z-8suj",
"owner": {
"id": "ejg6-p5fr",
"user_type": "interactive",
"display_name": "Steven Espinoza"
},
"creator": {
"id": "ejg6-p5fr",
"user_type": "interactive",
"display_name": "Steven Espinoza"
}
},
{
"resource": {
"name": "Short Term Rentals",
"id": "wxgv-w968",
"resource_name": null,
"parent_fxf": [],
"description": "Short-term rentals in Cambridge. Short-term rental (STR) refers to the rental of any dwelling unit of bedroom as residential accommodation for a duration of less than 30 consecutive days.",
"attribution": "City of Cambridge Inspectional Services Department",
"attribution_link": "https://www.cambridgema.gov/iwantto/registerashorttermrental",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T09:59:01.000Z",
"createdAt": "2018-04-04T13:36:17.000Z",
"metadata_updated_at": "2026-10-23T09:58:57.000Z",
"data_updated_at": "2026-10-23T09:59:01.000Z",
"page_views": {
"page_views_last_week": 117,
"page_views_last_month": 365,
"page_views_total": 19103,
"page_views_last_week_log": 6.882643049361842,
"page_views_last_month_log": 8.515699838284043,
"page_views_total_log": 14.221587121264806
},
"columns_name": [
"ID",
"applicant name",
"signature date 30487",
"link to listing",
"condo association name",
"condominium address",
"Property Type Additional Description",
"Other Platform Descriptions",
"Issue Date",
"Coordinates",
"… 44 more items"
],
"columns_field_name": [
"id",
"applicant_name",
"signature_date_30487",
"link_to_listing",
"condo_association_name",
"condominium_address",
"please_explain_below",
"please_list_additional_hosting_platforms",
"issue_date",
"coordinates",
"… 44 more items"
],
"columns_datatype": [
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"Text",
"Calendar date",
"Point",
"… 44 more items"
],
"columns_description": [
"Rental ID Number",
"",
"",
"link to advertising listings",
"",
"address of the condominium complex",
"Additional building property type information.",
"Other short term rental platforms that the rental is listed on. ",
"Date of Issue for the Short Term Rental certificate",
"latitude/longitude",
"… 44 more items"
],
"columns_format": [
{
"align": "left"
},
{},
{
"view": "date_monthdy"
},
{},
{},
{},
{
"align": "left"
},
{
"align": "left"
},
{
"view": "date_monthdy",
"align": "left"
},
{},
"… 44 more items"
],
"download_count": 4213,
"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": "2026-07-01T20:16:42.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Inspectional Services",
"domain_tags": [
"short-term rental",
"housing and development",
"airbnb",
"tourism"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Daily"
},
{
"key": "Specific-Limitations_Limitations",
"value": "Personal contact information for short-term rental operators is not available. This dataset only contains records from complete applications. Individual records in this dataset might change if revised by the applicant."
}
]
},
"metadata": {
"domain": "data.cambridgema.gov",
"license": "Open Data Commons Public Domain Dedication and License"
},
"permalink": "https://data.cambridgema.gov/d/wxgv-w968",
"link": "https://data.cambridgema.gov/Inspectional-Services/Short-Term-Rentals/wxgv-w968",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
{
"resource": {
"name": "Cambridge Property Database FY2016-FY2026",
"id": "eey2-rv59",
"resource_name": null,
"parent_fxf": [],
"description": "Extract of Cambridge Assessing Department on-line property database file for FY2016-FY2026. Contains residential, condo, commercial and exempt data. Please see attached Cambridge Property Data Metadata for field descriptions. Please refer to Cambridge's property database website for official assessment data: https://www.cambridgema.gov/propertydatabase",
"attribution": "Cambridge Assessing Dept",
"attribution_link": "https://www.cambridgema.gov/assess",
"contact_email": null,
"type": "dataset",
"updatedAt": "2025-12-10T20:18:04.000Z",
"createdAt": "2015-10-21T20:55:45.000Z",
"metadata_updated_at": "2025-12-09T18:54:25.000Z",
"data_updated_at": "2025-12-10T20:18:04.000Z",
"page_views": {
"page_views_last_week": 107,
"page_views_last_month": 407,
"page_views_total": 19009,
"page_views_last_week_log": 6.754887502163469,
"page_views_last_month_log": 8.672425341971495,
"page_views_total_log": 14.214470911535914
},
"columns_name": [
"Exterior_occupancy",
"Interior_Fireplaces",
"SaleDate",
"LandArea",
"AssessedValue",
"Book/Page",
"Coordinates",
"FinishedBasementGross",
"UnfinishedBasementGross",
"Parking_Covered",
"… 58 more items"
],
"columns_field_name": [
"exterior_occupancy",
"interior_fireplaces",
"saledate",
"landarea",
"assessedvalue",
"book_page",
"coordinates",
"finishedbasementgross",
"unfinishedbasementgross",
"parking_covered",
"… 58 more items"
],
"columns_datatype": [
"Text",
"Number",
"Calendar date",
"Number",
"Number",
"Text",
"Point",
"Number",
"Number",
"Number",
"… 58 more items"
],
"columns_description": [
"",
"",
"Date of last deed transaction",
"square feet",
"",
"Book and page of last deed recorded at registry of deeds",
"Map point for this property, based on the centroid of the parcel in the City’s GIS",
"",
"",
"",
"… 58 more items"
],
"columns_format": [
{},
{},
{
"view": "date",
"align": "left"
},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"align": "left"
},
{},
{},
{},
{},
"… 58 more items"
],
"download_count": 11539,
"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": "2025-12-09T18:54:25.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Assessing",
"domain_tags": [
"housing and development",
"residential",
"condominiums",
"commercial",
"assessing"
],
"domain_metadata": [
{
"key": "Maintenance-Plan_Estimated-Update-Frequency",
"value": "Annually"
},
{
"key": "Specific-Limitations_Limitations",
"value": "Only FY2019 and FY2020 entries in this dataset contain PropertyTaxAmount values. This open dataset is not the official information source for assessment records. Please refer to Cambridge's property database website for official data. https://www.cambridgema.gov/propertydatabase"
}
]
},
"metadata": {
"domain": "data.cambridgema.gov"
},
"permalink": "https://data.cambridgema.gov/d/eey2-rv59",
"link": "https://data.cambridgema.gov/Assessing/Cambridge-Property-Database-FY2016-FY2026/eey2-rv59",
"owner": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
},
"creator": {
"id": "4dyb-szia",
"user_type": "interactive",
"display_name": "Reinhard"
}
},
"… 10 more items"
],
"resultSetSize": 447,
"timings": {
"serviceMillis": 35,
"searchMillis": [
18,
5
]
},
"warnings": []
}Attribution: Source: data.cambridgema.gov. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Open Data Commons Public Domain Dedication and License" 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.cambridgema.gov (data-cambridgema-gov) 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-cambridgema-gov" 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.cambridgema.gov (data-cambridgema-gov) 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=ex75-8iwq. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-cambridgema-gov" 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.cambridgema.gov (data-cambridgema-gov) 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-cambridgema-gov" 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.cambridgema.gov (data-cambridgema-gov) 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=ex75-8iwq. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-cambridgema-gov" 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>