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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New Jersey 782
- Indiana 774
- Pennsylvania 772
- Tennessee 772
- Virginia 772
- Georgia 771
- Iowa 771
- Kentucky 771
- Mississippi 771
- Missouri 771
- New York 771
- Ohio 771
- North Carolina 770
- Illinois 763
fips 14
county 1
- Warren · 10,802 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
27814 | 27814 | 2020-04-02 | Warren | Pennsylvania | 42123 | 1 | 0 |
27982 | 27982 | 2020-04-02 | Warren | Tennessee | 47177 | 1 | 0 |
28255 | 28255 | 2020-04-02 | Warren | Virginia | 51187 | 3 | 0 |
28867 | 28867 | 2020-04-03 | Warren | Georgia | 13301 | 4 | 0 |
29123 | 29123 | 2020-04-03 | Warren | Iowa | 19181 | 8 | 0 |
29247 | 29247 | 2020-04-03 | Warren | Kentucky | 21227 | 18 | 0 |
29566 | 29566 | 2020-04-03 | Warren | Mississippi | 28149 | 2 | 0 |
29647 | 29647 | 2020-04-03 | Warren | Missouri | 29219 | 7 | 0 |
29816 | 29816 | 2020-04-03 | Warren | New York | 36113 | 19 | 0 |
30003 | 30003 | 2020-04-03 | Warren | Ohio | 39165 | 31 | 0 |
30149 | 30149 | 2020-04-03 | Warren | Pennsylvania | 42123 | 1 | 0 |
30317 | 30317 | 2020-04-03 | Warren | Tennessee | 47177 | 1 | 0 |
30605 | 30605 | 2020-04-03 | Warren | Virginia | 51187 | 4 | 0 |
31227 | 31227 | 2020-04-04 | Warren | Georgia | 13301 | 5 | 0 |
31495 | 31495 | 2020-04-04 | Warren | Iowa | 19181 | 9 | 0 |
31625 | 31625 | 2020-04-04 | Warren | Kentucky | 21227 | 19 | 0 |
31946 | 31946 | 2020-04-04 | Warren | Mississippi | 28149 | 3 | 0 |
32028 | 32028 | 2020-04-04 | Warren | Missouri | 29219 | 7 | 0 |
32289 | 32289 | 2020-04-04 | Warren | North Carolina | 37185 | 1 | 0 |
32392 | 32392 | 2020-04-04 | Warren | Ohio | 39165 | 35 | 0 |
32539 | 32539 | 2020-04-04 | Warren | Pennsylvania | 42123 | 1 | 0 |
32709 | 32709 | 2020-04-04 | Warren | Tennessee | 47177 | 1 | 0 |
33005 | 33005 | 2020-04-04 | Warren | Virginia | 51187 | 4 | 0 |
33634 | 33634 | 2020-04-05 | Warren | Georgia | 13301 | 5 | 0 |
33908 | 33908 | 2020-04-05 | Warren | Iowa | 19181 | 10 | 0 |
34050 | 34050 | 2020-04-05 | Warren | Kentucky | 21227 | 20 | 0 |
34374 | 34374 | 2020-04-05 | Warren | Mississippi | 28149 | 5 | 0 |
34456 | 34456 | 2020-04-05 | Warren | Missouri | 29219 | 9 | 0 |
34721 | 34721 | 2020-04-05 | Warren | North Carolina | 37185 | 2 | 0 |
34826 | 34826 | 2020-04-05 | Warren | Ohio | 39165 | 36 | 0 |
34975 | 34975 | 2020-04-05 | Warren | Pennsylvania | 42123 | 1 | 0 |
35146 | 35146 | 2020-04-05 | Warren | Tennessee | 47177 | 1 | 0 |
35443 | 35443 | 2020-04-05 | Warren | Virginia | 51187 | 4 | 0 |
36085 | 36085 | 2020-04-06 | Warren | Georgia | 13301 | 5 | 0 |
36364 | 36364 | 2020-04-06 | Warren | Iowa | 19181 | 11 | 0 |
36508 | 36508 | 2020-04-06 | Warren | Kentucky | 21227 | 20 | 0 |
36837 | 36837 | 2020-04-06 | Warren | Mississippi | 28149 | 5 | 0 |
36922 | 36922 | 2020-04-06 | Warren | Missouri | 29219 | 9 | 0 |
37190 | 37190 | 2020-04-06 | Warren | North Carolina | 37185 | 2 | 0 |
37299 | 37299 | 2020-04-06 | Warren | Ohio | 39165 | 37 | 0 |
37450 | 37450 | 2020-04-06 | Warren | Pennsylvania | 42123 | 1 | 0 |
37622 | 37622 | 2020-04-06 | Warren | Tennessee | 47177 | 1 | 0 |
37927 | 37927 | 2020-04-06 | Warren | Virginia | 51187 | 5 | 0 |
38578 | 38578 | 2020-04-07 | Warren | Georgia | 13301 | 6 | 0 |
38865 | 38865 | 2020-04-07 | Warren | Iowa | 19181 | 12 | 0 |
39015 | 39015 | 2020-04-07 | Warren | Kentucky | 21227 | 32 | 0 |
39348 | 39348 | 2020-04-07 | Warren | Mississippi | 28149 | 7 | 0 |
39438 | 39438 | 2020-04-07 | Warren | Missouri | 29219 | 11 | 0 |
39706 | 39706 | 2020-04-07 | Warren | North Carolina | 37185 | 3 | 0 |
39817 | 39817 | 2020-04-07 | Warren | Ohio | 39165 | 45 | 0 |
39973 | 39973 | 2020-04-07 | Warren | Pennsylvania | 42123 | 1 | 0 |
40144 | 40144 | 2020-04-07 | Warren | Tennessee | 47177 | 2 | 0 |
40462 | 40462 | 2020-04-07 | Warren | Virginia | 51187 | 6 | 0 |
41122 | 41122 | 2020-04-08 | Warren | Georgia | 13301 | 6 | 0 |
41411 | 41411 | 2020-04-08 | Warren | Iowa | 19181 | 13 | 0 |
41566 | 41566 | 2020-04-08 | Warren | Kentucky | 21227 | 32 | 0 |
41902 | 41902 | 2020-04-08 | Warren | Mississippi | 28149 | 9 | 0 |
41992 | 41992 | 2020-04-08 | Warren | Missouri | 29219 | 13 | 0 |
42263 | 42263 | 2020-04-08 | Warren | North Carolina | 37185 | 3 | 0 |
42377 | 42377 | 2020-04-08 | Warren | Ohio | 39165 | 46 | 0 |
42533 | 42533 | 2020-04-08 | Warren | Pennsylvania | 42123 | 1 | 0 |
42706 | 42706 | 2020-04-08 | Warren | Tennessee | 47177 | 2 | 0 |
43031 | 43031 | 2020-04-08 | Warren | Virginia | 51187 | 8 | 0 |
43696 | 43696 | 2020-04-09 | Warren | Georgia | 13301 | 6 | 0 |
43987 | 43987 | 2020-04-09 | Warren | Iowa | 19181 | 13 | 0 |
44142 | 44142 | 2020-04-09 | Warren | Kentucky | 21227 | 35 | 0 |
44479 | 44479 | 2020-04-09 | Warren | Mississippi | 28149 | 10 | 0 |
44571 | 44571 | 2020-04-09 | Warren | Missouri | 29219 | 12 | 0 |
44847 | 44847 | 2020-04-09 | Warren | North Carolina | 37185 | 3 | 0 |
44963 | 44963 | 2020-04-09 | Warren | Ohio | 39165 | 53 | 0 |
45119 | 45119 | 2020-04-09 | Warren | Pennsylvania | 42123 | 1 | 0 |
45294 | 45294 | 2020-04-09 | Warren | Tennessee | 47177 | 3 | 0 |
45627 | 45627 | 2020-04-09 | Warren | Virginia | 51187 | 9 | 0 |
46298 | 46298 | 2020-04-10 | Warren | Georgia | 13301 | 6 | 0 |
46594 | 46594 | 2020-04-10 | Warren | Iowa | 19181 | 15 | 0 |
46750 | 46750 | 2020-04-10 | Warren | Kentucky | 21227 | 35 | 0 |
47088 | 47088 | 2020-04-10 | Warren | Mississippi | 28149 | 12 | 0 |
47180 | 47180 | 2020-04-10 | Warren | Missouri | 29219 | 11 | 0 |
47460 | 47460 | 2020-04-10 | Warren | North Carolina | 37185 | 3 | 0 |
47578 | 47578 | 2020-04-10 | Warren | Ohio | 39165 | 72 | 0 |
47736 | 47736 | 2020-04-10 | Warren | Pennsylvania | 42123 | 1 | 0 |
47912 | 47912 | 2020-04-10 | Warren | Tennessee | 47177 | 3 | 0 |
48254 | 48254 | 2020-04-10 | Warren | Virginia | 51187 | 10 | 0 |
48929 | 48929 | 2020-04-11 | Warren | Georgia | 13301 | 6 | 0 |
49058 | 49058 | 2020-04-11 | Warren | Illinois | 17187 | 1 | 0 |
49228 | 49228 | 2020-04-11 | Warren | Iowa | 19181 | 15 | 0 |
49391 | 49391 | 2020-04-11 | Warren | Kentucky | 21227 | 49 | 0 |
49734 | 49734 | 2020-04-11 | Warren | Mississippi | 28149 | 11 | 0 |
49828 | 49828 | 2020-04-11 | Warren | Missouri | 29219 | 11 | 0 |
50115 | 50115 | 2020-04-11 | Warren | North Carolina | 37185 | 3 | 0 |
50234 | 50234 | 2020-04-11 | Warren | Ohio | 39165 | 74 | 0 |
50393 | 50393 | 2020-04-11 | Warren | Pennsylvania | 42123 | 1 | 0 |
50569 | 50569 | 2020-04-11 | Warren | Tennessee | 47177 | 4 | 0 |
50912 | 50912 | 2020-04-11 | Warren | Virginia | 51187 | 15 | 0 |
51591 | 51591 | 2020-04-12 | Warren | Georgia | 13301 | 7 | 0 |
51720 | 51720 | 2020-04-12 | Warren | Illinois | 17187 | 2 | 0 |
51892 | 51892 | 2020-04-12 | Warren | Iowa | 19181 | 16 | 0 |
52061 | 52061 | 2020-04-12 | Warren | Kentucky | 21227 | 46 | 0 |
52407 | 52407 | 2020-04-12 | Warren | Mississippi | 28149 | 14 | 0 |
52501 | 52501 | 2020-04-12 | Warren | Missouri | 29219 | 12 | 0 |
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);