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 774
- Kentucky 773
- New York 773
- Ohio 771
- Iowa 766
- Pennsylvania 766
- Virginia 765
- Indiana 764
- Missouri 763
- Mississippi 762
- Tennessee 761
- Georgia 760
- North Carolina 756
- Illinois 748
fips 14
county 1
- Warren · 10,702 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2455093 | 2455093 | 2022-04-29 | Warren | Kentucky | 21227 | 43003 | 367 |
2455469 | 2455469 | 2022-04-29 | Warren | Mississippi | 28149 | 10223 | 202 |
2455588 | 2455588 | 2022-04-29 | Warren | Missouri | 29219 | 8133 | 102 |
2455794 | 2455794 | 2022-04-29 | Warren | New Jersey | 34041 | 24333 | 341 |
2455881 | 2455881 | 2022-04-29 | Warren | New York | 36113 | 14180 | 128 |
2455979 | 2455979 | 2022-04-29 | Warren | North Carolina | 37185 | 4337 | 39 |
2456128 | 2456128 | 2022-04-29 | Warren | Ohio | 39165 | 58014 | 584 |
2456309 | 2456309 | 2022-04-29 | Warren | Pennsylvania | 42123 | 7406 | 210 |
2456601 | 2456601 | 2022-04-29 | Warren | Tennessee | 47177 | 13008 | 176 |
2457034 | 2457034 | 2022-04-29 | Warren | Virginia | 51187 | 8604 | 156 |
2451260 | 2451260 | 2022-04-28 | Warren | Georgia | 13301 | 1060 | 30 |
2451416 | 2451416 | 2022-04-28 | Warren | Illinois | 17187 | 4047 | 87 |
2451511 | 2451511 | 2022-04-28 | Warren | Indiana | 18171 | 2101 | 30 |
2451609 | 2451609 | 2022-04-28 | Warren | Iowa | 19181 | 12518 | 134 |
2451837 | 2451837 | 2022-04-28 | Warren | Kentucky | 21227 | 43003 | 367 |
2452213 | 2452213 | 2022-04-28 | Warren | Mississippi | 28149 | 10223 | 202 |
2452332 | 2452332 | 2022-04-28 | Warren | Missouri | 29219 | 8133 | 102 |
2452538 | 2452538 | 2022-04-28 | Warren | New Jersey | 34041 | 24304 | 341 |
2452625 | 2452625 | 2022-04-28 | Warren | New York | 36113 | 14138 | 127 |
2452723 | 2452723 | 2022-04-28 | Warren | North Carolina | 37185 | 4337 | 39 |
2452872 | 2452872 | 2022-04-28 | Warren | Ohio | 39165 | 58014 | 584 |
2453053 | 2453053 | 2022-04-28 | Warren | Pennsylvania | 42123 | 7398 | 210 |
2453345 | 2453345 | 2022-04-28 | Warren | Tennessee | 47177 | 13008 | 176 |
2453778 | 2453778 | 2022-04-28 | Warren | Virginia | 51187 | 8599 | 156 |
2448004 | 2448004 | 2022-04-27 | Warren | Georgia | 13301 | 1060 | 30 |
2448160 | 2448160 | 2022-04-27 | Warren | Illinois | 17187 | 4043 | 87 |
2448255 | 2448255 | 2022-04-27 | Warren | Indiana | 18171 | 2101 | 30 |
2448353 | 2448353 | 2022-04-27 | Warren | Iowa | 19181 | 12518 | 134 |
2448581 | 2448581 | 2022-04-27 | Warren | Kentucky | 21227 | 43003 | 367 |
2448957 | 2448957 | 2022-04-27 | Warren | Mississippi | 28149 | 10223 | 202 |
2449076 | 2449076 | 2022-04-27 | Warren | Missouri | 29219 | 8133 | 102 |
2449282 | 2449282 | 2022-04-27 | Warren | New Jersey | 34041 | 24269 | 341 |
2449369 | 2449369 | 2022-04-27 | Warren | New York | 36113 | 14094 | 127 |
2449467 | 2449467 | 2022-04-27 | Warren | North Carolina | 37185 | 4337 | 39 |
2449616 | 2449616 | 2022-04-27 | Warren | Ohio | 39165 | 57849 | 584 |
2449797 | 2449797 | 2022-04-27 | Warren | Pennsylvania | 42123 | 7392 | 210 |
2450089 | 2450089 | 2022-04-27 | Warren | Tennessee | 47177 | 13008 | 176 |
2450522 | 2450522 | 2022-04-27 | Warren | Virginia | 51187 | 8592 | 156 |
2444748 | 2444748 | 2022-04-26 | Warren | Georgia | 13301 | 1061 | 30 |
2444904 | 2444904 | 2022-04-26 | Warren | Illinois | 17187 | 4035 | 87 |
2444999 | 2444999 | 2022-04-26 | Warren | Indiana | 18171 | 2096 | 30 |
2445097 | 2445097 | 2022-04-26 | Warren | Iowa | 19181 | 12502 | 134 |
2445325 | 2445325 | 2022-04-26 | Warren | Kentucky | 21227 | 43003 | 367 |
2445700 | 2445700 | 2022-04-26 | Warren | Mississippi | 28149 | 10223 | 202 |
2445819 | 2445819 | 2022-04-26 | Warren | Missouri | 29219 | 8133 | 102 |
2446025 | 2446025 | 2022-04-26 | Warren | New Jersey | 34041 | 24242 | 341 |
2446112 | 2446112 | 2022-04-26 | Warren | New York | 36113 | 14052 | 127 |
2446210 | 2446210 | 2022-04-26 | Warren | North Carolina | 37185 | 4322 | 39 |
2446359 | 2446359 | 2022-04-26 | Warren | Ohio | 39165 | 57849 | 584 |
2446540 | 2446540 | 2022-04-26 | Warren | Pennsylvania | 42123 | 7385 | 210 |
2446832 | 2446832 | 2022-04-26 | Warren | Tennessee | 47177 | 12998 | 176 |
2447266 | 2447266 | 2022-04-26 | Warren | Virginia | 51187 | 8592 | 156 |
2441492 | 2441492 | 2022-04-25 | Warren | Georgia | 13301 | 1061 | 30 |
2441648 | 2441648 | 2022-04-25 | Warren | Illinois | 17187 | 4026 | 87 |
2441743 | 2441743 | 2022-04-25 | Warren | Indiana | 18171 | 2096 | 30 |
2441841 | 2441841 | 2022-04-25 | Warren | Iowa | 19181 | 12502 | 134 |
2442069 | 2442069 | 2022-04-25 | Warren | Kentucky | 21227 | 43003 | 367 |
2442445 | 2442445 | 2022-04-25 | Warren | Mississippi | 28149 | 10213 | 202 |
2442564 | 2442564 | 2022-04-25 | Warren | Missouri | 29219 | 8133 | 102 |
2442770 | 2442770 | 2022-04-25 | Warren | New Jersey | 34041 | 24205 | 341 |
2442857 | 2442857 | 2022-04-25 | Warren | New York | 36113 | 14034 | 127 |
2442955 | 2442955 | 2022-04-25 | Warren | North Carolina | 37185 | 4322 | 39 |
2443104 | 2443104 | 2022-04-25 | Warren | Ohio | 39165 | 57849 | 584 |
2443285 | 2443285 | 2022-04-25 | Warren | Pennsylvania | 42123 | 7370 | 210 |
2443577 | 2443577 | 2022-04-25 | Warren | Tennessee | 47177 | 12998 | 176 |
2444010 | 2444010 | 2022-04-25 | Warren | Virginia | 51187 | 8586 | 155 |
2438236 | 2438236 | 2022-04-24 | Warren | Georgia | 13301 | 1061 | 30 |
2438392 | 2438392 | 2022-04-24 | Warren | Illinois | 17187 | 4017 | 87 |
2438487 | 2438487 | 2022-04-24 | Warren | Indiana | 18171 | 2094 | 30 |
2438585 | 2438585 | 2022-04-24 | Warren | Iowa | 19181 | 12502 | 134 |
2438813 | 2438813 | 2022-04-24 | Warren | Kentucky | 21227 | 42954 | 364 |
2439189 | 2439189 | 2022-04-24 | Warren | Mississippi | 28149 | 10213 | 202 |
2439308 | 2439308 | 2022-04-24 | Warren | Missouri | 29219 | 8133 | 102 |
2439514 | 2439514 | 2022-04-24 | Warren | New Jersey | 34041 | 24193 | 341 |
2439601 | 2439601 | 2022-04-24 | Warren | New York | 36113 | 14010 | 127 |
2439699 | 2439699 | 2022-04-24 | Warren | North Carolina | 37185 | 4322 | 39 |
2439848 | 2439848 | 2022-04-24 | Warren | Ohio | 39165 | 57849 | 584 |
2440029 | 2440029 | 2022-04-24 | Warren | Pennsylvania | 42123 | 7370 | 210 |
2440321 | 2440321 | 2022-04-24 | Warren | Tennessee | 47177 | 12998 | 176 |
2440754 | 2440754 | 2022-04-24 | Warren | Virginia | 51187 | 8578 | 155 |
2434980 | 2434980 | 2022-04-23 | Warren | Georgia | 13301 | 1061 | 30 |
2435136 | 2435136 | 2022-04-23 | Warren | Illinois | 17187 | 4017 | 87 |
2435231 | 2435231 | 2022-04-23 | Warren | Indiana | 18171 | 2094 | 30 |
2435329 | 2435329 | 2022-04-23 | Warren | Iowa | 19181 | 12502 | 134 |
2435557 | 2435557 | 2022-04-23 | Warren | Kentucky | 21227 | 42954 | 364 |
2435933 | 2435933 | 2022-04-23 | Warren | Mississippi | 28149 | 10213 | 202 |
2436052 | 2436052 | 2022-04-23 | Warren | Missouri | 29219 | 8133 | 102 |
2436258 | 2436258 | 2022-04-23 | Warren | New Jersey | 34041 | 24179 | 341 |
2436345 | 2436345 | 2022-04-23 | Warren | New York | 36113 | 13980 | 127 |
2436443 | 2436443 | 2022-04-23 | Warren | North Carolina | 37185 | 4322 | 39 |
2436592 | 2436592 | 2022-04-23 | Warren | Ohio | 39165 | 57849 | 584 |
2436773 | 2436773 | 2022-04-23 | Warren | Pennsylvania | 42123 | 7370 | 210 |
2437065 | 2437065 | 2022-04-23 | Warren | Tennessee | 47177 | 12998 | 176 |
2437498 | 2437498 | 2022-04-23 | Warren | Virginia | 51187 | 8578 | 155 |
2431724 | 2431724 | 2022-04-22 | Warren | Georgia | 13301 | 1061 | 30 |
2431880 | 2431880 | 2022-04-22 | Warren | Illinois | 17187 | 4017 | 87 |
2431975 | 2431975 | 2022-04-22 | Warren | Indiana | 18171 | 2094 | 30 |
2432073 | 2432073 | 2022-04-22 | Warren | Iowa | 19181 | 12502 | 134 |
2432301 | 2432301 | 2022-04-22 | Warren | Kentucky | 21227 | 42954 | 364 |
2432677 | 2432677 | 2022-04-22 | Warren | Mississippi | 28149 | 10213 | 202 |
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);