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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 14
- New Jersey 788
- Kentucky 787
- New York 787
- Ohio 785
- Iowa 781
- Pennsylvania 780
- Indiana 779
- Virginia 779
- Missouri 777
- Mississippi 776
- Georgia 775
- Tennessee 775
- North Carolina 770
- Illinois 763
fips 14
county 1
- Warren · 10,902 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3532 | 3532 | 2020-03-17 | Warren | New Jersey | 34041 | 1 | 0 |
3991 | 3991 | 2020-03-18 | Warren | Kentucky | 21227 | 1 | 0 |
4165 | 4165 | 2020-03-18 | Warren | New York | 36113 | 1 | 0 |
4682 | 4682 | 2020-03-19 | Warren | Kentucky | 21227 | 1 | 0 |
4895 | 4895 | 2020-03-19 | Warren | New York | 36113 | 1 | 0 |
5746 | 5746 | 2020-03-20 | Warren | New York | 36113 | 1 | 0 |
6741 | 6741 | 2020-03-21 | Warren | New York | 36113 | 1 | 0 |
7837 | 7837 | 2020-03-22 | Warren | New York | 36113 | 1 | 0 |
9914 | 9914 | 2020-03-24 | Warren | Iowa | 19181 | 1 | 0 |
11311 | 11311 | 2020-03-25 | Warren | Iowa | 19181 | 1 | 0 |
11993 | 11993 | 2020-03-25 | Warren | Pennsylvania | 42123 | 1 | 0 |
12840 | 12840 | 2020-03-26 | Warren | Indiana | 18171 | 1 | 0 |
12878 | 12878 | 2020-03-26 | Warren | Iowa | 19181 | 1 | 0 |
13615 | 13615 | 2020-03-26 | Warren | Pennsylvania | 42123 | 1 | 0 |
14526 | 14526 | 2020-03-27 | Warren | Indiana | 18171 | 1 | 0 |
14572 | 14572 | 2020-03-27 | Warren | Iowa | 19181 | 1 | 0 |
15362 | 15362 | 2020-03-27 | Warren | Pennsylvania | 42123 | 1 | 0 |
16328 | 16328 | 2020-03-28 | Warren | Indiana | 18171 | 1 | 0 |
16379 | 16379 | 2020-03-28 | Warren | Iowa | 19181 | 1 | 0 |
16804 | 16804 | 2020-03-28 | Warren | Missouri | 29219 | 1 | 0 |
17216 | 17216 | 2020-03-28 | Warren | Pennsylvania | 42123 | 1 | 0 |
18284 | 18284 | 2020-03-29 | Warren | Iowa | 19181 | 1 | 0 |
18667 | 18667 | 2020-03-29 | Warren | Mississippi | 28149 | 1 | 0 |
19156 | 19156 | 2020-03-29 | Warren | Pennsylvania | 42123 | 1 | 0 |
20296 | 20296 | 2020-03-30 | Warren | Iowa | 19181 | 1 | 0 |
20691 | 20691 | 2020-03-30 | Warren | Mississippi | 28149 | 1 | 0 |
21207 | 21207 | 2020-03-30 | Warren | Pennsylvania | 42123 | 1 | 0 |
21360 | 21360 | 2020-03-30 | Warren | Tennessee | 47177 | 1 | 0 |
22809 | 22809 | 2020-03-31 | Warren | Mississippi | 28149 | 1 | 0 |
23344 | 23344 | 2020-03-31 | Warren | Pennsylvania | 42123 | 1 | 0 |
23499 | 23499 | 2020-03-31 | Warren | Tennessee | 47177 | 1 | 0 |
25541 | 25541 | 2020-04-01 | Warren | Pennsylvania | 42123 | 1 | 0 |
25702 | 25702 | 2020-04-01 | Warren | Tennessee | 47177 | 1 | 0 |
27814 | 27814 | 2020-04-02 | Warren | Pennsylvania | 42123 | 1 | 0 |
27982 | 27982 | 2020-04-02 | Warren | Tennessee | 47177 | 1 | 0 |
30149 | 30149 | 2020-04-03 | Warren | Pennsylvania | 42123 | 1 | 0 |
30317 | 30317 | 2020-04-03 | Warren | Tennessee | 47177 | 1 | 0 |
32289 | 32289 | 2020-04-04 | Warren | North Carolina | 37185 | 1 | 0 |
32539 | 32539 | 2020-04-04 | Warren | Pennsylvania | 42123 | 1 | 0 |
32709 | 32709 | 2020-04-04 | Warren | Tennessee | 47177 | 1 | 0 |
34975 | 34975 | 2020-04-05 | Warren | Pennsylvania | 42123 | 1 | 0 |
35146 | 35146 | 2020-04-05 | Warren | Tennessee | 47177 | 1 | 0 |
37450 | 37450 | 2020-04-06 | Warren | Pennsylvania | 42123 | 1 | 0 |
37622 | 37622 | 2020-04-06 | Warren | Tennessee | 47177 | 1 | 0 |
39973 | 39973 | 2020-04-07 | Warren | Pennsylvania | 42123 | 1 | 0 |
42533 | 42533 | 2020-04-08 | Warren | Pennsylvania | 42123 | 1 | 0 |
45119 | 45119 | 2020-04-09 | Warren | Pennsylvania | 42123 | 1 | 0 |
47736 | 47736 | 2020-04-10 | Warren | Pennsylvania | 42123 | 1 | 0 |
49058 | 49058 | 2020-04-11 | Warren | Illinois | 17187 | 1 | 0 |
50393 | 50393 | 2020-04-11 | Warren | Pennsylvania | 42123 | 1 | 0 |
53066 | 53066 | 2020-04-12 | Warren | Pennsylvania | 42123 | 1 | 0 |
55751 | 55751 | 2020-04-13 | Warren | Pennsylvania | 42123 | 1 | 0 |
58454 | 58454 | 2020-04-14 | Warren | Pennsylvania | 42123 | 1 | 0 |
61169 | 61169 | 2020-04-15 | Warren | Pennsylvania | 42123 | 1 | 0 |
63895 | 63895 | 2020-04-16 | Warren | Pennsylvania | 42123 | 1 | 0 |
66641 | 66641 | 2020-04-17 | Warren | Pennsylvania | 42123 | 1 | 0 |
69399 | 69399 | 2020-04-18 | Warren | Pennsylvania | 42123 | 1 | 0 |
72166 | 72166 | 2020-04-19 | Warren | Pennsylvania | 42123 | 1 | 0 |
74941 | 74941 | 2020-04-20 | Warren | Pennsylvania | 42123 | 1 | 0 |
83312 | 83312 | 2020-04-23 | Warren | Pennsylvania | 42123 | 1 | 1 |
86116 | 86116 | 2020-04-24 | Warren | Pennsylvania | 42123 | 1 | 1 |
88930 | 88930 | 2020-04-25 | Warren | Pennsylvania | 42123 | 1 | 1 |
91746 | 91746 | 2020-04-26 | Warren | Pennsylvania | 42123 | 1 | 1 |
94573 | 94573 | 2020-04-27 | Warren | Pennsylvania | 42123 | 1 | 1 |
97412 | 97412 | 2020-04-28 | Warren | Pennsylvania | 42123 | 1 | 1 |
100261 | 100261 | 2020-04-29 | Warren | Pennsylvania | 42123 | 1 | 1 |
103114 | 103114 | 2020-04-30 | Warren | Pennsylvania | 42123 | 1 | 1 |
105977 | 105977 | 2020-05-01 | Warren | Pennsylvania | 42123 | 1 | 1 |
108844 | 108844 | 2020-05-02 | Warren | Pennsylvania | 42123 | 1 | 1 |
111718 | 111718 | 2020-05-03 | Warren | Pennsylvania | 42123 | 1 | 1 |
114600 | 114600 | 2020-05-04 | Warren | Pennsylvania | 42123 | 1 | 1 |
117481 | 117481 | 2020-05-05 | Warren | Pennsylvania | 42123 | 1 | 1 |
120443 | 120443 | 2020-05-06 | Warren | Pennsylvania | 42123 | 1 | 1 |
123420 | 123420 | 2020-05-07 | Warren | Pennsylvania | 42123 | 1 | 1 |
126403 | 126403 | 2020-05-08 | Warren | Pennsylvania | 42123 | 1 | 1 |
129392 | 129392 | 2020-05-09 | Warren | Pennsylvania | 42123 | 1 | 1 |
132381 | 132381 | 2020-05-10 | Warren | Pennsylvania | 42123 | 1 | 1 |
135372 | 135372 | 2020-05-11 | Warren | Pennsylvania | 42123 | 1 | 1 |
138362 | 138362 | 2020-05-12 | Warren | Pennsylvania | 42123 | 1 | 1 |
4128 | 4128 | 2020-03-18 | Warren | New Jersey | 34041 | 2 | 0 |
5496 | 5496 | 2020-03-20 | Warren | Kentucky | 21227 | 2 | 0 |
5815 | 5815 | 2020-03-20 | Warren | Ohio | 39165 | 2 | 0 |
6816 | 6816 | 2020-03-21 | Warren | Ohio | 39165 | 2 | 0 |
9037 | 9037 | 2020-03-23 | Warren | New York | 36113 | 2 | 0 |
10345 | 10345 | 2020-03-24 | Warren | New York | 36113 | 2 | 0 |
11781 | 11781 | 2020-03-25 | Warren | New York | 36113 | 2 | 0 |
13384 | 13384 | 2020-03-26 | Warren | New York | 36113 | 2 | 0 |
13921 | 13921 | 2020-03-26 | Warren | Virginia | 51187 | 2 | 0 |
15689 | 15689 | 2020-03-27 | Warren | Virginia | 51187 | 2 | 0 |
17569 | 17569 | 2020-03-28 | Warren | Virginia | 51187 | 2 | 0 |
18233 | 18233 | 2020-03-29 | Warren | Indiana | 18171 | 2 | 0 |
18726 | 18726 | 2020-03-29 | Warren | Missouri | 29219 | 2 | 0 |
19532 | 19532 | 2020-03-29 | Warren | Virginia | 51187 | 2 | 0 |
20076 | 20076 | 2020-03-30 | Warren | Georgia | 13301 | 2 | 0 |
20239 | 20239 | 2020-03-30 | Warren | Indiana | 18171 | 2 | 0 |
20760 | 20760 | 2020-03-30 | Warren | Missouri | 29219 | 2 | 0 |
21599 | 21599 | 2020-03-30 | Warren | Virginia | 51187 | 2 | 0 |
22334 | 22334 | 2020-03-31 | Warren | Indiana | 18171 | 2 | 1 |
24506 | 24506 | 2020-04-01 | Warren | Indiana | 18171 | 2 | 1 |
24993 | 24993 | 2020-04-01 | Warren | Mississippi | 28149 | 2 | 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);