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 214
- Kentucky 213
- New York 213
- Ohio 211
- Iowa 207
- Pennsylvania 206
- Indiana 205
- Virginia 205
- Missouri 203
- Mississippi 202
- Georgia 201
- Tennessee 201
- North Carolina 196
- Illinois 189
fips 14
county 1
- Warren · 2,866 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635424 | 635424 | 2020-10-16 | Warren | Georgia | 13301 | 181 | 5 |
635578 | 635578 | 2020-10-16 | Warren | Illinois | 17187 | 432 | 6 |
635672 | 635672 | 2020-10-16 | Warren | Indiana | 18171 | 66 | 1 |
635770 | 635770 | 2020-10-16 | Warren | Iowa | 19181 | 1126 | 6 |
635998 | 635998 | 2020-10-16 | Warren | Kentucky | 21227 | 4894 | 57 |
636373 | 636373 | 2020-10-16 | Warren | Mississippi | 28149 | 1511 | 54 |
636492 | 636492 | 2020-10-16 | Warren | Missouri | 29219 | 643 | 1 |
636696 | 636696 | 2020-10-16 | Warren | New Jersey | 34041 | 1515 | 171 |
636782 | 636782 | 2020-10-16 | Warren | New York | 36113 | 437 | 30 |
636880 | 636880 | 2020-10-16 | Warren | North Carolina | 37185 | 385 | 7 |
637026 | 637026 | 2020-10-16 | Warren | Ohio | 39165 | 3799 | 60 |
637207 | 637207 | 2020-10-16 | Warren | Pennsylvania | 42123 | 59 | 1 |
637498 | 637498 | 2020-10-16 | Warren | Tennessee | 47177 | 1283 | 9 |
637930 | 637930 | 2020-10-16 | Warren | Virginia | 51187 | 514 | 14 |
632178 | 632178 | 2020-10-15 | Warren | Georgia | 13301 | 181 | 5 |
632332 | 632332 | 2020-10-15 | Warren | Illinois | 17187 | 428 | 6 |
632426 | 632426 | 2020-10-15 | Warren | Indiana | 18171 | 61 | 1 |
632524 | 632524 | 2020-10-15 | Warren | Iowa | 19181 | 1108 | 6 |
632752 | 632752 | 2020-10-15 | Warren | Kentucky | 21227 | 4841 | 57 |
633127 | 633127 | 2020-10-15 | Warren | Mississippi | 28149 | 1486 | 54 |
633246 | 633246 | 2020-10-15 | Warren | Missouri | 29219 | 629 | 1 |
633450 | 633450 | 2020-10-15 | Warren | New Jersey | 34041 | 1508 | 171 |
633536 | 633536 | 2020-10-15 | Warren | New York | 36113 | 434 | 30 |
633634 | 633634 | 2020-10-15 | Warren | North Carolina | 37185 | 383 | 7 |
633780 | 633780 | 2020-10-15 | Warren | Ohio | 39165 | 3735 | 59 |
633961 | 633961 | 2020-10-15 | Warren | Pennsylvania | 42123 | 58 | 1 |
634253 | 634253 | 2020-10-15 | Warren | Tennessee | 47177 | 1282 | 9 |
634685 | 634685 | 2020-10-15 | Warren | Virginia | 51187 | 514 | 14 |
628934 | 628934 | 2020-10-14 | Warren | Georgia | 13301 | 181 | 5 |
629088 | 629088 | 2020-10-14 | Warren | Illinois | 17187 | 414 | 6 |
629182 | 629182 | 2020-10-14 | Warren | Indiana | 18171 | 61 | 1 |
629280 | 629280 | 2020-10-14 | Warren | Iowa | 19181 | 1095 | 6 |
629508 | 629508 | 2020-10-14 | Warren | Kentucky | 21227 | 4804 | 57 |
629882 | 629882 | 2020-10-14 | Warren | Mississippi | 28149 | 1481 | 54 |
630001 | 630001 | 2020-10-14 | Warren | Missouri | 29219 | 623 | 2 |
630205 | 630205 | 2020-10-14 | Warren | New Jersey | 34041 | 1506 | 171 |
630291 | 630291 | 2020-10-14 | Warren | New York | 36113 | 432 | 30 |
630389 | 630389 | 2020-10-14 | Warren | North Carolina | 37185 | 381 | 7 |
630535 | 630535 | 2020-10-14 | Warren | Ohio | 39165 | 3679 | 59 |
630716 | 630716 | 2020-10-14 | Warren | Pennsylvania | 42123 | 58 | 1 |
631008 | 631008 | 2020-10-14 | Warren | Tennessee | 47177 | 1252 | 9 |
631440 | 631440 | 2020-10-14 | Warren | Virginia | 51187 | 495 | 13 |
625691 | 625691 | 2020-10-13 | Warren | Georgia | 13301 | 180 | 5 |
625845 | 625845 | 2020-10-13 | Warren | Illinois | 17187 | 399 | 6 |
625939 | 625939 | 2020-10-13 | Warren | Indiana | 18171 | 60 | 1 |
626037 | 626037 | 2020-10-13 | Warren | Iowa | 19181 | 1079 | 6 |
626264 | 626264 | 2020-10-13 | Warren | Kentucky | 21227 | 4754 | 57 |
626638 | 626638 | 2020-10-13 | Warren | Mississippi | 28149 | 1476 | 53 |
626757 | 626757 | 2020-10-13 | Warren | Missouri | 29219 | 610 | 1 |
626961 | 626961 | 2020-10-13 | Warren | New Jersey | 34041 | 1501 | 171 |
627047 | 627047 | 2020-10-13 | Warren | New York | 36113 | 431 | 30 |
627145 | 627145 | 2020-10-13 | Warren | North Carolina | 37185 | 380 | 7 |
627291 | 627291 | 2020-10-13 | Warren | Ohio | 39165 | 3606 | 59 |
627472 | 627472 | 2020-10-13 | Warren | Pennsylvania | 42123 | 57 | 1 |
627764 | 627764 | 2020-10-13 | Warren | Tennessee | 47177 | 1230 | 9 |
628196 | 628196 | 2020-10-13 | Warren | Virginia | 51187 | 493 | 13 |
622448 | 622448 | 2020-10-12 | Warren | Georgia | 13301 | 179 | 5 |
622603 | 622603 | 2020-10-12 | Warren | Illinois | 17187 | 394 | 5 |
622697 | 622697 | 2020-10-12 | Warren | Indiana | 18171 | 60 | 1 |
622795 | 622795 | 2020-10-12 | Warren | Iowa | 19181 | 1065 | 6 |
623022 | 623022 | 2020-10-12 | Warren | Kentucky | 21227 | 4718 | 57 |
623396 | 623396 | 2020-10-12 | Warren | Mississippi | 28149 | 1470 | 53 |
623515 | 623515 | 2020-10-12 | Warren | Missouri | 29219 | 607 | 1 |
623719 | 623719 | 2020-10-12 | Warren | New Jersey | 34041 | 1493 | 171 |
623805 | 623805 | 2020-10-12 | Warren | New York | 36113 | 430 | 30 |
623903 | 623903 | 2020-10-12 | Warren | North Carolina | 37185 | 378 | 7 |
624049 | 624049 | 2020-10-12 | Warren | Ohio | 39165 | 3564 | 59 |
624230 | 624230 | 2020-10-12 | Warren | Pennsylvania | 42123 | 56 | 1 |
624522 | 624522 | 2020-10-12 | Warren | Tennessee | 47177 | 1230 | 9 |
624953 | 624953 | 2020-10-12 | Warren | Virginia | 51187 | 490 | 13 |
619205 | 619205 | 2020-10-11 | Warren | Georgia | 13301 | 177 | 5 |
619359 | 619359 | 2020-10-11 | Warren | Illinois | 17187 | 393 | 5 |
619453 | 619453 | 2020-10-11 | Warren | Indiana | 18171 | 56 | 1 |
619551 | 619551 | 2020-10-11 | Warren | Iowa | 19181 | 1061 | 6 |
619778 | 619778 | 2020-10-11 | Warren | Kentucky | 21227 | 4664 | 57 |
620153 | 620153 | 2020-10-11 | Warren | Mississippi | 28149 | 1470 | 53 |
620272 | 620272 | 2020-10-11 | Warren | Missouri | 29219 | 604 | 1 |
620476 | 620476 | 2020-10-11 | Warren | New Jersey | 34041 | 1493 | 171 |
620562 | 620562 | 2020-10-11 | Warren | New York | 36113 | 429 | 30 |
620660 | 620660 | 2020-10-11 | Warren | North Carolina | 37185 | 378 | 7 |
620806 | 620806 | 2020-10-11 | Warren | Ohio | 39165 | 3543 | 59 |
620987 | 620987 | 2020-10-11 | Warren | Pennsylvania | 42123 | 56 | 1 |
621279 | 621279 | 2020-10-11 | Warren | Tennessee | 47177 | 1199 | 9 |
621710 | 621710 | 2020-10-11 | Warren | Virginia | 51187 | 484 | 13 |
615963 | 615963 | 2020-10-10 | Warren | Georgia | 13301 | 177 | 5 |
616117 | 616117 | 2020-10-10 | Warren | Illinois | 17187 | 385 | 4 |
616211 | 616211 | 2020-10-10 | Warren | Indiana | 18171 | 56 | 1 |
616309 | 616309 | 2020-10-10 | Warren | Iowa | 19181 | 1045 | 6 |
616536 | 616536 | 2020-10-10 | Warren | Kentucky | 21227 | 4635 | 56 |
616911 | 616911 | 2020-10-10 | Warren | Mississippi | 28149 | 1467 | 53 |
617030 | 617030 | 2020-10-10 | Warren | Missouri | 29219 | 597 | 1 |
617234 | 617234 | 2020-10-10 | Warren | New Jersey | 34041 | 1490 | 171 |
617320 | 617320 | 2020-10-10 | Warren | New York | 36113 | 429 | 30 |
617418 | 617418 | 2020-10-10 | Warren | North Carolina | 37185 | 375 | 7 |
617564 | 617564 | 2020-10-10 | Warren | Ohio | 39165 | 3514 | 59 |
617744 | 617744 | 2020-10-10 | Warren | Pennsylvania | 42123 | 52 | 1 |
618036 | 618036 | 2020-10-10 | Warren | Tennessee | 47177 | 1185 | 9 |
618467 | 618467 | 2020-10-10 | Warren | Virginia | 51187 | 478 | 13 |
612722 | 612722 | 2020-10-09 | Warren | Georgia | 13301 | 176 | 5 |
612876 | 612876 | 2020-10-09 | Warren | Illinois | 17187 | 376 | 4 |
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);