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 298
- Kentucky 297
- New York 297
- Ohio 295
- Iowa 290
- Pennsylvania 290
- Virginia 289
- Indiana 288
- Missouri 287
- Mississippi 286
- Tennessee 285
- Georgia 284
- North Carolina 280
- Illinois 272
fips 14
county 1
- Warren · 4,038 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908571 | 908571 | 2021-01-08 | Warren | Kentucky | 21227 | 11283 | 88 |
908946 | 908946 | 2021-01-08 | Warren | Mississippi | 28149 | 3075 | 85 |
909065 | 909065 | 2021-01-08 | Warren | Missouri | 29219 | 2184 | 19 |
909269 | 909269 | 2021-01-08 | Warren | New Jersey | 34041 | 4761 | 185 |
909355 | 909355 | 2021-01-08 | Warren | New York | 36113 | 1567 | 32 |
909453 | 909453 | 2021-01-08 | Warren | North Carolina | 37185 | 1168 | 11 |
909599 | 909599 | 2021-01-08 | Warren | Ohio | 39165 | 17396 | 127 |
909780 | 909780 | 2021-01-08 | Warren | Pennsylvania | 42123 | 1707 | 51 |
910072 | 910072 | 2021-01-08 | Warren | Tennessee | 47177 | 4734 | 48 |
910505 | 910505 | 2021-01-08 | Warren | Virginia | 51187 | 1528 | 35 |
904751 | 904751 | 2021-01-07 | Warren | Georgia | 13301 | 309 | 9 |
904905 | 904905 | 2021-01-07 | Warren | Illinois | 17187 | 1536 | 42 |
904999 | 904999 | 2021-01-07 | Warren | Indiana | 18171 | 600 | 8 |
905097 | 905097 | 2021-01-07 | Warren | Iowa | 19181 | 4057 | 37 |
905325 | 905325 | 2021-01-07 | Warren | Kentucky | 21227 | 11122 | 88 |
905700 | 905700 | 2021-01-07 | Warren | Mississippi | 28149 | 3042 | 84 |
905819 | 905819 | 2021-01-07 | Warren | Missouri | 29219 | 2161 | 19 |
906023 | 906023 | 2021-01-07 | Warren | New Jersey | 34041 | 4684 | 184 |
906110 | 906110 | 2021-01-07 | Warren | New York | 36113 | 1487 | 32 |
906208 | 906208 | 2021-01-07 | Warren | North Carolina | 37185 | 1152 | 11 |
906354 | 906354 | 2021-01-07 | Warren | Ohio | 39165 | 17135 | 124 |
906535 | 906535 | 2021-01-07 | Warren | Pennsylvania | 42123 | 1677 | 46 |
906827 | 906827 | 2021-01-07 | Warren | Tennessee | 47177 | 4651 | 48 |
907260 | 907260 | 2021-01-07 | Warren | Virginia | 51187 | 1520 | 35 |
901506 | 901506 | 2021-01-06 | Warren | Georgia | 13301 | 300 | 9 |
901660 | 901660 | 2021-01-06 | Warren | Illinois | 17187 | 1529 | 42 |
901754 | 901754 | 2021-01-06 | Warren | Indiana | 18171 | 593 | 8 |
901852 | 901852 | 2021-01-06 | Warren | Iowa | 19181 | 4009 | 37 |
902080 | 902080 | 2021-01-06 | Warren | Kentucky | 21227 | 10949 | 88 |
902455 | 902455 | 2021-01-06 | Warren | Mississippi | 28149 | 2997 | 81 |
902574 | 902574 | 2021-01-06 | Warren | Missouri | 29219 | 2118 | 19 |
902778 | 902778 | 2021-01-06 | Warren | New Jersey | 34041 | 4601 | 184 |
902864 | 902864 | 2021-01-06 | Warren | New York | 36113 | 1434 | 32 |
902962 | 902962 | 2021-01-06 | Warren | North Carolina | 37185 | 1132 | 9 |
903108 | 903108 | 2021-01-06 | Warren | Ohio | 39165 | 16873 | 124 |
903289 | 903289 | 2021-01-06 | Warren | Pennsylvania | 42123 | 1661 | 45 |
903581 | 903581 | 2021-01-06 | Warren | Tennessee | 47177 | 4611 | 47 |
904014 | 904014 | 2021-01-06 | Warren | Virginia | 51187 | 1508 | 35 |
898261 | 898261 | 2021-01-05 | Warren | Georgia | 13301 | 299 | 9 |
898415 | 898415 | 2021-01-05 | Warren | Illinois | 17187 | 1529 | 42 |
898509 | 898509 | 2021-01-05 | Warren | Indiana | 18171 | 580 | 8 |
898607 | 898607 | 2021-01-05 | Warren | Iowa | 19181 | 3956 | 34 |
898835 | 898835 | 2021-01-05 | Warren | Kentucky | 21227 | 10690 | 87 |
899210 | 899210 | 2021-01-05 | Warren | Mississippi | 28149 | 2914 | 80 |
899329 | 899329 | 2021-01-05 | Warren | Missouri | 29219 | 2103 | 19 |
899533 | 899533 | 2021-01-05 | Warren | New Jersey | 34041 | 4558 | 183 |
899619 | 899619 | 2021-01-05 | Warren | New York | 36113 | 1387 | 32 |
899717 | 899717 | 2021-01-05 | Warren | North Carolina | 37185 | 1122 | 9 |
899863 | 899863 | 2021-01-05 | Warren | Ohio | 39165 | 16620 | 124 |
900044 | 900044 | 2021-01-05 | Warren | Pennsylvania | 42123 | 1636 | 40 |
900336 | 900336 | 2021-01-05 | Warren | Tennessee | 47177 | 4578 | 46 |
900769 | 900769 | 2021-01-05 | Warren | Virginia | 51187 | 1478 | 35 |
895016 | 895016 | 2021-01-04 | Warren | Georgia | 13301 | 289 | 9 |
895170 | 895170 | 2021-01-04 | Warren | Illinois | 17187 | 1525 | 40 |
895264 | 895264 | 2021-01-04 | Warren | Indiana | 18171 | 576 | 8 |
895362 | 895362 | 2021-01-04 | Warren | Iowa | 19181 | 3913 | 34 |
895590 | 895590 | 2021-01-04 | Warren | Kentucky | 21227 | 10530 | 87 |
895965 | 895965 | 2021-01-04 | Warren | Mississippi | 28149 | 2891 | 79 |
896084 | 896084 | 2021-01-04 | Warren | Missouri | 29219 | 2064 | 19 |
896288 | 896288 | 2021-01-04 | Warren | New Jersey | 34041 | 4488 | 183 |
896374 | 896374 | 2021-01-04 | Warren | New York | 36113 | 1346 | 32 |
896472 | 896472 | 2021-01-04 | Warren | North Carolina | 37185 | 1117 | 9 |
896618 | 896618 | 2021-01-04 | Warren | Ohio | 39165 | 16387 | 122 |
896799 | 896799 | 2021-01-04 | Warren | Pennsylvania | 42123 | 1586 | 37 |
897091 | 897091 | 2021-01-04 | Warren | Tennessee | 47177 | 4555 | 45 |
897524 | 897524 | 2021-01-04 | Warren | Virginia | 51187 | 1451 | 34 |
891769 | 891769 | 2021-01-03 | Warren | Georgia | 13301 | 288 | 9 |
891923 | 891923 | 2021-01-03 | Warren | Illinois | 17187 | 1521 | 39 |
892017 | 892017 | 2021-01-03 | Warren | Indiana | 18171 | 565 | 8 |
892115 | 892115 | 2021-01-03 | Warren | Iowa | 19181 | 3872 | 34 |
892343 | 892343 | 2021-01-03 | Warren | Kentucky | 21227 | 10409 | 84 |
892718 | 892718 | 2021-01-03 | Warren | Mississippi | 28149 | 2872 | 79 |
892837 | 892837 | 2021-01-03 | Warren | Missouri | 29219 | 2046 | 19 |
893041 | 893041 | 2021-01-03 | Warren | New Jersey | 34041 | 4091 | 183 |
893128 | 893128 | 2021-01-03 | Warren | New York | 36113 | 1337 | 32 |
893226 | 893226 | 2021-01-03 | Warren | North Carolina | 37185 | 1112 | 9 |
893372 | 893372 | 2021-01-03 | Warren | Ohio | 39165 | 16262 | 122 |
893553 | 893553 | 2021-01-03 | Warren | Pennsylvania | 42123 | 1577 | 36 |
893845 | 893845 | 2021-01-03 | Warren | Tennessee | 47177 | 4536 | 43 |
894278 | 894278 | 2021-01-03 | Warren | Virginia | 51187 | 1433 | 34 |
888522 | 888522 | 2021-01-02 | Warren | Georgia | 13301 | 288 | 9 |
888677 | 888677 | 2021-01-02 | Warren | Illinois | 17187 | 1513 | 39 |
888771 | 888771 | 2021-01-02 | Warren | Indiana | 18171 | 558 | 8 |
888869 | 888869 | 2021-01-02 | Warren | Iowa | 19181 | 3846 | 34 |
889097 | 889097 | 2021-01-02 | Warren | Kentucky | 21227 | 10294 | 84 |
889472 | 889472 | 2021-01-02 | Warren | Mississippi | 28149 | 2842 | 79 |
889591 | 889591 | 2021-01-02 | Warren | Missouri | 29219 | 2046 | 19 |
889795 | 889795 | 2021-01-02 | Warren | New Jersey | 34041 | 4060 | 183 |
889882 | 889882 | 2021-01-02 | Warren | New York | 36113 | 1272 | 32 |
889980 | 889980 | 2021-01-02 | Warren | North Carolina | 37185 | 1111 | 9 |
890126 | 890126 | 2021-01-02 | Warren | Ohio | 39165 | 16139 | 121 |
890307 | 890307 | 2021-01-02 | Warren | Pennsylvania | 42123 | 1560 | 36 |
890599 | 890599 | 2021-01-02 | Warren | Tennessee | 47177 | 4514 | 43 |
891032 | 891032 | 2021-01-02 | Warren | Virginia | 51187 | 1410 | 34 |
885277 | 885277 | 2021-01-01 | Warren | Georgia | 13301 | 287 | 9 |
885431 | 885431 | 2021-01-01 | Warren | Illinois | 17187 | 1496 | 36 |
885525 | 885525 | 2021-01-01 | Warren | Indiana | 18171 | 547 | 8 |
885623 | 885623 | 2021-01-01 | Warren | Iowa | 19181 | 3836 | 34 |
885851 | 885851 | 2021-01-01 | Warren | Kentucky | 21227 | 10194 | 84 |
886226 | 886226 | 2021-01-01 | Warren | Mississippi | 28149 | 2773 | 79 |
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);