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,902 rows where county = "Warren" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 14

fips 14

county 1

  • Warren · 10,902 ✖
Link rowid date ▲ county state fips cases deaths
2500115 2500115 2022-05-13 Warren Georgia 13301 1064 30
2500271 2500271 2022-05-13 Warren Illinois 17187 4089 87
2500366 2500366 2022-05-13 Warren Indiana 18171 2109 30
2500464 2500464 2022-05-13 Warren Iowa 19181 12591 134
2500692 2500692 2022-05-13 Warren Kentucky 21227 43102 372
2501068 2501068 2022-05-13 Warren Mississippi 28149 10250 202
2501187 2501187 2022-05-13 Warren Missouri 29219 8200 102
2501393 2501393 2022-05-13 Warren New Jersey 34041 24838 342
2501480 2501480 2022-05-13 Warren New York 36113 14739 129
2501578 2501578 2022-05-13 Warren North Carolina 37185 4381 45
2501727 2501727 2022-05-13 Warren Ohio 39165 58538 584
2501908 2501908 2022-05-13 Warren Pennsylvania 42123 7506 212
2502200 2502200 2022-05-13 Warren Tennessee 47177 13028 177
2502634 2502634 2022-05-13 Warren Virginia 51187 8675 157
2496857 2496857 2022-05-12 Warren Georgia 13301 1064 30
2497013 2497013 2022-05-12 Warren Illinois 17187 4082 87
2497108 2497108 2022-05-12 Warren Indiana 18171 2109 30
2497206 2497206 2022-05-12 Warren Iowa 19181 12591 134
2497434 2497434 2022-05-12 Warren Kentucky 21227 43102 372
2497810 2497810 2022-05-12 Warren Mississippi 28149 10250 202
2497929 2497929 2022-05-12 Warren Missouri 29219 8173 102
2498135 2498135 2022-05-12 Warren New Jersey 34041 24771 342
2498222 2498222 2022-05-12 Warren New York 36113 14739 129
2498320 2498320 2022-05-12 Warren North Carolina 37185 4381 45
2498469 2498469 2022-05-12 Warren Ohio 39165 58538 584
2498650 2498650 2022-05-12 Warren Pennsylvania 42123 7506 212
2498942 2498942 2022-05-12 Warren Tennessee 47177 13028 177
2499376 2499376 2022-05-12 Warren Virginia 51187 8672 156
2493599 2493599 2022-05-11 Warren Georgia 13301 1064 30
2493755 2493755 2022-05-11 Warren Illinois 17187 4080 87
2493850 2493850 2022-05-11 Warren Indiana 18171 2109 30
2493948 2493948 2022-05-11 Warren Iowa 19181 12591 134
2494176 2494176 2022-05-11 Warren Kentucky 21227 43102 372
2494552 2494552 2022-05-11 Warren Mississippi 28149 10250 202
2494671 2494671 2022-05-11 Warren Missouri 29219 8173 102
2494877 2494877 2022-05-11 Warren New Jersey 34041 24722 342
2494964 2494964 2022-05-11 Warren New York 36113 14693 129
2495062 2495062 2022-05-11 Warren North Carolina 37185 4381 45
2495211 2495211 2022-05-11 Warren Ohio 39165 58242 584
2495392 2495392 2022-05-11 Warren Pennsylvania 42123 7506 212
2495684 2495684 2022-05-11 Warren Tennessee 47177 13028 177
2496118 2496118 2022-05-11 Warren Virginia 51187 8661 156
2490341 2490341 2022-05-10 Warren Georgia 13301 1062 30
2490497 2490497 2022-05-10 Warren Illinois 17187 4080 87
2490592 2490592 2022-05-10 Warren Indiana 18171 2107 30
2490690 2490690 2022-05-10 Warren Iowa 19181 12547 134
2490918 2490918 2022-05-10 Warren Kentucky 21227 43102 372
2491294 2491294 2022-05-10 Warren Mississippi 28149 10250 202
2491413 2491413 2022-05-10 Warren Missouri 29219 8173 102
2491619 2491619 2022-05-10 Warren New Jersey 34041 24681 342
2491706 2491706 2022-05-10 Warren New York 36113 14635 129
2491804 2491804 2022-05-10 Warren North Carolina 37185 4350 45
2491953 2491953 2022-05-10 Warren Ohio 39165 58242 584
2492134 2492134 2022-05-10 Warren Pennsylvania 42123 7446 210
2492426 2492426 2022-05-10 Warren Tennessee 47177 13013 176
2492860 2492860 2022-05-10 Warren Virginia 51187 8655 156
2487084 2487084 2022-05-09 Warren Georgia 13301 1062 30
2487240 2487240 2022-05-09 Warren Illinois 17187 4078 87
2487335 2487335 2022-05-09 Warren Indiana 18171 2107 30
2487433 2487433 2022-05-09 Warren Iowa 19181 12547 134
2487661 2487661 2022-05-09 Warren Kentucky 21227 43102 372
2488036 2488036 2022-05-09 Warren Mississippi 28149 10250 202
2488155 2488155 2022-05-09 Warren Missouri 29219 8173 102
2488361 2488361 2022-05-09 Warren New Jersey 34041 24643 342
2488448 2488448 2022-05-09 Warren New York 36113 14616 129
2488546 2488546 2022-05-09 Warren North Carolina 37185 4350 45
2488695 2488695 2022-05-09 Warren Ohio 39165 58242 584
2488876 2488876 2022-05-09 Warren Pennsylvania 42123 7446 210
2489168 2489168 2022-05-09 Warren Tennessee 47177 13013 176
2489602 2489602 2022-05-09 Warren Virginia 51187 8649 156
2483826 2483826 2022-05-08 Warren Georgia 13301 1062 30
2483982 2483982 2022-05-08 Warren Illinois 17187 4071 87
2484077 2484077 2022-05-08 Warren Indiana 18171 2107 30
2484175 2484175 2022-05-08 Warren Iowa 19181 12547 134
2484403 2484403 2022-05-08 Warren Kentucky 21227 43044 370
2484779 2484779 2022-05-08 Warren Mississippi 28149 10232 202
2484898 2484898 2022-05-08 Warren Missouri 29219 8173 102
2485104 2485104 2022-05-08 Warren New Jersey 34041 24623 342
2485191 2485191 2022-05-08 Warren New York 36113 14588 129
2485289 2485289 2022-05-08 Warren North Carolina 37185 4350 45
2485438 2485438 2022-05-08 Warren Ohio 39165 58242 584
2485619 2485619 2022-05-08 Warren Pennsylvania 42123 7446 210
2485911 2485911 2022-05-08 Warren Tennessee 47177 13013 176
2486345 2486345 2022-05-08 Warren Virginia 51187 8632 156
2480568 2480568 2022-05-07 Warren Georgia 13301 1062 30
2480724 2480724 2022-05-07 Warren Illinois 17187 4071 87
2480819 2480819 2022-05-07 Warren Indiana 18171 2107 30
2480917 2480917 2022-05-07 Warren Iowa 19181 12547 134
2481145 2481145 2022-05-07 Warren Kentucky 21227 43044 370
2481521 2481521 2022-05-07 Warren Mississippi 28149 10232 202
2481640 2481640 2022-05-07 Warren Missouri 29219 8173 102
2481846 2481846 2022-05-07 Warren New Jersey 34041 24592 342
2481933 2481933 2022-05-07 Warren New York 36113 14541 128
2482031 2482031 2022-05-07 Warren North Carolina 37185 4350 45
2482180 2482180 2022-05-07 Warren Ohio 39165 58242 584
2482361 2482361 2022-05-07 Warren Pennsylvania 42123 7446 210
2482653 2482653 2022-05-07 Warren Tennessee 47177 13013 176
2483087 2483087 2022-05-07 Warren Virginia 51187 8632 156
2477310 2477310 2022-05-06 Warren Georgia 13301 1062 30
2477466 2477466 2022-05-06 Warren Illinois 17187 4071 87

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