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

9,322 rows where county = "Lee" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 12

fips 12

county 1

  • Lee · 9,322 ✖
Link rowid date ▲ county state fips cases deaths
2499615 2499615 2022-05-13 Lee Alabama 1081 37888 341
2499724 2499724 2022-05-13 Lee Arkansas 5077 2912 59
2499932 2499932 2022-05-13 Lee Florida 12071 191963 2158
2500053 2500053 2022-05-13 Lee Georgia 13177 7387 103
2500228 2500228 2022-05-13 Lee Illinois 17103 9020 118
2500428 2500428 2022-05-13 Lee Iowa 19111 7880 142
2500643 2500643 2022-05-13 Lee Kentucky 21129 2951 52
2501033 2501033 2022-05-13 Lee Mississippi 28081 26783 301
2501538 2501538 2022-05-13 Lee North Carolina 37105 16113 151
2502029 2502029 2022-05-13 Lee South Carolina 45061 4272 95
2502350 2502350 2022-05-13 Lee Texas 48287 4278 60
2502578 2502578 2022-05-13 Lee Virginia 51105 6185 93
2496357 2496357 2022-05-12 Lee Alabama 1081 37876 341
2496466 2496466 2022-05-12 Lee Arkansas 5077 2912 59
2496674 2496674 2022-05-12 Lee Florida 12071 191963 2158
2496795 2496795 2022-05-12 Lee Georgia 13177 7387 103
2496970 2496970 2022-05-12 Lee Illinois 17103 9004 118
2497170 2497170 2022-05-12 Lee Iowa 19111 7880 142
2497385 2497385 2022-05-12 Lee Kentucky 21129 2951 52
2497775 2497775 2022-05-12 Lee Mississippi 28081 26783 301
2498280 2498280 2022-05-12 Lee North Carolina 37105 16113 151
2498771 2498771 2022-05-12 Lee South Carolina 45061 4272 95
2499092 2499092 2022-05-12 Lee Texas 48287 4276 60
2499320 2499320 2022-05-12 Lee Virginia 51105 6188 93
2493099 2493099 2022-05-11 Lee Alabama 1081 37858 341
2493208 2493208 2022-05-11 Lee Arkansas 5077 2912 59
2493416 2493416 2022-05-11 Lee Florida 12071 191963 2158
2493537 2493537 2022-05-11 Lee Georgia 13177 7387 103
2493712 2493712 2022-05-11 Lee Illinois 17103 8994 118
2493912 2493912 2022-05-11 Lee Iowa 19111 7880 142
2494127 2494127 2022-05-11 Lee Kentucky 21129 2951 52
2494517 2494517 2022-05-11 Lee Mississippi 28081 26783 301
2495022 2495022 2022-05-11 Lee North Carolina 37105 16113 151
2495513 2495513 2022-05-11 Lee South Carolina 45061 4272 95
2495834 2495834 2022-05-11 Lee Texas 48287 4273 60
2496062 2496062 2022-05-11 Lee Virginia 51105 6187 93
2489841 2489841 2022-05-10 Lee Alabama 1081 37849 341
2489950 2489950 2022-05-10 Lee Arkansas 5077 2912 59
2490158 2490158 2022-05-10 Lee Florida 12071 191963 2156
2490279 2490279 2022-05-10 Lee Georgia 13177 7374 103
2490454 2490454 2022-05-10 Lee Illinois 17103 8983 118
2490654 2490654 2022-05-10 Lee Iowa 19111 7866 142
2490869 2490869 2022-05-10 Lee Kentucky 21129 2951 52
2491259 2491259 2022-05-10 Lee Mississippi 28081 26783 301
2491764 2491764 2022-05-10 Lee North Carolina 37105 16052 151
2492255 2492255 2022-05-10 Lee South Carolina 45061 4266 95
2492576 2492576 2022-05-10 Lee Texas 48287 4270 60
2492804 2492804 2022-05-10 Lee Virginia 51105 6188 93
2486584 2486584 2022-05-09 Lee Alabama 1081 37830 340
2486693 2486693 2022-05-09 Lee Arkansas 5077 2912 59
2486901 2486901 2022-05-09 Lee Florida 12071 191963 2156
2487022 2487022 2022-05-09 Lee Georgia 13177 7374 103
2487197 2487197 2022-05-09 Lee Illinois 17103 8972 118
2487397 2487397 2022-05-09 Lee Iowa 19111 7866 142
2487612 2487612 2022-05-09 Lee Kentucky 21129 2951 52
2488002 2488002 2022-05-09 Lee Mississippi 28081 26783 301
2488506 2488506 2022-05-09 Lee North Carolina 37105 16052 151
2488997 2488997 2022-05-09 Lee South Carolina 45061 4266 95
2489318 2489318 2022-05-09 Lee Texas 48287 4270 60
2489546 2489546 2022-05-09 Lee Virginia 51105 6187 93
2483326 2483326 2022-05-08 Lee Alabama 1081 37818 340
2483435 2483435 2022-05-08 Lee Arkansas 5077 2912 59
2483643 2483643 2022-05-08 Lee Florida 12071 191963 2156
2483764 2483764 2022-05-08 Lee Georgia 13177 7374 103
2483939 2483939 2022-05-08 Lee Illinois 17103 8945 118
2484139 2484139 2022-05-08 Lee Iowa 19111 7866 142
2484354 2484354 2022-05-08 Lee Kentucky 21129 2948 52
2484744 2484744 2022-05-08 Lee Mississippi 28081 26744 301
2485249 2485249 2022-05-08 Lee North Carolina 37105 16052 151
2485740 2485740 2022-05-08 Lee South Carolina 45061 4266 95
2486061 2486061 2022-05-08 Lee Texas 48287 4269 60
2486289 2486289 2022-05-08 Lee Virginia 51105 6184 93
2480068 2480068 2022-05-07 Lee Alabama 1081 37818 340
2480177 2480177 2022-05-07 Lee Arkansas 5077 2912 59
2480385 2480385 2022-05-07 Lee Florida 12071 191963 2156
2480506 2480506 2022-05-07 Lee Georgia 13177 7374 103
2480681 2480681 2022-05-07 Lee Illinois 17103 8945 118
2480881 2480881 2022-05-07 Lee Iowa 19111 7866 142
2481096 2481096 2022-05-07 Lee Kentucky 21129 2948 52
2481486 2481486 2022-05-07 Lee Mississippi 28081 26744 301
2481991 2481991 2022-05-07 Lee North Carolina 37105 16052 151
2482482 2482482 2022-05-07 Lee South Carolina 45061 4266 95
2482803 2482803 2022-05-07 Lee Texas 48287 4269 60
2483031 2483031 2022-05-07 Lee Virginia 51105 6184 93
2476810 2476810 2022-05-06 Lee Alabama 1081 37818 340
2476919 2476919 2022-05-06 Lee Arkansas 5077 2912 59
2477127 2477127 2022-05-06 Lee Florida 12071 191963 2156
2477248 2477248 2022-05-06 Lee Georgia 13177 7374 103
2477423 2477423 2022-05-06 Lee Illinois 17103 8945 118
2477623 2477623 2022-05-06 Lee Iowa 19111 7866 142
2477838 2477838 2022-05-06 Lee Kentucky 21129 2948 52
2478228 2478228 2022-05-06 Lee Mississippi 28081 26744 301
2478733 2478733 2022-05-06 Lee North Carolina 37105 16052 151
2479224 2479224 2022-05-06 Lee South Carolina 45061 4266 95
2479545 2479545 2022-05-06 Lee Texas 48287 4269 60
2479773 2479773 2022-05-06 Lee Virginia 51105 6184 93
2473552 2473552 2022-05-05 Lee Alabama 1081 37815 340
2473661 2473661 2022-05-05 Lee Arkansas 5077 2912 59
2473869 2473869 2022-05-05 Lee Florida 12071 190313 2156
2473990 2473990 2022-05-05 Lee Georgia 13177 7374 103

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