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 302
- Kentucky 301
- New York 301
- Ohio 299
- Iowa 295
- Pennsylvania 294
- Indiana 293
- Virginia 293
- Missouri 291
- Mississippi 290
- Georgia 289
- Tennessee 289
- North Carolina 284
- Illinois 277
fips 14
county 1
- Warren · 4,098 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920977 | 920977 | 2021-01-12 | Warren | Georgia | 13301 | 358 | 9 |
921131 | 921131 | 2021-01-12 | Warren | Illinois | 17187 | 1564 | 42 |
921225 | 921225 | 2021-01-12 | Warren | Indiana | 18171 | 636 | 8 |
921323 | 921323 | 2021-01-12 | Warren | Iowa | 19181 | 4221 | 37 |
921551 | 921551 | 2021-01-12 | Warren | Kentucky | 21227 | 11665 | 88 |
921926 | 921926 | 2021-01-12 | Warren | Mississippi | 28149 | 3279 | 91 |
922045 | 922045 | 2021-01-12 | Warren | Missouri | 29219 | 2229 | 19 |
922249 | 922249 | 2021-01-12 | Warren | New Jersey | 34041 | 5038 | 186 |
922335 | 922335 | 2021-01-12 | Warren | New York | 36113 | 1764 | 33 |
922433 | 922433 | 2021-01-12 | Warren | North Carolina | 37185 | 1219 | 12 |
922579 | 922579 | 2021-01-12 | Warren | Ohio | 39165 | 18095 | 130 |
922760 | 922760 | 2021-01-12 | Warren | Pennsylvania | 42123 | 1787 | 56 |
923052 | 923052 | 2021-01-12 | Warren | Tennessee | 47177 | 4833 | 51 |
923485 | 923485 | 2021-01-12 | Warren | Virginia | 51187 | 1575 | 36 |
917732 | 917732 | 2021-01-11 | Warren | Georgia | 13301 | 349 | 9 |
917886 | 917886 | 2021-01-11 | Warren | Illinois | 17187 | 1560 | 42 |
917980 | 917980 | 2021-01-11 | Warren | Indiana | 18171 | 632 | 8 |
918078 | 918078 | 2021-01-11 | Warren | Iowa | 19181 | 4158 | 37 |
918306 | 918306 | 2021-01-11 | Warren | Kentucky | 21227 | 11599 | 88 |
918681 | 918681 | 2021-01-11 | Warren | Mississippi | 28149 | 3252 | 90 |
918800 | 918800 | 2021-01-11 | Warren | Missouri | 29219 | 2213 | 19 |
919004 | 919004 | 2021-01-11 | Warren | New Jersey | 34041 | 4999 | 187 |
919090 | 919090 | 2021-01-11 | Warren | New York | 36113 | 1717 | 33 |
919188 | 919188 | 2021-01-11 | Warren | North Carolina | 37185 | 1213 | 11 |
919334 | 919334 | 2021-01-11 | Warren | Ohio | 39165 | 17861 | 128 |
919515 | 919515 | 2021-01-11 | Warren | Pennsylvania | 42123 | 1773 | 53 |
919807 | 919807 | 2021-01-11 | Warren | Tennessee | 47177 | 4813 | 51 |
920240 | 920240 | 2021-01-11 | Warren | Virginia | 51187 | 1555 | 36 |
914487 | 914487 | 2021-01-10 | Warren | Georgia | 13301 | 337 | 9 |
914641 | 914641 | 2021-01-10 | Warren | Illinois | 17187 | 1555 | 42 |
914735 | 914735 | 2021-01-10 | Warren | Indiana | 18171 | 630 | 8 |
914833 | 914833 | 2021-01-10 | Warren | Iowa | 19181 | 4128 | 37 |
915061 | 915061 | 2021-01-10 | Warren | Kentucky | 21227 | 11473 | 88 |
915436 | 915436 | 2021-01-10 | Warren | Mississippi | 28149 | 3236 | 88 |
915555 | 915555 | 2021-01-10 | Warren | Missouri | 29219 | 2184 | 19 |
915759 | 915759 | 2021-01-10 | Warren | New Jersey | 34041 | 4929 | 186 |
915845 | 915845 | 2021-01-10 | Warren | New York | 36113 | 1682 | 33 |
915943 | 915943 | 2021-01-10 | Warren | North Carolina | 37185 | 1202 | 11 |
916089 | 916089 | 2021-01-10 | Warren | Ohio | 39165 | 17737 | 128 |
916270 | 916270 | 2021-01-10 | Warren | Pennsylvania | 42123 | 1755 | 53 |
916562 | 916562 | 2021-01-10 | Warren | Tennessee | 47177 | 4801 | 51 |
916995 | 916995 | 2021-01-10 | Warren | Virginia | 51187 | 1548 | 36 |
911242 | 911242 | 2021-01-09 | Warren | Georgia | 13301 | 324 | 9 |
911396 | 911396 | 2021-01-09 | Warren | Illinois | 17187 | 1550 | 42 |
911490 | 911490 | 2021-01-09 | Warren | Indiana | 18171 | 624 | 8 |
911588 | 911588 | 2021-01-09 | Warren | Iowa | 19181 | 4123 | 37 |
911816 | 911816 | 2021-01-09 | Warren | Kentucky | 21227 | 11375 | 88 |
912191 | 912191 | 2021-01-09 | Warren | Mississippi | 28149 | 3166 | 88 |
912310 | 912310 | 2021-01-09 | Warren | Missouri | 29219 | 2184 | 19 |
912514 | 912514 | 2021-01-09 | Warren | New Jersey | 34041 | 4850 | 186 |
912600 | 912600 | 2021-01-09 | Warren | New York | 36113 | 1625 | 32 |
912698 | 912698 | 2021-01-09 | Warren | North Carolina | 37185 | 1190 | 11 |
912844 | 912844 | 2021-01-09 | Warren | Ohio | 39165 | 17562 | 128 |
913025 | 913025 | 2021-01-09 | Warren | Pennsylvania | 42123 | 1751 | 52 |
913317 | 913317 | 2021-01-09 | Warren | Tennessee | 47177 | 4754 | 50 |
913750 | 913750 | 2021-01-09 | Warren | Virginia | 51187 | 1545 | 36 |
907997 | 907997 | 2021-01-08 | Warren | Georgia | 13301 | 316 | 9 |
908151 | 908151 | 2021-01-08 | Warren | Illinois | 17187 | 1548 | 42 |
908245 | 908245 | 2021-01-08 | Warren | Indiana | 18171 | 613 | 8 |
908343 | 908343 | 2021-01-08 | Warren | Iowa | 19181 | 4081 | 37 |
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 |
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);