ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 1347 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- New Jersey 9
- Pennsylvania 9
- Florida 7
- Illinois 7
- Louisiana 7
- Rhode Island 7
- Texas 7
- Kentucky 4
- Massachusetts 4
- Maryland 3
- California 1
- Colorado 1
- Connecticut 1
- Georgia 1
- New York 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484426 | 2484426 | 2022-05-08 | East Baton Rouge | Louisiana | 22033 | 111314 | 1347 |
2481168 | 2481168 | 2022-05-07 | East Baton Rouge | Louisiana | 22033 | 111314 | 1347 |
2477910 | 2477910 | 2022-05-06 | East Baton Rouge | Louisiana | 22033 | 111314 | 1347 |
2474652 | 2474652 | 2022-05-05 | East Baton Rouge | Louisiana | 22033 | 111263 | 1347 |
2471395 | 2471395 | 2022-05-04 | East Baton Rouge | Louisiana | 22033 | 111210 | 1347 |
2468139 | 2468139 | 2022-05-03 | East Baton Rouge | Louisiana | 22033 | 111174 | 1347 |
2464884 | 2464884 | 2022-05-02 | East Baton Rouge | Louisiana | 22033 | 111118 | 1347 |
2427365 | 2427365 | 2022-04-20 | Denton | Texas | 48121 | 179853 | 1347 |
2424109 | 2424109 | 2022-04-19 | Denton | Texas | 48121 | 179791 | 1347 |
2420471 | 2420471 | 2022-04-18 | Luzerne | Pennsylvania | 42079 | 73703 | 1347 |
2420853 | 2420853 | 2022-04-18 | Denton | Texas | 48121 | 179697 | 1347 |
2417215 | 2417215 | 2022-04-17 | Luzerne | Pennsylvania | 42079 | 73677 | 1347 |
2413959 | 2413959 | 2022-04-16 | Luzerne | Pennsylvania | 42079 | 73652 | 1347 |
2404573 | 2404573 | 2022-04-13 | Denton | Texas | 48121 | 179621 | 1347 |
2283841 | 2283841 | 2022-03-07 | Westmoreland | Pennsylvania | 42129 | 79204 | 1347 |
2280589 | 2280589 | 2022-03-06 | Westmoreland | Pennsylvania | 42129 | 79190 | 1347 |
2216837 | 2216837 | 2022-02-15 | Lake | Florida | 12069 | 82492 | 1347 |
2213586 | 2213586 | 2022-02-14 | Lake | Florida | 12069 | 82492 | 1347 |
2210334 | 2210334 | 2022-02-13 | Lake | Florida | 12069 | 82492 | 1347 |
2210629 | 2210629 | 2022-02-13 | Lake | Illinois | 17097 | 144376 | 1347 |
2207081 | 2207081 | 2022-02-12 | Lake | Florida | 12069 | 82492 | 1347 |
2207376 | 2207376 | 2022-02-12 | Lake | Illinois | 17097 | 144376 | 1347 |
2203828 | 2203828 | 2022-02-11 | Lake | Florida | 12069 | 82492 | 1347 |
2204123 | 2204123 | 2022-02-11 | Lake | Illinois | 17097 | 144376 | 1347 |
2200575 | 2200575 | 2022-02-10 | Lake | Florida | 12069 | 80535 | 1347 |
2200870 | 2200870 | 2022-02-10 | Lake | Illinois | 17097 | 144376 | 1347 |
2197321 | 2197321 | 2022-02-09 | Lake | Florida | 12069 | 80535 | 1347 |
2150969 | 2150969 | 2022-01-25 | Nueces | Texas | 48355 | 84085 | 1347 |
2106571 | 2106571 | 2022-01-12 | Unknown | Illinois | 0 | 1347 | |
2100077 | 2100077 | 2022-01-10 | Will | Illinois | 17197 | 135633 | 1347 |
2065416 | 2065416 | 2021-12-30 | Morris | New Jersey | 34027 | 78029 | 1347 |
2062166 | 2062166 | 2021-12-29 | Morris | New Jersey | 34027 | 76077 | 1347 |
2018374 | 2018374 | 2021-12-16 | El Paso | Colorado | 8041 | 119116 | 1347 |
1873057 | 1873057 | 2021-11-01 | Baltimore city | Maryland | 24510 | 61808 | 1347 |
1869808 | 1869808 | 2021-10-31 | Baltimore city | Maryland | 24510 | 61762 | 1347 |
1855841 | 1855841 | 2021-10-27 | Stanislaus | California | 6099 | 87020 | 1347 |
1777227 | 1777227 | 2021-10-02 | Travis | Texas | 48453 | 115667 | 1347 |
1688933 | 1688933 | 2021-09-05 | Bucks | Pennsylvania | 42017 | 65599 | 1347 |
1685683 | 1685683 | 2021-09-04 | Bucks | Pennsylvania | 42017 | 65483 | 1347 |
1587753 | 1587753 | 2021-08-05 | Camden | New Jersey | 34007 | 57167 | 1347 |
1584502 | 1584502 | 2021-08-04 | Camden | New Jersey | 34007 | 57038 | 1347 |
1577265 | 1577265 | 2021-08-02 | Jefferson | Kentucky | 21111 | 85706 | 1347 |
1574017 | 1574017 | 2021-08-01 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1570769 | 1570769 | 2021-07-31 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1567521 | 1567521 | 2021-07-30 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1290475 | 1290475 | 2021-05-05 | Milwaukee | Wisconsin | 55079 | 115400 | 1347 |
1248770 | 1248770 | 2021-04-23 | Fulton | Georgia | 13121 | 95428 | 1347 |
1132650 | 1132650 | 2021-03-18 | Plymouth | Massachusetts | 25023 | 42203 | 1347 |
1083950 | 1083950 | 2021-03-03 | Hampden | Massachusetts | 25013 | 42105 | 1347 |
1009286 | 1009286 | 2021-02-08 | Montgomery | Maryland | 24031 | 60677 | 1347 |
964934 | 964934 | 2021-01-25 | Montgomery | Pennsylvania | 42091 | 46137 | 1347 |
961689 | 961689 | 2021-01-24 | Montgomery | Pennsylvania | 42091 | 45837 | 1347 |
900132 | 900132 | 2021-01-05 | Providence | Rhode Island | 44007 | 58946 | 1347 |
896887 | 896887 | 2021-01-04 | Providence | Rhode Island | 44007 | 58946 | 1347 |
893641 | 893641 | 2021-01-03 | Providence | Rhode Island | 44007 | 58946 | 1347 |
890395 | 890395 | 2021-01-02 | Providence | Rhode Island | 44007 | 58946 | 1347 |
887148 | 887148 | 2021-01-01 | Providence | Rhode Island | 44007 | 58946 | 1347 |
883903 | 883903 | 2020-12-31 | Providence | Rhode Island | 44007 | 58946 | 1347 |
880052 | 880052 | 2020-12-30 | Ocean | New Jersey | 34029 | 32087 | 1347 |
880658 | 880658 | 2020-12-30 | Providence | Rhode Island | 44007 | 58946 | 1347 |
817825 | 817825 | 2020-12-11 | Worcester | Massachusetts | 25027 | 31192 | 1347 |
611574 | 611574 | 2020-10-08 | Bexar | Texas | 48029 | 59335 | 1347 |
403811 | 403811 | 2020-08-05 | Union | New Jersey | 34039 | 16775 | 1347 |
390944 | 390944 | 2020-08-01 | Union | New Jersey | 34039 | 16716 | 1347 |
387728 | 387728 | 2020-07-31 | Union | New Jersey | 34039 | 16694 | 1347 |
374860 | 374860 | 2020-07-27 | Union | New Jersey | 34039 | 16551 | 1347 |
240434 | 240434 | 2020-06-15 | Fairfield | Connecticut | 9001 | 16338 | 1347 |
146375 | 146375 | 2020-05-15 | Middlesex | Massachusetts | 25017 | 18683 | 1347 |
117081 | 117081 | 2020-05-05 | Suffolk | New York | 36103 | 35275 | 1347 |
93062 | 93062 | 2020-04-27 | Cook | Illinois | 17031 | 31953 | 1347 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);