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 305
- Kentucky 304
- New York 304
- Ohio 302
- Iowa 298
- Pennsylvania 297
- Indiana 296
- Virginia 296
- Missouri 294
- Mississippi 293
- Tennessee 292
- Georgia 291
- North Carolina 287
- Illinois 279
fips 14
county 1
- Warren · 4,138 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930961 | 930961 | 2021-01-15 | Warren | Indiana | 18171 | 651 | 8 |
931059 | 931059 | 2021-01-15 | Warren | Iowa | 19181 | 4362 | 37 |
931287 | 931287 | 2021-01-15 | Warren | Kentucky | 21227 | 12066 | 90 |
931662 | 931662 | 2021-01-15 | Warren | Mississippi | 28149 | 3378 | 95 |
931781 | 931781 | 2021-01-15 | Warren | Missouri | 29219 | 2287 | 19 |
931985 | 931985 | 2021-01-15 | Warren | New Jersey | 34041 | 5270 | 189 |
932071 | 932071 | 2021-01-15 | Warren | New York | 36113 | 1928 | 36 |
932169 | 932169 | 2021-01-15 | Warren | North Carolina | 37185 | 1273 | 12 |
932315 | 932315 | 2021-01-15 | Warren | Ohio | 39165 | 18659 | 138 |
932496 | 932496 | 2021-01-15 | Warren | Pennsylvania | 42123 | 1839 | 68 |
932788 | 932788 | 2021-01-15 | Warren | Tennessee | 47177 | 4927 | 53 |
933221 | 933221 | 2021-01-15 | Warren | Virginia | 51187 | 1633 | 36 |
927468 | 927468 | 2021-01-14 | Warren | Georgia | 13301 | 372 | 9 |
927622 | 927622 | 2021-01-14 | Warren | Illinois | 17187 | 1572 | 43 |
927716 | 927716 | 2021-01-14 | Warren | Indiana | 18171 | 644 | 8 |
927814 | 927814 | 2021-01-14 | Warren | Iowa | 19181 | 4306 | 37 |
928042 | 928042 | 2021-01-14 | Warren | Kentucky | 21227 | 11929 | 88 |
928417 | 928417 | 2021-01-14 | Warren | Mississippi | 28149 | 3346 | 92 |
928536 | 928536 | 2021-01-14 | Warren | Missouri | 29219 | 2262 | 19 |
928740 | 928740 | 2021-01-14 | Warren | New Jersey | 34041 | 5193 | 188 |
928826 | 928826 | 2021-01-14 | Warren | New York | 36113 | 1846 | 35 |
928924 | 928924 | 2021-01-14 | Warren | North Carolina | 37185 | 1254 | 12 |
929070 | 929070 | 2021-01-14 | Warren | Ohio | 39165 | 18471 | 135 |
929251 | 929251 | 2021-01-14 | Warren | Pennsylvania | 42123 | 1828 | 65 |
929543 | 929543 | 2021-01-14 | Warren | Tennessee | 47177 | 4875 | 53 |
929976 | 929976 | 2021-01-14 | Warren | Virginia | 51187 | 1613 | 36 |
924222 | 924222 | 2021-01-13 | Warren | Georgia | 13301 | 367 | 9 |
924376 | 924376 | 2021-01-13 | Warren | Illinois | 17187 | 1569 | 42 |
924470 | 924470 | 2021-01-13 | Warren | Indiana | 18171 | 643 | 8 |
924568 | 924568 | 2021-01-13 | Warren | Iowa | 19181 | 4274 | 37 |
924796 | 924796 | 2021-01-13 | Warren | Kentucky | 21227 | 11800 | 88 |
925171 | 925171 | 2021-01-13 | Warren | Mississippi | 28149 | 3305 | 91 |
925290 | 925290 | 2021-01-13 | Warren | Missouri | 29219 | 2258 | 19 |
925494 | 925494 | 2021-01-13 | Warren | New Jersey | 34041 | 5120 | 187 |
925581 | 925581 | 2021-01-13 | Warren | New York | 36113 | 1825 | 35 |
925679 | 925679 | 2021-01-13 | Warren | North Carolina | 37185 | 1231 | 12 |
925825 | 925825 | 2021-01-13 | Warren | Ohio | 39165 | 18268 | 135 |
926006 | 926006 | 2021-01-13 | Warren | Pennsylvania | 42123 | 1813 | 63 |
926298 | 926298 | 2021-01-13 | Warren | Tennessee | 47177 | 4850 | 51 |
926731 | 926731 | 2021-01-13 | Warren | Virginia | 51187 | 1588 | 36 |
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 |
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);