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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New York 773
- Ohio 773
- Pennsylvania 773
- Tennessee 773
- Virginia 773
- Georgia 772
- Indiana 772
- Iowa 772
- Kentucky 772
- Mississippi 772
- Missouri 772
- New Jersey 772
- North Carolina 770
- Illinois 763
fips 14
county 1
- Warren · 10,802 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25232 | 25232 | 2020-04-01 | Warren | New York | 36113 | 18 | 0 |
25406 | 25406 | 2020-04-01 | Warren | Ohio | 39165 | 23 | 0 |
25541 | 25541 | 2020-04-01 | Warren | Pennsylvania | 42123 | 1 | 0 |
25702 | 25702 | 2020-04-01 | Warren | Tennessee | 47177 | 1 | 0 |
25965 | 25965 | 2020-04-01 | Warren | Virginia | 51187 | 3 | 0 |
26560 | 26560 | 2020-04-02 | Warren | Georgia | 13301 | 4 | 0 |
26746 | 26746 | 2020-04-02 | Warren | Indiana | 18171 | 2 | 1 |
26809 | 26809 | 2020-04-02 | Warren | Iowa | 19181 | 6 | 0 |
26930 | 26930 | 2020-04-02 | Warren | Kentucky | 21227 | 18 | 0 |
27247 | 27247 | 2020-04-02 | Warren | Mississippi | 28149 | 2 | 0 |
27325 | 27325 | 2020-04-02 | Warren | Missouri | 29219 | 7 | 0 |
27417 | 27417 | 2020-04-02 | Warren | New Jersey | 34041 | 116 | 3 |
27492 | 27492 | 2020-04-02 | Warren | New York | 36113 | 19 | 0 |
27674 | 27674 | 2020-04-02 | Warren | Ohio | 39165 | 26 | 0 |
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 |
29057 | 29057 | 2020-04-03 | Warren | Indiana | 18171 | 2 | 1 |
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 |
29740 | 29740 | 2020-04-03 | Warren | New Jersey | 34041 | 149 | 3 |
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 |
31425 | 31425 | 2020-04-04 | Warren | Indiana | 18171 | 2 | 1 |
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 |
32125 | 32125 | 2020-04-04 | Warren | New Jersey | 34041 | 182 | 6 |
32202 | 32202 | 2020-04-04 | Warren | New York | 36113 | 20 | 1 |
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 |
33836 | 33836 | 2020-04-05 | Warren | Indiana | 18171 | 2 | 1 |
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 |
34556 | 34556 | 2020-04-05 | Warren | New Jersey | 34041 | 195 | 6 |
34633 | 34633 | 2020-04-05 | Warren | New York | 36113 | 25 | 1 |
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 |
36289 | 36289 | 2020-04-06 | Warren | Indiana | 18171 | 2 | 1 |
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 |
37026 | 37026 | 2020-04-06 | Warren | New Jersey | 34041 | 215 | 7 |
37102 | 37102 | 2020-04-06 | Warren | New York | 36113 | 26 | 1 |
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 |
38787 | 38787 | 2020-04-07 | Warren | Indiana | 18171 | 2 | 1 |
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 |
39541 | 39541 | 2020-04-07 | Warren | New Jersey | 34041 | 255 | 7 |
39617 | 39617 | 2020-04-07 | Warren | New York | 36113 | 31 | 1 |
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 |
41333 | 41333 | 2020-04-08 | Warren | Indiana | 18171 | 2 | 1 |
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 |
42098 | 42098 | 2020-04-08 | Warren | New Jersey | 34041 | 289 | 9 |
42174 | 42174 | 2020-04-08 | Warren | New York | 36113 | 33 | 1 |
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 |
43909 | 43909 | 2020-04-09 | Warren | Indiana | 18171 | 2 | 1 |
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 |
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);