ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,902 rows where county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New Jersey 137
- Kentucky 136
- New York 136
- Ohio 134
- Iowa 130
- Pennsylvania 129
- Indiana 128
- Virginia 128
- Missouri 126
- Mississippi 125
- Georgia 124
- Tennessee 124
- North Carolina 119
- Illinois 112
fips 14
county 1
- Warren · 1,788 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386477 | 386477 | 2020-07-31 | Warren | Georgia | 13301 | 53 | 0 |
386629 | 386629 | 2020-07-31 | Warren | Illinois | 17187 | 179 | 0 |
386723 | 386723 | 2020-07-31 | Warren | Indiana | 18171 | 20 | 1 |
386821 | 386821 | 2020-07-31 | Warren | Iowa | 19181 | 503 | 1 |
387046 | 387046 | 2020-07-31 | Warren | Kentucky | 21227 | 2372 | 22 |
387421 | 387421 | 2020-07-31 | Warren | Mississippi | 28149 | 946 | 25 |
387540 | 387540 | 2020-07-31 | Warren | Missouri | 29219 | 153 | 0 |
387730 | 387730 | 2020-07-31 | Warren | New Jersey | 34041 | 1343 | 170 |
387815 | 387815 | 2020-07-31 | Warren | New York | 36113 | 300 | 31 |
387913 | 387913 | 2020-07-31 | Warren | North Carolina | 37185 | 238 | 6 |
388059 | 388059 | 2020-07-31 | Warren | Ohio | 39165 | 1551 | 35 |
388238 | 388238 | 2020-07-31 | Warren | Pennsylvania | 42123 | 15 | 1 |
388529 | 388529 | 2020-07-31 | Warren | Tennessee | 47177 | 375 | 4 |
388957 | 388957 | 2020-07-31 | Warren | Virginia | 51187 | 348 | 7 |
383259 | 383259 | 2020-07-30 | Warren | Georgia | 13301 | 50 | 0 |
383411 | 383411 | 2020-07-30 | Warren | Illinois | 17187 | 175 | 0 |
383505 | 383505 | 2020-07-30 | Warren | Indiana | 18171 | 20 | 1 |
383603 | 383603 | 2020-07-30 | Warren | Iowa | 19181 | 499 | 1 |
383828 | 383828 | 2020-07-30 | Warren | Kentucky | 21227 | 2327 | 22 |
384203 | 384203 | 2020-07-30 | Warren | Mississippi | 28149 | 930 | 24 |
384322 | 384322 | 2020-07-30 | Warren | Missouri | 29219 | 146 | 0 |
384513 | 384513 | 2020-07-30 | Warren | New Jersey | 34041 | 1340 | 170 |
384598 | 384598 | 2020-07-30 | Warren | New York | 36113 | 298 | 31 |
384696 | 384696 | 2020-07-30 | Warren | North Carolina | 37185 | 235 | 6 |
384842 | 384842 | 2020-07-30 | Warren | Ohio | 39165 | 1517 | 34 |
385021 | 385021 | 2020-07-30 | Warren | Pennsylvania | 42123 | 15 | 1 |
385312 | 385312 | 2020-07-30 | Warren | Tennessee | 47177 | 349 | 3 |
385740 | 385740 | 2020-07-30 | Warren | Virginia | 51187 | 345 | 7 |
380042 | 380042 | 2020-07-29 | Warren | Georgia | 13301 | 46 | 0 |
380194 | 380194 | 2020-07-29 | Warren | Illinois | 17187 | 175 | 0 |
380288 | 380288 | 2020-07-29 | Warren | Indiana | 18171 | 20 | 1 |
380386 | 380386 | 2020-07-29 | Warren | Iowa | 19181 | 486 | 1 |
380611 | 380611 | 2020-07-29 | Warren | Kentucky | 21227 | 2305 | 22 |
380987 | 380987 | 2020-07-29 | Warren | Mississippi | 28149 | 897 | 24 |
381106 | 381106 | 2020-07-29 | Warren | Missouri | 29219 | 138 | 0 |
381295 | 381295 | 2020-07-29 | Warren | New Jersey | 34041 | 1341 | 171 |
381380 | 381380 | 2020-07-29 | Warren | New York | 36113 | 298 | 31 |
381478 | 381478 | 2020-07-29 | Warren | North Carolina | 37185 | 231 | 6 |
381624 | 381624 | 2020-07-29 | Warren | Ohio | 39165 | 1481 | 33 |
381803 | 381803 | 2020-07-29 | Warren | Pennsylvania | 42123 | 15 | 1 |
382094 | 382094 | 2020-07-29 | Warren | Tennessee | 47177 | 339 | 3 |
382522 | 382522 | 2020-07-29 | Warren | Virginia | 51187 | 344 | 7 |
376825 | 376825 | 2020-07-28 | Warren | Georgia | 13301 | 46 | 0 |
376977 | 376977 | 2020-07-28 | Warren | Illinois | 17187 | 172 | 0 |
377071 | 377071 | 2020-07-28 | Warren | Indiana | 18171 | 20 | 1 |
377169 | 377169 | 2020-07-28 | Warren | Iowa | 19181 | 478 | 1 |
377394 | 377394 | 2020-07-28 | Warren | Kentucky | 21227 | 2261 | 21 |
377770 | 377770 | 2020-07-28 | Warren | Mississippi | 28149 | 886 | 24 |
377889 | 377889 | 2020-07-28 | Warren | Missouri | 29219 | 137 | 0 |
378077 | 378077 | 2020-07-28 | Warren | New Jersey | 34041 | 1335 | 170 |
378163 | 378163 | 2020-07-28 | Warren | New York | 36113 | 298 | 31 |
378261 | 378261 | 2020-07-28 | Warren | North Carolina | 37185 | 231 | 6 |
378407 | 378407 | 2020-07-28 | Warren | Ohio | 39165 | 1451 | 33 |
378586 | 378586 | 2020-07-28 | Warren | Pennsylvania | 42123 | 14 | 1 |
378877 | 378877 | 2020-07-28 | Warren | Tennessee | 47177 | 332 | 3 |
379305 | 379305 | 2020-07-28 | Warren | Virginia | 51187 | 344 | 7 |
373611 | 373611 | 2020-07-27 | Warren | Georgia | 13301 | 46 | 0 |
373762 | 373762 | 2020-07-27 | Warren | Illinois | 17187 | 170 | 0 |
373856 | 373856 | 2020-07-27 | Warren | Indiana | 18171 | 20 | 1 |
373954 | 373954 | 2020-07-27 | Warren | Iowa | 19181 | 474 | 1 |
374179 | 374179 | 2020-07-27 | Warren | Kentucky | 21227 | 2244 | 21 |
374555 | 374555 | 2020-07-27 | Warren | Mississippi | 28149 | 856 | 24 |
374674 | 374674 | 2020-07-27 | Warren | Missouri | 29219 | 135 | 0 |
374862 | 374862 | 2020-07-27 | Warren | New Jersey | 34041 | 1329 | 170 |
374947 | 374947 | 2020-07-27 | Warren | New York | 36113 | 294 | 31 |
375045 | 375045 | 2020-07-27 | Warren | North Carolina | 37185 | 228 | 6 |
375190 | 375190 | 2020-07-27 | Warren | Ohio | 39165 | 1421 | 31 |
375370 | 375370 | 2020-07-27 | Warren | Pennsylvania | 42123 | 14 | 1 |
375661 | 375661 | 2020-07-27 | Warren | Tennessee | 47177 | 317 | 3 |
376089 | 376089 | 2020-07-27 | Warren | Virginia | 51187 | 345 | 7 |
370399 | 370399 | 2020-07-26 | Warren | Georgia | 13301 | 45 | 0 |
370550 | 370550 | 2020-07-26 | Warren | Illinois | 17187 | 170 | 0 |
370644 | 370644 | 2020-07-26 | Warren | Indiana | 18171 | 20 | 1 |
370742 | 370742 | 2020-07-26 | Warren | Iowa | 19181 | 468 | 1 |
370967 | 370967 | 2020-07-26 | Warren | Kentucky | 21227 | 2223 | 21 |
371343 | 371343 | 2020-07-26 | Warren | Mississippi | 28149 | 853 | 24 |
371462 | 371462 | 2020-07-26 | Warren | Missouri | 29219 | 127 | 0 |
371650 | 371650 | 2020-07-26 | Warren | New Jersey | 34041 | 1326 | 169 |
371735 | 371735 | 2020-07-26 | Warren | New York | 36113 | 294 | 31 |
371833 | 371833 | 2020-07-26 | Warren | North Carolina | 37185 | 226 | 6 |
371978 | 371978 | 2020-07-26 | Warren | Ohio | 39165 | 1400 | 30 |
372157 | 372157 | 2020-07-26 | Warren | Pennsylvania | 42123 | 14 | 1 |
372448 | 372448 | 2020-07-26 | Warren | Tennessee | 47177 | 293 | 3 |
372875 | 372875 | 2020-07-26 | Warren | Virginia | 51187 | 342 | 7 |
367189 | 367189 | 2020-07-25 | Warren | Georgia | 13301 | 45 | 0 |
367340 | 367340 | 2020-07-25 | Warren | Illinois | 17187 | 164 | 0 |
367434 | 367434 | 2020-07-25 | Warren | Indiana | 18171 | 20 | 1 |
367532 | 367532 | 2020-07-25 | Warren | Iowa | 19181 | 457 | 1 |
367757 | 367757 | 2020-07-25 | Warren | Kentucky | 21227 | 2199 | 21 |
368132 | 368132 | 2020-07-25 | Warren | Mississippi | 28149 | 842 | 23 |
368251 | 368251 | 2020-07-25 | Warren | Missouri | 29219 | 127 | 0 |
368438 | 368438 | 2020-07-25 | Warren | New Jersey | 34041 | 1322 | 169 |
368523 | 368523 | 2020-07-25 | Warren | New York | 36113 | 293 | 31 |
368621 | 368621 | 2020-07-25 | Warren | North Carolina | 37185 | 225 | 6 |
368766 | 368766 | 2020-07-25 | Warren | Ohio | 39165 | 1383 | 30 |
368945 | 368945 | 2020-07-25 | Warren | Pennsylvania | 42123 | 14 | 1 |
369236 | 369236 | 2020-07-25 | Warren | Tennessee | 47177 | 282 | 3 |
369663 | 369663 | 2020-07-25 | Warren | Virginia | 51187 | 341 | 7 |
363982 | 363982 | 2020-07-24 | Warren | Georgia | 13301 | 44 | 0 |
364133 | 364133 | 2020-07-24 | Warren | Illinois | 17187 | 162 | 0 |
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);