ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,057 rows where fips = "" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Missouri 644
- New York 381
- Rhode Island 371
- New Jersey 360
- Puerto Rico 359
- Guam 357
- Massachusetts 356
- Louisiana 354
- Arkansas 352
- Georgia 351
- Vermont 349
- Minnesota 346
- Michigan 345
- Connecticut 342
- Utah 342
- Florida 339
- Delaware 329
- Maryland 328
- Iowa 310
- New Hampshire 302
- North Dakota 284
- Maine 281
- Tennessee 278
- Alaska 272
- Illinois 234
- Oklahoma 207
- Washington 170
- Kansas 168
- Nebraska 161
- Northern Mariana Islands 146
- ...
county
- Unknown 9,079
- New York City 371
- Kansas City 352
- Joplin 255
fips
- - · 10,057 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092543 | 1092543 | 2021-03-06 | Unknown | Alaska | 257 | 0 | |
1092633 | 1092633 | 2021-03-06 | Unknown | Arkansas | 3285 | 0 | |
1092768 | 1092768 | 2021-03-06 | Unknown | Connecticut | 982 | 10 | |
1092773 | 1092773 | 2021-03-06 | Unknown | Delaware | 195 | 0 | |
1092838 | 1092838 | 2021-03-06 | Unknown | Florida | 3494 | 0 | |
1092987 | 1092987 | 2021-03-06 | Unknown | Georgia | 3515 | 11 | |
1093003 | 1093003 | 2021-03-06 | Unknown | Guam | 8718 | 134 | |
1093144 | 1093144 | 2021-03-06 | Unknown | Illinois | 0 | 237 | |
1093336 | 1093336 | 2021-03-06 | Unknown | Iowa | 8656 | 0 | |
1093446 | 1093446 | 2021-03-06 | Unknown | Kansas | 0 | 1022 | |
1093630 | 1093630 | 2021-03-06 | Unknown | Louisiana | 422 | 0 | |
1093676 | 1093676 | 2021-03-06 | Unknown | Maryland | 0 | 50 | |
1093693 | 1093693 | 2021-03-06 | Unknown | Massachusetts | 33585 | 9 | |
1093774 | 1093774 | 2021-03-06 | Unknown | Michigan | 0 | 12 | |
1093857 | 1093857 | 2021-03-06 | Unknown | Minnesota | 515 | 68 | |
1094000 | 1094000 | 2021-03-06 | Joplin | Missouri | 4810 | 101 | |
1094001 | 1094001 | 2021-03-06 | Kansas City | Missouri | 36799 | 530 | |
1094242 | 1094242 | 2021-03-06 | Unknown | New Hampshire | 1055 | 5 | |
1094263 | 1094263 | 2021-03-06 | Unknown | New Jersey | 1219 | 0 | |
1094326 | 1094326 | 2021-03-06 | New York City | New York | 748241 | 29760 | |
1094505 | 1094505 | 2021-03-06 | Unknown | North Dakota | 30 | 30 | |
1094592 | 1094592 | 2021-03-06 | Unknown | Ohio | 0 | 1 | |
1094673 | 1094673 | 2021-03-06 | Unknown | Oklahoma | 8 | 0 | |
1094853 | 1094853 | 2021-03-06 | Unknown | Puerto Rico | 4455 | 2059 | |
1094865 | 1094865 | 2021-03-06 | Unknown | Rhode Island | 12176 | 39 | |
1095066 | 1095066 | 2021-03-06 | Unknown | Tennessee | 8573 | 113 | |
1095353 | 1095353 | 2021-03-06 | Unknown | Utah | 1838 | 7 | |
1095370 | 1095370 | 2021-03-06 | Unknown | Vermont | 8 | 0 | |
1089297 | 1089297 | 2021-03-05 | Unknown | Alaska | 257 | 0 | |
1089387 | 1089387 | 2021-03-05 | Unknown | Arkansas | 3303 | 0 | |
1089522 | 1089522 | 2021-03-05 | Unknown | Connecticut | 982 | 10 | |
1089527 | 1089527 | 2021-03-05 | Unknown | Delaware | 195 | 0 | |
1089592 | 1089592 | 2021-03-05 | Unknown | Florida | 3491 | 0 | |
1089741 | 1089741 | 2021-03-05 | Unknown | Georgia | 3531 | 11 | |
1089757 | 1089757 | 2021-03-05 | Unknown | Guam | 8716 | 132 | |
1089898 | 1089898 | 2021-03-05 | Unknown | Illinois | 0 | 231 | |
1090090 | 1090090 | 2021-03-05 | Unknown | Iowa | 8266 | 0 | |
1090200 | 1090200 | 2021-03-05 | Unknown | Kansas | 0 | 1023 | |
1090384 | 1090384 | 2021-03-05 | Unknown | Louisiana | 422 | 0 | |
1090430 | 1090430 | 2021-03-05 | Unknown | Maryland | 0 | 45 | |
1090447 | 1090447 | 2021-03-05 | Unknown | Massachusetts | 33365 | 9 | |
1090528 | 1090528 | 2021-03-05 | Unknown | Michigan | 0 | 12 | |
1090611 | 1090611 | 2021-03-05 | Unknown | Minnesota | 515 | 68 | |
1090754 | 1090754 | 2021-03-05 | Joplin | Missouri | 4808 | 101 | |
1090755 | 1090755 | 2021-03-05 | Kansas City | Missouri | 36770 | 528 | |
1090996 | 1090996 | 2021-03-05 | Unknown | New Hampshire | 1037 | 5 | |
1091017 | 1091017 | 2021-03-05 | Unknown | New Jersey | 1207 | 0 | |
1091080 | 1091080 | 2021-03-05 | New York City | New York | 743683 | 29700 | |
1091259 | 1091259 | 2021-03-05 | Unknown | North Dakota | 30 | 30 | |
1091346 | 1091346 | 2021-03-05 | Unknown | Ohio | 0 | 1 | |
1091427 | 1091427 | 2021-03-05 | Unknown | Oklahoma | 4 | 0 | |
1091607 | 1091607 | 2021-03-05 | Unknown | Puerto Rico | 4443 | 2056 | |
1091619 | 1091619 | 2021-03-05 | Unknown | Rhode Island | 12176 | 39 | |
1091820 | 1091820 | 2021-03-05 | Unknown | Tennessee | 8549 | 113 | |
1092107 | 1092107 | 2021-03-05 | Unknown | Utah | 1758 | 7 | |
1092124 | 1092124 | 2021-03-05 | Unknown | Vermont | 8 | 0 | |
1086052 | 1086052 | 2021-03-04 | Unknown | Alaska | 256 | 0 | |
1086142 | 1086142 | 2021-03-04 | Unknown | Arkansas | 3300 | 0 | |
1086277 | 1086277 | 2021-03-04 | Unknown | Connecticut | 979 | 10 | |
1086282 | 1086282 | 2021-03-04 | Unknown | Delaware | 195 | 0 | |
1086347 | 1086347 | 2021-03-04 | Unknown | Florida | 3493 | 0 | |
1086496 | 1086496 | 2021-03-04 | Unknown | Georgia | 3530 | 11 | |
1086512 | 1086512 | 2021-03-04 | Unknown | Guam | 8716 | 132 | |
1086653 | 1086653 | 2021-03-04 | Unknown | Illinois | 0 | 218 | |
1086845 | 1086845 | 2021-03-04 | Unknown | Iowa | 7733 | 0 | |
1086955 | 1086955 | 2021-03-04 | Unknown | Kansas | 0 | 1021 | |
1087139 | 1087139 | 2021-03-04 | Unknown | Louisiana | 423 | 0 | |
1087185 | 1087185 | 2021-03-04 | Unknown | Maryland | 0 | 53 | |
1087202 | 1087202 | 2021-03-04 | Unknown | Massachusetts | 33137 | 9 | |
1087283 | 1087283 | 2021-03-04 | Unknown | Michigan | 0 | 12 | |
1087366 | 1087366 | 2021-03-04 | Unknown | Minnesota | 512 | 68 | |
1087509 | 1087509 | 2021-03-04 | Joplin | Missouri | 4803 | 101 | |
1087510 | 1087510 | 2021-03-04 | Kansas City | Missouri | 36746 | 525 | |
1087751 | 1087751 | 2021-03-04 | Unknown | New Hampshire | 1037 | 5 | |
1087772 | 1087772 | 2021-03-04 | Unknown | New Jersey | 1194 | 0 | |
1087835 | 1087835 | 2021-03-04 | New York City | New York | 739632 | 29640 | |
1088014 | 1088014 | 2021-03-04 | Unknown | North Dakota | 30 | 30 | |
1088181 | 1088181 | 2021-03-04 | Unknown | Oklahoma | 3 | 0 | |
1088361 | 1088361 | 2021-03-04 | Unknown | Puerto Rico | 4418 | 2053 | |
1088373 | 1088373 | 2021-03-04 | Unknown | Rhode Island | 11782 | 37 | |
1088574 | 1088574 | 2021-03-04 | Unknown | Tennessee | 8514 | 116 | |
1088861 | 1088861 | 2021-03-04 | Unknown | Utah | 1694 | 7 | |
1088878 | 1088878 | 2021-03-04 | Unknown | Vermont | 8 | 0 | |
1082806 | 1082806 | 2021-03-03 | Unknown | Alaska | 265 | 0 | |
1082896 | 1082896 | 2021-03-03 | Unknown | Arkansas | 3310 | 0 | |
1083031 | 1083031 | 2021-03-03 | Unknown | Connecticut | 978 | 10 | |
1083036 | 1083036 | 2021-03-03 | Unknown | Delaware | 195 | 0 | |
1083101 | 1083101 | 2021-03-03 | Unknown | Florida | 3493 | 0 | |
1083250 | 1083250 | 2021-03-03 | Unknown | Georgia | 3544 | 11 | |
1083266 | 1083266 | 2021-03-03 | Unknown | Guam | 8714 | 132 | |
1083407 | 1083407 | 2021-03-03 | Unknown | Illinois | 0 | 209 | |
1083599 | 1083599 | 2021-03-03 | Unknown | Iowa | 7154 | 0 | |
1083709 | 1083709 | 2021-03-03 | Unknown | Kansas | 0 | 1049 | |
1083893 | 1083893 | 2021-03-03 | Unknown | Louisiana | 424 | 0 | |
1083915 | 1083915 | 2021-03-03 | Unknown | Maine | 4 | 0 | |
1083940 | 1083940 | 2021-03-03 | Unknown | Maryland | 0 | 61 | |
1083957 | 1083957 | 2021-03-03 | Unknown | Massachusetts | 33007 | 8 | |
1084038 | 1084038 | 2021-03-03 | Unknown | Michigan | 0 | 12 | |
1084121 | 1084121 | 2021-03-03 | Unknown | Minnesota | 513 | 68 | |
1084264 | 1084264 | 2021-03-03 | Joplin | Missouri | 4798 | 101 |
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]);