ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Armstrong" 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 |
---|---|---|---|---|---|---|---|
10494 | 10494 | 2020-03-24 | Armstrong | Pennsylvania | 42005 | 1 | 0 |
11956 | 11956 | 2020-03-25 | Armstrong | Pennsylvania | 42005 | 1 | 0 |
13574 | 13574 | 2020-03-26 | Armstrong | Pennsylvania | 42005 | 1 | 0 |
15320 | 15320 | 2020-03-27 | Armstrong | Pennsylvania | 42005 | 1 | 0 |
17167 | 17167 | 2020-03-28 | Armstrong | Pennsylvania | 42005 | 2 | 0 |
19105 | 19105 | 2020-03-29 | Armstrong | Pennsylvania | 42005 | 3 | 0 |
21155 | 21155 | 2020-03-30 | Armstrong | Pennsylvania | 42005 | 3 | 0 |
23290 | 23290 | 2020-03-31 | Armstrong | Pennsylvania | 42005 | 5 | 0 |
25488 | 25488 | 2020-04-01 | Armstrong | Pennsylvania | 42005 | 5 | 0 |
27760 | 27760 | 2020-04-02 | Armstrong | Pennsylvania | 42005 | 7 | 0 |
30093 | 30093 | 2020-04-03 | Armstrong | Pennsylvania | 42005 | 11 | 0 |
32483 | 32483 | 2020-04-04 | Armstrong | Pennsylvania | 42005 | 12 | 0 |
34918 | 34918 | 2020-04-05 | Armstrong | Pennsylvania | 42005 | 12 | 0 |
37393 | 37393 | 2020-04-06 | Armstrong | Pennsylvania | 42005 | 13 | 0 |
39914 | 39914 | 2020-04-07 | Armstrong | Pennsylvania | 42005 | 18 | 0 |
42474 | 42474 | 2020-04-08 | Armstrong | Pennsylvania | 42005 | 19 | 0 |
45060 | 45060 | 2020-04-09 | Armstrong | Pennsylvania | 42005 | 20 | 0 |
47677 | 47677 | 2020-04-10 | Armstrong | Pennsylvania | 42005 | 22 | 0 |
50334 | 50334 | 2020-04-11 | Armstrong | Pennsylvania | 42005 | 26 | 1 |
53007 | 53007 | 2020-04-12 | Armstrong | Pennsylvania | 42005 | 27 | 1 |
55692 | 55692 | 2020-04-13 | Armstrong | Pennsylvania | 42005 | 28 | 1 |
58395 | 58395 | 2020-04-14 | Armstrong | Pennsylvania | 42005 | 28 | 1 |
61110 | 61110 | 2020-04-15 | Armstrong | Pennsylvania | 42005 | 29 | 1 |
63836 | 63836 | 2020-04-16 | Armstrong | Pennsylvania | 42005 | 32 | 1 |
66582 | 66582 | 2020-04-17 | Armstrong | Pennsylvania | 42005 | 32 | 2 |
69340 | 69340 | 2020-04-18 | Armstrong | Pennsylvania | 42005 | 36 | 2 |
72107 | 72107 | 2020-04-19 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
74882 | 74882 | 2020-04-20 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
77664 | 77664 | 2020-04-21 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
80454 | 80454 | 2020-04-22 | Armstrong | Pennsylvania | 42005 | 39 | 2 |
83253 | 83253 | 2020-04-23 | Armstrong | Pennsylvania | 42005 | 32 | 2 |
86057 | 86057 | 2020-04-24 | Armstrong | Pennsylvania | 42005 | 43 | 2 |
88871 | 88871 | 2020-04-25 | Armstrong | Pennsylvania | 42005 | 46 | 2 |
91687 | 91687 | 2020-04-26 | Armstrong | Pennsylvania | 42005 | 46 | 2 |
94514 | 94514 | 2020-04-27 | Armstrong | Pennsylvania | 42005 | 47 | 2 |
97353 | 97353 | 2020-04-28 | Armstrong | Pennsylvania | 42005 | 50 | 2 |
100202 | 100202 | 2020-04-29 | Armstrong | Pennsylvania | 42005 | 50 | 2 |
103055 | 103055 | 2020-04-30 | Armstrong | Pennsylvania | 42005 | 51 | 2 |
105918 | 105918 | 2020-05-01 | Armstrong | Pennsylvania | 42005 | 52 | 2 |
108785 | 108785 | 2020-05-02 | Armstrong | Pennsylvania | 42005 | 52 | 2 |
111659 | 111659 | 2020-05-03 | Armstrong | Pennsylvania | 42005 | 52 | 2 |
114541 | 114541 | 2020-05-04 | Armstrong | Pennsylvania | 42005 | 52 | 2 |
117422 | 117422 | 2020-05-05 | Armstrong | Pennsylvania | 42005 | 53 | 3 |
120384 | 120384 | 2020-05-06 | Armstrong | Pennsylvania | 42005 | 55 | 3 |
123361 | 123361 | 2020-05-07 | Armstrong | Pennsylvania | 42005 | 55 | 3 |
126344 | 126344 | 2020-05-08 | Armstrong | Pennsylvania | 42005 | 55 | 3 |
129333 | 129333 | 2020-05-09 | Armstrong | Pennsylvania | 42005 | 55 | 3 |
132322 | 132322 | 2020-05-10 | Armstrong | Pennsylvania | 42005 | 55 | 4 |
135313 | 135313 | 2020-05-11 | Armstrong | Pennsylvania | 42005 | 55 | 5 |
138303 | 138303 | 2020-05-12 | Armstrong | Pennsylvania | 42005 | 55 | 5 |
141299 | 141299 | 2020-05-13 | Armstrong | Pennsylvania | 42005 | 56 | 5 |
144295 | 144295 | 2020-05-14 | Armstrong | Pennsylvania | 42005 | 56 | 5 |
147296 | 147296 | 2020-05-15 | Armstrong | Pennsylvania | 42005 | 57 | 5 |
150303 | 150303 | 2020-05-16 | Armstrong | Pennsylvania | 42005 | 58 | 5 |
153314 | 153314 | 2020-05-17 | Armstrong | Pennsylvania | 42005 | 58 | 5 |
156331 | 156331 | 2020-05-18 | Armstrong | Pennsylvania | 42005 | 58 | 2 |
159352 | 159352 | 2020-05-19 | Armstrong | Pennsylvania | 42005 | 58 | 2 |
162379 | 162379 | 2020-05-20 | Armstrong | Pennsylvania | 42005 | 58 | 2 |
165408 | 165408 | 2020-05-21 | Armstrong | Pennsylvania | 42005 | 58 | 2 |
168444 | 168444 | 2020-05-22 | Armstrong | Pennsylvania | 42005 | 58 | 2 |
171483 | 171483 | 2020-05-23 | Armstrong | Pennsylvania | 42005 | 58 | 3 |
174525 | 174525 | 2020-05-24 | Armstrong | Pennsylvania | 42005 | 58 | 3 |
177569 | 177569 | 2020-05-25 | Armstrong | Pennsylvania | 42005 | 58 | 3 |
180612 | 180612 | 2020-05-26 | Armstrong | Pennsylvania | 42005 | 59 | 3 |
183662 | 183662 | 2020-05-27 | Armstrong | Pennsylvania | 42005 | 61 | 4 |
186719 | 186719 | 2020-05-28 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
189780 | 189780 | 2020-05-29 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
192845 | 192845 | 2020-05-30 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
195914 | 195914 | 2020-05-31 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
198987 | 198987 | 2020-06-01 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
202062 | 202062 | 2020-06-02 | Armstrong | Pennsylvania | 42005 | 62 | 5 |
205139 | 205139 | 2020-06-03 | Armstrong | Pennsylvania | 42005 | 64 | 5 |
208220 | 208220 | 2020-06-04 | Armstrong | Pennsylvania | 42005 | 64 | 5 |
211302 | 211302 | 2020-06-05 | Armstrong | Pennsylvania | 42005 | 64 | 5 |
214388 | 214388 | 2020-06-06 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
217478 | 217478 | 2020-06-07 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
220570 | 220570 | 2020-06-08 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
223665 | 223665 | 2020-06-09 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
226765 | 226765 | 2020-06-10 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
229869 | 229869 | 2020-06-11 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
232974 | 232974 | 2020-06-12 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
236079 | 236079 | 2020-06-13 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
239187 | 239187 | 2020-06-14 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
242296 | 242296 | 2020-06-15 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
245408 | 245408 | 2020-06-16 | Armstrong | Pennsylvania | 42005 | 68 | 5 |
248521 | 248521 | 2020-06-17 | Armstrong | Pennsylvania | 42005 | 68 | 5 |
251636 | 251636 | 2020-06-18 | Armstrong | Pennsylvania | 42005 | 68 | 5 |
254751 | 254751 | 2020-06-19 | Armstrong | Pennsylvania | 42005 | 69 | 6 |
257877 | 257877 | 2020-06-20 | Armstrong | Pennsylvania | 42005 | 69 | 6 |
261004 | 261004 | 2020-06-21 | Armstrong | Pennsylvania | 42005 | 69 | 6 |
264132 | 264132 | 2020-06-22 | Armstrong | Pennsylvania | 42005 | 69 | 6 |
267260 | 267260 | 2020-06-23 | Armstrong | Pennsylvania | 42005 | 70 | 6 |
270394 | 270394 | 2020-06-24 | Armstrong | Pennsylvania | 42005 | 70 | 6 |
273533 | 273533 | 2020-06-25 | Armstrong | Pennsylvania | 42005 | 70 | 6 |
276680 | 276680 | 2020-06-26 | Armstrong | Pennsylvania | 42005 | 72 | 6 |
279828 | 279828 | 2020-06-27 | Armstrong | Pennsylvania | 42005 | 73 | 6 |
282974 | 282974 | 2020-06-28 | Armstrong | Pennsylvania | 42005 | 73 | 6 |
286119 | 286119 | 2020-06-29 | Armstrong | Pennsylvania | 42005 | 73 | 6 |
289270 | 289270 | 2020-06-30 | Armstrong | Pennsylvania | 42005 | 74 | 6 |
292422 | 292422 | 2020-07-01 | Armstrong | Pennsylvania | 42005 | 76 | 6 |
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);