ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

10,057 rows where fips = "" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);