ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Juniata" 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 |
---|---|---|---|---|---|---|---|
10512 | 10512 | 2020-03-24 | Juniata | Pennsylvania | 42067 | 1 | 0 |
11975 | 11975 | 2020-03-25 | Juniata | Pennsylvania | 42067 | 1 | 0 |
13596 | 13596 | 2020-03-26 | Juniata | Pennsylvania | 42067 | 1 | 0 |
15342 | 15342 | 2020-03-27 | Juniata | Pennsylvania | 42067 | 1 | 0 |
17192 | 17192 | 2020-03-28 | Juniata | Pennsylvania | 42067 | 1 | 0 |
19130 | 19130 | 2020-03-29 | Juniata | Pennsylvania | 42067 | 1 | 0 |
21180 | 21180 | 2020-03-30 | Juniata | Pennsylvania | 42067 | 3 | 0 |
23316 | 23316 | 2020-03-31 | Juniata | Pennsylvania | 42067 | 3 | 0 |
25514 | 25514 | 2020-04-01 | Juniata | Pennsylvania | 42067 | 3 | 0 |
27787 | 27787 | 2020-04-02 | Juniata | Pennsylvania | 42067 | 3 | 0 |
30121 | 30121 | 2020-04-03 | Juniata | Pennsylvania | 42067 | 5 | 0 |
32511 | 32511 | 2020-04-04 | Juniata | Pennsylvania | 42067 | 7 | 0 |
34947 | 34947 | 2020-04-05 | Juniata | Pennsylvania | 42067 | 7 | 0 |
37422 | 37422 | 2020-04-06 | Juniata | Pennsylvania | 42067 | 11 | 0 |
39945 | 39945 | 2020-04-07 | Juniata | Pennsylvania | 42067 | 14 | 0 |
42505 | 42505 | 2020-04-08 | Juniata | Pennsylvania | 42067 | 18 | 0 |
45091 | 45091 | 2020-04-09 | Juniata | Pennsylvania | 42067 | 23 | 0 |
47708 | 47708 | 2020-04-10 | Juniata | Pennsylvania | 42067 | 30 | 0 |
50365 | 50365 | 2020-04-11 | Juniata | Pennsylvania | 42067 | 38 | 0 |
53038 | 53038 | 2020-04-12 | Juniata | Pennsylvania | 42067 | 38 | 0 |
55723 | 55723 | 2020-04-13 | Juniata | Pennsylvania | 42067 | 39 | 0 |
58426 | 58426 | 2020-04-14 | Juniata | Pennsylvania | 42067 | 43 | 0 |
61141 | 61141 | 2020-04-15 | Juniata | Pennsylvania | 42067 | 47 | 0 |
63867 | 63867 | 2020-04-16 | Juniata | Pennsylvania | 42067 | 56 | 0 |
66613 | 66613 | 2020-04-17 | Juniata | Pennsylvania | 42067 | 63 | 0 |
69371 | 69371 | 2020-04-18 | Juniata | Pennsylvania | 42067 | 66 | 0 |
72138 | 72138 | 2020-04-19 | Juniata | Pennsylvania | 42067 | 70 | 0 |
74913 | 74913 | 2020-04-20 | Juniata | Pennsylvania | 42067 | 72 | 0 |
77695 | 77695 | 2020-04-21 | Juniata | Pennsylvania | 42067 | 72 | 0 |
80485 | 80485 | 2020-04-22 | Juniata | Pennsylvania | 42067 | 73 | 0 |
83284 | 83284 | 2020-04-23 | Juniata | Pennsylvania | 42067 | 77 | 0 |
86088 | 86088 | 2020-04-24 | Juniata | Pennsylvania | 42067 | 77 | 0 |
88902 | 88902 | 2020-04-25 | Juniata | Pennsylvania | 42067 | 77 | 0 |
91718 | 91718 | 2020-04-26 | Juniata | Pennsylvania | 42067 | 78 | 0 |
94545 | 94545 | 2020-04-27 | Juniata | Pennsylvania | 42067 | 79 | 0 |
97384 | 97384 | 2020-04-28 | Juniata | Pennsylvania | 42067 | 81 | 0 |
100233 | 100233 | 2020-04-29 | Juniata | Pennsylvania | 42067 | 82 | 1 |
103086 | 103086 | 2020-04-30 | Juniata | Pennsylvania | 42067 | 83 | 1 |
105949 | 105949 | 2020-05-01 | Juniata | Pennsylvania | 42067 | 84 | 1 |
108816 | 108816 | 2020-05-02 | Juniata | Pennsylvania | 42067 | 84 | 1 |
111690 | 111690 | 2020-05-03 | Juniata | Pennsylvania | 42067 | 86 | 1 |
114572 | 114572 | 2020-05-04 | Juniata | Pennsylvania | 42067 | 86 | 1 |
117453 | 117453 | 2020-05-05 | Juniata | Pennsylvania | 42067 | 86 | 1 |
120415 | 120415 | 2020-05-06 | Juniata | Pennsylvania | 42067 | 86 | 1 |
123392 | 123392 | 2020-05-07 | Juniata | Pennsylvania | 42067 | 92 | 1 |
126375 | 126375 | 2020-05-08 | Juniata | Pennsylvania | 42067 | 93 | 1 |
129364 | 129364 | 2020-05-09 | Juniata | Pennsylvania | 42067 | 93 | 1 |
132353 | 132353 | 2020-05-10 | Juniata | Pennsylvania | 42067 | 93 | 1 |
135344 | 135344 | 2020-05-11 | Juniata | Pennsylvania | 42067 | 93 | 1 |
138334 | 138334 | 2020-05-12 | Juniata | Pennsylvania | 42067 | 94 | 1 |
141330 | 141330 | 2020-05-13 | Juniata | Pennsylvania | 42067 | 94 | 1 |
144326 | 144326 | 2020-05-14 | Juniata | Pennsylvania | 42067 | 94 | 1 |
147327 | 147327 | 2020-05-15 | Juniata | Pennsylvania | 42067 | 94 | 1 |
150334 | 150334 | 2020-05-16 | Juniata | Pennsylvania | 42067 | 94 | 1 |
153345 | 153345 | 2020-05-17 | Juniata | Pennsylvania | 42067 | 94 | 1 |
156362 | 156362 | 2020-05-18 | Juniata | Pennsylvania | 42067 | 94 | 2 |
159383 | 159383 | 2020-05-19 | Juniata | Pennsylvania | 42067 | 94 | 2 |
162410 | 162410 | 2020-05-20 | Juniata | Pennsylvania | 42067 | 94 | 2 |
165439 | 165439 | 2020-05-21 | Juniata | Pennsylvania | 42067 | 94 | 3 |
168475 | 168475 | 2020-05-22 | Juniata | Pennsylvania | 42067 | 94 | 4 |
171514 | 171514 | 2020-05-23 | Juniata | Pennsylvania | 42067 | 94 | 4 |
174556 | 174556 | 2020-05-24 | Juniata | Pennsylvania | 42067 | 95 | 4 |
177600 | 177600 | 2020-05-25 | Juniata | Pennsylvania | 42067 | 95 | 4 |
180643 | 180643 | 2020-05-26 | Juniata | Pennsylvania | 42067 | 95 | 4 |
183693 | 183693 | 2020-05-27 | Juniata | Pennsylvania | 42067 | 95 | 4 |
186750 | 186750 | 2020-05-28 | Juniata | Pennsylvania | 42067 | 95 | 4 |
189811 | 189811 | 2020-05-29 | Juniata | Pennsylvania | 42067 | 95 | 4 |
192876 | 192876 | 2020-05-30 | Juniata | Pennsylvania | 42067 | 95 | 4 |
195945 | 195945 | 2020-05-31 | Juniata | Pennsylvania | 42067 | 95 | 4 |
199018 | 199018 | 2020-06-01 | Juniata | Pennsylvania | 42067 | 95 | 4 |
202093 | 202093 | 2020-06-02 | Juniata | Pennsylvania | 42067 | 95 | 4 |
205170 | 205170 | 2020-06-03 | Juniata | Pennsylvania | 42067 | 95 | 4 |
208251 | 208251 | 2020-06-04 | Juniata | Pennsylvania | 42067 | 95 | 4 |
211333 | 211333 | 2020-06-05 | Juniata | Pennsylvania | 42067 | 95 | 4 |
214419 | 214419 | 2020-06-06 | Juniata | Pennsylvania | 42067 | 96 | 4 |
217509 | 217509 | 2020-06-07 | Juniata | Pennsylvania | 42067 | 97 | 4 |
220601 | 220601 | 2020-06-08 | Juniata | Pennsylvania | 42067 | 99 | 4 |
223696 | 223696 | 2020-06-09 | Juniata | Pennsylvania | 42067 | 101 | 5 |
226796 | 226796 | 2020-06-10 | Juniata | Pennsylvania | 42067 | 102 | 5 |
229900 | 229900 | 2020-06-11 | Juniata | Pennsylvania | 42067 | 105 | 5 |
233005 | 233005 | 2020-06-12 | Juniata | Pennsylvania | 42067 | 105 | 5 |
236110 | 236110 | 2020-06-13 | Juniata | Pennsylvania | 42067 | 107 | 5 |
239218 | 239218 | 2020-06-14 | Juniata | Pennsylvania | 42067 | 108 | 5 |
242327 | 242327 | 2020-06-15 | Juniata | Pennsylvania | 42067 | 108 | 5 |
245439 | 245439 | 2020-06-16 | Juniata | Pennsylvania | 42067 | 108 | 5 |
248552 | 248552 | 2020-06-17 | Juniata | Pennsylvania | 42067 | 108 | 5 |
251667 | 251667 | 2020-06-18 | Juniata | Pennsylvania | 42067 | 109 | 5 |
254782 | 254782 | 2020-06-19 | Juniata | Pennsylvania | 42067 | 109 | 5 |
257908 | 257908 | 2020-06-20 | Juniata | Pennsylvania | 42067 | 109 | 5 |
261035 | 261035 | 2020-06-21 | Juniata | Pennsylvania | 42067 | 108 | 5 |
264163 | 264163 | 2020-06-22 | Juniata | Pennsylvania | 42067 | 108 | 5 |
267291 | 267291 | 2020-06-23 | Juniata | Pennsylvania | 42067 | 108 | 5 |
270425 | 270425 | 2020-06-24 | Juniata | Pennsylvania | 42067 | 109 | 5 |
273564 | 273564 | 2020-06-25 | Juniata | Pennsylvania | 42067 | 109 | 5 |
276711 | 276711 | 2020-06-26 | Juniata | Pennsylvania | 42067 | 110 | 5 |
279859 | 279859 | 2020-06-27 | Juniata | Pennsylvania | 42067 | 111 | 5 |
283005 | 283005 | 2020-06-28 | Juniata | Pennsylvania | 42067 | 111 | 5 |
286150 | 286150 | 2020-06-29 | Juniata | Pennsylvania | 42067 | 111 | 5 |
289301 | 289301 | 2020-06-30 | Juniata | Pennsylvania | 42067 | 111 | 6 |
292453 | 292453 | 2020-07-01 | Juniata | Pennsylvania | 42067 | 111 | 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);