ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,238 rows where county = "Warren" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
state
- New Jersey 312
- Kentucky 311
- New York 311
- Ohio 309
- Iowa 305
- Pennsylvania 304
- Indiana 303
- Virginia 303
- Missouri 301
- Mississippi 300
- Georgia 299
- Tennessee 299
- North Carolina 294
- Illinois 287
fips
county
- Warren · 4,238 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953511 | 953511 | 2021-01-22 | Warren | Georgia | 13301 | 420 | 9 |
953665 | 953665 | 2021-01-22 | Warren | Illinois | 17187 | 1596 | 44 |
953759 | 953759 | 2021-01-22 | Warren | Indiana | 18171 | 679 | 8 |
953857 | 953857 | 2021-01-22 | Warren | Iowa | 19181 | 4561 | 39 |
954085 | 954085 | 2021-01-22 | Warren | Kentucky | 21227 | 12750 | 95 |
954460 | 954460 | 2021-01-22 | Warren | Mississippi | 28149 | 3649 | 103 |
954579 | 954579 | 2021-01-22 | Warren | Missouri | 29219 | 2375 | 20 |
954783 | 954783 | 2021-01-22 | Warren | New Jersey | 34041 | 5626 | 193 |
954869 | 954869 | 2021-01-22 | Warren | New York | 36113 | 2201 | 42 |
954967 | 954967 | 2021-01-22 | Warren | North Carolina | 37185 | 1337 | 13 |
955113 | 955113 | 2021-01-22 | Warren | Ohio | 39165 | 19552 | 140 |
955294 | 955294 | 2021-01-22 | Warren | Pennsylvania | 42123 | 1921 | 80 |
955586 | 955586 | 2021-01-22 | Warren | Tennessee | 47177 | 5044 | 54 |
956019 | 956019 | 2021-01-22 | Warren | Virginia | 51187 | 1781 | 36 |
950266 | 950266 | 2021-01-21 | Warren | Georgia | 13301 | 417 | 9 |
950420 | 950420 | 2021-01-21 | Warren | Illinois | 17187 | 1591 | 44 |
950514 | 950514 | 2021-01-21 | Warren | Indiana | 18171 | 677 | 8 |
950612 | 950612 | 2021-01-21 | Warren | Iowa | 19181 | 4519 | 39 |
950840 | 950840 | 2021-01-21 | Warren | Kentucky | 21227 | 12561 | 93 |
951215 | 951215 | 2021-01-21 | Warren | Mississippi | 28149 | 3619 | 101 |
951334 | 951334 | 2021-01-21 | Warren | Missouri | 29219 | 2357 | 20 |
951538 | 951538 | 2021-01-21 | Warren | New Jersey | 34041 | 5568 | 191 |
951624 | 951624 | 2021-01-21 | Warren | New York | 36113 | 2163 | 42 |
951722 | 951722 | 2021-01-21 | Warren | North Carolina | 37185 | 1327 | 12 |
951868 | 951868 | 2021-01-21 | Warren | Ohio | 39165 | 19436 | 140 |
952049 | 952049 | 2021-01-21 | Warren | Pennsylvania | 42123 | 1906 | 78 |
952341 | 952341 | 2021-01-21 | Warren | Tennessee | 47177 | 5033 | 54 |
952774 | 952774 | 2021-01-21 | Warren | Virginia | 51187 | 1755 | 36 |
947020 | 947020 | 2021-01-20 | Warren | Georgia | 13301 | 414 | 9 |
947174 | 947174 | 2021-01-20 | Warren | Illinois | 17187 | 1588 | 44 |
947268 | 947268 | 2021-01-20 | Warren | Indiana | 18171 | 665 | 8 |
947366 | 947366 | 2021-01-20 | Warren | Iowa | 19181 | 4490 | 38 |
947594 | 947594 | 2021-01-20 | Warren | Kentucky | 21227 | 12515 | 93 |
947969 | 947969 | 2021-01-20 | Warren | Mississippi | 28149 | 3569 | 100 |
948088 | 948088 | 2021-01-20 | Warren | Missouri | 29219 | 2357 | 20 |
948292 | 948292 | 2021-01-20 | Warren | New Jersey | 34041 | 5525 | 191 |
948379 | 948379 | 2021-01-20 | Warren | New York | 36113 | 2119 | 42 |
948477 | 948477 | 2021-01-20 | Warren | North Carolina | 37185 | 1311 | 12 |
948623 | 948623 | 2021-01-20 | Warren | Ohio | 39165 | 19222 | 140 |
948804 | 948804 | 2021-01-20 | Warren | Pennsylvania | 42123 | 1889 | 75 |
949096 | 949096 | 2021-01-20 | Warren | Tennessee | 47177 | 5026 | 53 |
949529 | 949529 | 2021-01-20 | Warren | Virginia | 51187 | 1740 | 36 |
943773 | 943773 | 2021-01-19 | Warren | Georgia | 13301 | 408 | 9 |
943927 | 943927 | 2021-01-19 | Warren | Illinois | 17187 | 1586 | 44 |
944021 | 944021 | 2021-01-19 | Warren | Indiana | 18171 | 665 | 8 |
944119 | 944119 | 2021-01-19 | Warren | Iowa | 19181 | 4439 | 38 |
944347 | 944347 | 2021-01-19 | Warren | Kentucky | 21227 | 12385 | 93 |
944722 | 944722 | 2021-01-19 | Warren | Mississippi | 28149 | 3548 | 98 |
944841 | 944841 | 2021-01-19 | Warren | Missouri | 29219 | 2352 | 20 |
945045 | 945045 | 2021-01-19 | Warren | New Jersey | 34041 | 5475 | 189 |
945132 | 945132 | 2021-01-19 | Warren | New York | 36113 | 2062 | 40 |
945231 | 945231 | 2021-01-19 | Warren | North Carolina | 37185 | 1302 | 12 |
945377 | 945377 | 2021-01-19 | Warren | Ohio | 39165 | 19083 | 140 |
945558 | 945558 | 2021-01-19 | Warren | Pennsylvania | 42123 | 1872 | 73 |
945850 | 945850 | 2021-01-19 | Warren | Tennessee | 47177 | 5000 | 53 |
946283 | 946283 | 2021-01-19 | Warren | Virginia | 51187 | 1729 | 36 |
940528 | 940528 | 2021-01-18 | Warren | Georgia | 13301 | 404 | 9 |
940682 | 940682 | 2021-01-18 | Warren | Illinois | 17187 | 1582 | 44 |
940776 | 940776 | 2021-01-18 | Warren | Indiana | 18171 | 662 | 8 |
940874 | 940874 | 2021-01-18 | Warren | Iowa | 19181 | 4406 | 38 |
941102 | 941102 | 2021-01-18 | Warren | Kentucky | 21227 | 12255 | 91 |
941477 | 941477 | 2021-01-18 | Warren | Mississippi | 28149 | 3534 | 98 |
941596 | 941596 | 2021-01-18 | Warren | Missouri | 29219 | 2287 | 19 |
941800 | 941800 | 2021-01-18 | Warren | New Jersey | 34041 | 5430 | 189 |
941886 | 941886 | 2021-01-18 | Warren | New York | 36113 | 2045 | 38 |
941984 | 941984 | 2021-01-18 | Warren | North Carolina | 37185 | 1279 | 12 |
942130 | 942130 | 2021-01-18 | Warren | Ohio | 39165 | 18974 | 139 |
942311 | 942311 | 2021-01-18 | Warren | Pennsylvania | 42123 | 1869 | 73 |
942603 | 942603 | 2021-01-18 | Warren | Tennessee | 47177 | 4987 | 53 |
943036 | 943036 | 2021-01-18 | Warren | Virginia | 51187 | 1710 | 36 |
937283 | 937283 | 2021-01-17 | Warren | Georgia | 13301 | 399 | 9 |
937437 | 937437 | 2021-01-17 | Warren | Illinois | 17187 | 1580 | 43 |
937531 | 937531 | 2021-01-17 | Warren | Indiana | 18171 | 660 | 8 |
937629 | 937629 | 2021-01-17 | Warren | Iowa | 19181 | 4388 | 38 |
937857 | 937857 | 2021-01-17 | Warren | Kentucky | 21227 | 12138 | 90 |
938232 | 938232 | 2021-01-17 | Warren | Mississippi | 28149 | 3484 | 98 |
938351 | 938351 | 2021-01-17 | Warren | Missouri | 29219 | 2287 | 19 |
938555 | 938555 | 2021-01-17 | Warren | New Jersey | 34041 | 5376 | 189 |
938641 | 938641 | 2021-01-17 | Warren | New York | 36113 | 2004 | 37 |
938739 | 938739 | 2021-01-17 | Warren | North Carolina | 37185 | 1279 | 12 |
938885 | 938885 | 2021-01-17 | Warren | Ohio | 39165 | 18917 | 139 |
939066 | 939066 | 2021-01-17 | Warren | Pennsylvania | 42123 | 1849 | 70 |
939358 | 939358 | 2021-01-17 | Warren | Tennessee | 47177 | 4975 | 53 |
939791 | 939791 | 2021-01-17 | Warren | Virginia | 51187 | 1685 | 36 |
934038 | 934038 | 2021-01-16 | Warren | Georgia | 13301 | 385 | 9 |
934192 | 934192 | 2021-01-16 | Warren | Illinois | 17187 | 1577 | 43 |
934286 | 934286 | 2021-01-16 | Warren | Indiana | 18171 | 655 | 8 |
934384 | 934384 | 2021-01-16 | Warren | Iowa | 19181 | 4375 | 38 |
934612 | 934612 | 2021-01-16 | Warren | Kentucky | 21227 | 12114 | 90 |
934987 | 934987 | 2021-01-16 | Warren | Mississippi | 28149 | 3445 | 97 |
935106 | 935106 | 2021-01-16 | Warren | Missouri | 29219 | 2287 | 19 |
935310 | 935310 | 2021-01-16 | Warren | New Jersey | 34041 | 5326 | 189 |
935396 | 935396 | 2021-01-16 | Warren | New York | 36113 | 1982 | 37 |
935494 | 935494 | 2021-01-16 | Warren | North Carolina | 37185 | 1273 | 12 |
935640 | 935640 | 2021-01-16 | Warren | Ohio | 39165 | 18792 | 139 |
935821 | 935821 | 2021-01-16 | Warren | Pennsylvania | 42123 | 1845 | 69 |
936113 | 936113 | 2021-01-16 | Warren | Tennessee | 47177 | 4962 | 53 |
936546 | 936546 | 2021-01-16 | Warren | Virginia | 51187 | 1650 | 36 |
930793 | 930793 | 2021-01-15 | Warren | Georgia | 13301 | 375 | 9 |
930947 | 930947 | 2021-01-15 | Warren | Illinois | 17187 | 1575 | 43 |
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]);