ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 3 and county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
- North Carolina 18
- Pennsylvania 13
- Indiana 4
- Virginia 3
- Tennessee 2
- Georgia 1
- Iowa 1
- Mississippi 1
- Ohio 1
county 1
- Warren · 44 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
202121 | 202121 | 2020-06-02 | Warren | Pennsylvania | 42123 | 3 | 0 |
199046 | 199046 | 2020-06-01 | Warren | Pennsylvania | 42123 | 3 | 0 |
195973 | 195973 | 2020-05-31 | Warren | Pennsylvania | 42123 | 3 | 0 |
192904 | 192904 | 2020-05-30 | Warren | Pennsylvania | 42123 | 3 | 0 |
189839 | 189839 | 2020-05-29 | Warren | Pennsylvania | 42123 | 3 | 0 |
186778 | 186778 | 2020-05-28 | Warren | Pennsylvania | 42123 | 3 | 0 |
183721 | 183721 | 2020-05-27 | Warren | Pennsylvania | 42123 | 3 | 0 |
180671 | 180671 | 2020-05-26 | Warren | Pennsylvania | 42123 | 3 | 0 |
177628 | 177628 | 2020-05-25 | Warren | Pennsylvania | 42123 | 3 | 0 |
174584 | 174584 | 2020-05-24 | Warren | Pennsylvania | 42123 | 3 | 0 |
171542 | 171542 | 2020-05-23 | Warren | Pennsylvania | 42123 | 3 | 0 |
168503 | 168503 | 2020-05-22 | Warren | Pennsylvania | 42123 | 3 | 0 |
165467 | 165467 | 2020-05-21 | Warren | Pennsylvania | 42123 | 3 | 0 |
85827 | 85827 | 2020-04-24 | Warren | North Carolina | 37185 | 3 | 0 |
83023 | 83023 | 2020-04-23 | Warren | North Carolina | 37185 | 3 | 0 |
80224 | 80224 | 2020-04-22 | Warren | North Carolina | 37185 | 3 | 0 |
77435 | 77435 | 2020-04-21 | Warren | North Carolina | 37185 | 3 | 0 |
74654 | 74654 | 2020-04-20 | Warren | North Carolina | 37185 | 3 | 0 |
71879 | 71879 | 2020-04-19 | Warren | North Carolina | 37185 | 3 | 0 |
69113 | 69113 | 2020-04-18 | Warren | North Carolina | 37185 | 3 | 0 |
66356 | 66356 | 2020-04-17 | Warren | North Carolina | 37185 | 3 | 0 |
63613 | 63613 | 2020-04-16 | Warren | North Carolina | 37185 | 3 | 0 |
59894 | 59894 | 2020-04-15 | Warren | Indiana | 18171 | 3 | 1 |
60887 | 60887 | 2020-04-15 | Warren | North Carolina | 37185 | 3 | 0 |
57186 | 57186 | 2020-04-14 | Warren | Indiana | 18171 | 3 | 1 |
58173 | 58173 | 2020-04-14 | Warren | North Carolina | 37185 | 3 | 0 |
54493 | 54493 | 2020-04-13 | Warren | Indiana | 18171 | 3 | 1 |
55472 | 55472 | 2020-04-13 | Warren | North Carolina | 37185 | 3 | 0 |
51812 | 51812 | 2020-04-12 | Warren | Indiana | 18171 | 3 | 1 |
52788 | 52788 | 2020-04-12 | Warren | North Carolina | 37185 | 3 | 0 |
50115 | 50115 | 2020-04-11 | Warren | North Carolina | 37185 | 3 | 0 |
47460 | 47460 | 2020-04-10 | Warren | North Carolina | 37185 | 3 | 0 |
47912 | 47912 | 2020-04-10 | Warren | Tennessee | 47177 | 3 | 0 |
44847 | 44847 | 2020-04-09 | Warren | North Carolina | 37185 | 3 | 0 |
45294 | 45294 | 2020-04-09 | Warren | Tennessee | 47177 | 3 | 0 |
42263 | 42263 | 2020-04-08 | Warren | North Carolina | 37185 | 3 | 0 |
39706 | 39706 | 2020-04-07 | Warren | North Carolina | 37185 | 3 | 0 |
31946 | 31946 | 2020-04-04 | Warren | Mississippi | 28149 | 3 | 0 |
28255 | 28255 | 2020-04-02 | Warren | Virginia | 51187 | 3 | 0 |
25965 | 25965 | 2020-04-01 | Warren | Virginia | 51187 | 3 | 0 |
22162 | 22162 | 2020-03-31 | Warren | Georgia | 13301 | 3 | 0 |
22392 | 22392 | 2020-03-31 | Warren | Iowa | 19181 | 3 | 0 |
23747 | 23747 | 2020-03-31 | Warren | Virginia | 51187 | 3 | 0 |
7928 | 7928 | 2020-03-22 | Warren | Ohio | 39165 | 3 | 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);