ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Blair" and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
13577 | 13577 | 2020-03-26 | Blair | Pennsylvania | 42013 | 1 | 0 |
15323 | 15323 | 2020-03-27 | Blair | Pennsylvania | 42013 | 1 | 0 |
17170 | 17170 | 2020-03-28 | Blair | Pennsylvania | 42013 | 2 | 0 |
19108 | 19108 | 2020-03-29 | Blair | Pennsylvania | 42013 | 3 | 0 |
21158 | 21158 | 2020-03-30 | Blair | Pennsylvania | 42013 | 6 | 0 |
23294 | 23294 | 2020-03-31 | Blair | Pennsylvania | 42013 | 6 | 0 |
25492 | 25492 | 2020-04-01 | Blair | Pennsylvania | 42013 | 6 | 0 |
27764 | 27764 | 2020-04-02 | Blair | Pennsylvania | 42013 | 6 | 0 |
30097 | 30097 | 2020-04-03 | Blair | Pennsylvania | 42013 | 6 | 0 |
32487 | 32487 | 2020-04-04 | Blair | Pennsylvania | 42013 | 6 | 0 |
34922 | 34922 | 2020-04-05 | Blair | Pennsylvania | 42013 | 6 | 0 |
37397 | 37397 | 2020-04-06 | Blair | Pennsylvania | 42013 | 6 | 0 |
39918 | 39918 | 2020-04-07 | Blair | Pennsylvania | 42013 | 6 | 0 |
42478 | 42478 | 2020-04-08 | Blair | Pennsylvania | 42013 | 6 | 0 |
45064 | 45064 | 2020-04-09 | Blair | Pennsylvania | 42013 | 6 | 0 |
47681 | 47681 | 2020-04-10 | Blair | Pennsylvania | 42013 | 9 | 0 |
50338 | 50338 | 2020-04-11 | Blair | Pennsylvania | 42013 | 10 | 0 |
53011 | 53011 | 2020-04-12 | Blair | Pennsylvania | 42013 | 10 | 0 |
55696 | 55696 | 2020-04-13 | Blair | Pennsylvania | 42013 | 11 | 0 |
58399 | 58399 | 2020-04-14 | Blair | Pennsylvania | 42013 | 11 | 0 |
61114 | 61114 | 2020-04-15 | Blair | Pennsylvania | 42013 | 12 | 0 |
63840 | 63840 | 2020-04-16 | Blair | Pennsylvania | 42013 | 13 | 0 |
66586 | 66586 | 2020-04-17 | Blair | Pennsylvania | 42013 | 14 | 0 |
69344 | 69344 | 2020-04-18 | Blair | Pennsylvania | 42013 | 14 | 0 |
72111 | 72111 | 2020-04-19 | Blair | Pennsylvania | 42013 | 14 | 0 |
74886 | 74886 | 2020-04-20 | Blair | Pennsylvania | 42013 | 14 | 0 |
77668 | 77668 | 2020-04-21 | Blair | Pennsylvania | 42013 | 14 | 0 |
80458 | 80458 | 2020-04-22 | Blair | Pennsylvania | 42013 | 14 | 0 |
83257 | 83257 | 2020-04-23 | Blair | Pennsylvania | 42013 | 15 | 0 |
86061 | 86061 | 2020-04-24 | Blair | Pennsylvania | 42013 | 19 | 0 |
88875 | 88875 | 2020-04-25 | Blair | Pennsylvania | 42013 | 21 | 0 |
91691 | 91691 | 2020-04-26 | Blair | Pennsylvania | 42013 | 21 | 0 |
94518 | 94518 | 2020-04-27 | Blair | Pennsylvania | 42013 | 21 | 0 |
97357 | 97357 | 2020-04-28 | Blair | Pennsylvania | 42013 | 21 | 0 |
100206 | 100206 | 2020-04-29 | Blair | Pennsylvania | 42013 | 23 | 0 |
103059 | 103059 | 2020-04-30 | Blair | Pennsylvania | 42013 | 23 | 0 |
105922 | 105922 | 2020-05-01 | Blair | Pennsylvania | 42013 | 23 | 0 |
108789 | 108789 | 2020-05-02 | Blair | Pennsylvania | 42013 | 23 | 0 |
111663 | 111663 | 2020-05-03 | Blair | Pennsylvania | 42013 | 24 | 0 |
114545 | 114545 | 2020-05-04 | Blair | Pennsylvania | 42013 | 25 | 0 |
117426 | 117426 | 2020-05-05 | Blair | Pennsylvania | 42013 | 25 | 0 |
120388 | 120388 | 2020-05-06 | Blair | Pennsylvania | 42013 | 25 | 0 |
123365 | 123365 | 2020-05-07 | Blair | Pennsylvania | 42013 | 28 | 0 |
126348 | 126348 | 2020-05-08 | Blair | Pennsylvania | 42013 | 28 | 0 |
129337 | 129337 | 2020-05-09 | Blair | Pennsylvania | 42013 | 28 | 0 |
132326 | 132326 | 2020-05-10 | Blair | Pennsylvania | 42013 | 28 | 0 |
135317 | 135317 | 2020-05-11 | Blair | Pennsylvania | 42013 | 29 | 0 |
138307 | 138307 | 2020-05-12 | Blair | Pennsylvania | 42013 | 30 | 0 |
141303 | 141303 | 2020-05-13 | Blair | Pennsylvania | 42013 | 31 | 0 |
144299 | 144299 | 2020-05-14 | Blair | Pennsylvania | 42013 | 32 | 0 |
147300 | 147300 | 2020-05-15 | Blair | Pennsylvania | 42013 | 32 | 0 |
150307 | 150307 | 2020-05-16 | Blair | Pennsylvania | 42013 | 34 | 0 |
153318 | 153318 | 2020-05-17 | Blair | Pennsylvania | 42013 | 38 | 0 |
156335 | 156335 | 2020-05-18 | Blair | Pennsylvania | 42013 | 38 | 1 |
159356 | 159356 | 2020-05-19 | Blair | Pennsylvania | 42013 | 38 | 1 |
162383 | 162383 | 2020-05-20 | Blair | Pennsylvania | 42013 | 39 | 1 |
165412 | 165412 | 2020-05-21 | Blair | Pennsylvania | 42013 | 44 | 1 |
168448 | 168448 | 2020-05-22 | Blair | Pennsylvania | 42013 | 46 | 1 |
171487 | 171487 | 2020-05-23 | Blair | Pennsylvania | 42013 | 46 | 1 |
174529 | 174529 | 2020-05-24 | Blair | Pennsylvania | 42013 | 46 | 1 |
177573 | 177573 | 2020-05-25 | Blair | Pennsylvania | 42013 | 48 | 1 |
180616 | 180616 | 2020-05-26 | Blair | Pennsylvania | 42013 | 48 | 1 |
183666 | 183666 | 2020-05-27 | Blair | Pennsylvania | 42013 | 48 | 1 |
186723 | 186723 | 2020-05-28 | Blair | Pennsylvania | 42013 | 49 | 1 |
189784 | 189784 | 2020-05-29 | Blair | Pennsylvania | 42013 | 49 | 1 |
192849 | 192849 | 2020-05-30 | Blair | Pennsylvania | 42013 | 50 | 1 |
195918 | 195918 | 2020-05-31 | Blair | Pennsylvania | 42013 | 50 | 1 |
198991 | 198991 | 2020-06-01 | Blair | Pennsylvania | 42013 | 50 | 1 |
202066 | 202066 | 2020-06-02 | Blair | Pennsylvania | 42013 | 51 | 1 |
205143 | 205143 | 2020-06-03 | Blair | Pennsylvania | 42013 | 52 | 1 |
208224 | 208224 | 2020-06-04 | Blair | Pennsylvania | 42013 | 52 | 1 |
211306 | 211306 | 2020-06-05 | Blair | Pennsylvania | 42013 | 53 | 1 |
214392 | 214392 | 2020-06-06 | Blair | Pennsylvania | 42013 | 53 | 1 |
217482 | 217482 | 2020-06-07 | Blair | Pennsylvania | 42013 | 53 | 1 |
220574 | 220574 | 2020-06-08 | Blair | Pennsylvania | 42013 | 53 | 1 |
223669 | 223669 | 2020-06-09 | Blair | Pennsylvania | 42013 | 53 | 1 |
226769 | 226769 | 2020-06-10 | Blair | Pennsylvania | 42013 | 53 | 1 |
229873 | 229873 | 2020-06-11 | Blair | Pennsylvania | 42013 | 53 | 1 |
232978 | 232978 | 2020-06-12 | Blair | Pennsylvania | 42013 | 54 | 1 |
236083 | 236083 | 2020-06-13 | Blair | Pennsylvania | 42013 | 55 | 1 |
239191 | 239191 | 2020-06-14 | Blair | Pennsylvania | 42013 | 55 | 1 |
242300 | 242300 | 2020-06-15 | Blair | Pennsylvania | 42013 | 55 | 1 |
245412 | 245412 | 2020-06-16 | Blair | Pennsylvania | 42013 | 55 | 1 |
248525 | 248525 | 2020-06-17 | Blair | Pennsylvania | 42013 | 55 | 1 |
251640 | 251640 | 2020-06-18 | Blair | Pennsylvania | 42013 | 55 | 1 |
254755 | 254755 | 2020-06-19 | Blair | Pennsylvania | 42013 | 56 | 1 |
257881 | 257881 | 2020-06-20 | Blair | Pennsylvania | 42013 | 58 | 1 |
261008 | 261008 | 2020-06-21 | Blair | Pennsylvania | 42013 | 58 | 1 |
264136 | 264136 | 2020-06-22 | Blair | Pennsylvania | 42013 | 58 | 1 |
267264 | 267264 | 2020-06-23 | Blair | Pennsylvania | 42013 | 61 | 1 |
270398 | 270398 | 2020-06-24 | Blair | Pennsylvania | 42013 | 69 | 1 |
273537 | 273537 | 2020-06-25 | Blair | Pennsylvania | 42013 | 69 | 1 |
276684 | 276684 | 2020-06-26 | Blair | Pennsylvania | 42013 | 69 | 1 |
279832 | 279832 | 2020-06-27 | Blair | Pennsylvania | 42013 | 71 | 1 |
282978 | 282978 | 2020-06-28 | Blair | Pennsylvania | 42013 | 71 | 1 |
286123 | 286123 | 2020-06-29 | Blair | Pennsylvania | 42013 | 72 | 1 |
289274 | 289274 | 2020-06-30 | Blair | Pennsylvania | 42013 | 71 | 1 |
292426 | 292426 | 2020-07-01 | Blair | Pennsylvania | 42013 | 72 | 1 |
295582 | 295582 | 2020-07-02 | Blair | Pennsylvania | 42013 | 74 | 1 |
298741 | 298741 | 2020-07-03 | Blair | Pennsylvania | 42013 | 79 | 1 |
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);