ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 42081 and state = "Pennsylvania" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11982 | 11982 | 2020-03-25 | Lycoming | Pennsylvania | 42081 | 1 | 0 |
13603 | 13603 | 2020-03-26 | Lycoming | Pennsylvania | 42081 | 1 | 0 |
15349 | 15349 | 2020-03-27 | Lycoming | Pennsylvania | 42081 | 2 | 0 |
17199 | 17199 | 2020-03-28 | Lycoming | Pennsylvania | 42081 | 2 | 0 |
19137 | 19137 | 2020-03-29 | Lycoming | Pennsylvania | 42081 | 3 | 0 |
21187 | 21187 | 2020-03-30 | Lycoming | Pennsylvania | 42081 | 4 | 0 |
23323 | 23323 | 2020-03-31 | Lycoming | Pennsylvania | 42081 | 6 | 0 |
25521 | 25521 | 2020-04-01 | Lycoming | Pennsylvania | 42081 | 7 | 0 |
27794 | 27794 | 2020-04-02 | Lycoming | Pennsylvania | 42081 | 7 | 0 |
30128 | 30128 | 2020-04-03 | Lycoming | Pennsylvania | 42081 | 8 | 0 |
32518 | 32518 | 2020-04-04 | Lycoming | Pennsylvania | 42081 | 10 | 0 |
34954 | 34954 | 2020-04-05 | Lycoming | Pennsylvania | 42081 | 9 | 0 |
37429 | 37429 | 2020-04-06 | Lycoming | Pennsylvania | 42081 | 10 | 0 |
39952 | 39952 | 2020-04-07 | Lycoming | Pennsylvania | 42081 | 12 | 0 |
42512 | 42512 | 2020-04-08 | Lycoming | Pennsylvania | 42081 | 15 | 0 |
45098 | 45098 | 2020-04-09 | Lycoming | Pennsylvania | 42081 | 17 | 0 |
47715 | 47715 | 2020-04-10 | Lycoming | Pennsylvania | 42081 | 18 | 0 |
50372 | 50372 | 2020-04-11 | Lycoming | Pennsylvania | 42081 | 20 | 0 |
53045 | 53045 | 2020-04-12 | Lycoming | Pennsylvania | 42081 | 23 | 0 |
55730 | 55730 | 2020-04-13 | Lycoming | Pennsylvania | 42081 | 28 | 0 |
58433 | 58433 | 2020-04-14 | Lycoming | Pennsylvania | 42081 | 29 | 0 |
61148 | 61148 | 2020-04-15 | Lycoming | Pennsylvania | 42081 | 30 | 0 |
63874 | 63874 | 2020-04-16 | Lycoming | Pennsylvania | 42081 | 30 | 0 |
66620 | 66620 | 2020-04-17 | Lycoming | Pennsylvania | 42081 | 32 | 0 |
69378 | 69378 | 2020-04-18 | Lycoming | Pennsylvania | 42081 | 36 | 0 |
72145 | 72145 | 2020-04-19 | Lycoming | Pennsylvania | 42081 | 37 | 0 |
74920 | 74920 | 2020-04-20 | Lycoming | Pennsylvania | 42081 | 40 | 0 |
77702 | 77702 | 2020-04-21 | Lycoming | Pennsylvania | 42081 | 42 | 2 |
80492 | 80492 | 2020-04-22 | Lycoming | Pennsylvania | 42081 | 43 | 2 |
83291 | 83291 | 2020-04-23 | Lycoming | Pennsylvania | 42081 | 44 | 2 |
86095 | 86095 | 2020-04-24 | Lycoming | Pennsylvania | 42081 | 48 | 2 |
88909 | 88909 | 2020-04-25 | Lycoming | Pennsylvania | 42081 | 53 | 2 |
91725 | 91725 | 2020-04-26 | Lycoming | Pennsylvania | 42081 | 55 | 2 |
94552 | 94552 | 2020-04-27 | Lycoming | Pennsylvania | 42081 | 57 | 2 |
97391 | 97391 | 2020-04-28 | Lycoming | Pennsylvania | 42081 | 58 | 2 |
100240 | 100240 | 2020-04-29 | Lycoming | Pennsylvania | 42081 | 61 | 2 |
103093 | 103093 | 2020-04-30 | Lycoming | Pennsylvania | 42081 | 68 | 2 |
105956 | 105956 | 2020-05-01 | Lycoming | Pennsylvania | 42081 | 71 | 2 |
108823 | 108823 | 2020-05-02 | Lycoming | Pennsylvania | 42081 | 81 | 2 |
111697 | 111697 | 2020-05-03 | Lycoming | Pennsylvania | 42081 | 85 | 2 |
114579 | 114579 | 2020-05-04 | Lycoming | Pennsylvania | 42081 | 86 | 3 |
117460 | 117460 | 2020-05-05 | Lycoming | Pennsylvania | 42081 | 86 | 4 |
120422 | 120422 | 2020-05-06 | Lycoming | Pennsylvania | 42081 | 90 | 4 |
123399 | 123399 | 2020-05-07 | Lycoming | Pennsylvania | 42081 | 99 | 4 |
126382 | 126382 | 2020-05-08 | Lycoming | Pennsylvania | 42081 | 109 | 4 |
129371 | 129371 | 2020-05-09 | Lycoming | Pennsylvania | 42081 | 127 | 4 |
132360 | 132360 | 2020-05-10 | Lycoming | Pennsylvania | 42081 | 131 | 4 |
135351 | 135351 | 2020-05-11 | Lycoming | Pennsylvania | 42081 | 132 | 4 |
138341 | 138341 | 2020-05-12 | Lycoming | Pennsylvania | 42081 | 132 | 5 |
141337 | 141337 | 2020-05-13 | Lycoming | Pennsylvania | 42081 | 139 | 7 |
144333 | 144333 | 2020-05-14 | Lycoming | Pennsylvania | 42081 | 139 | 7 |
147334 | 147334 | 2020-05-15 | Lycoming | Pennsylvania | 42081 | 141 | 7 |
150341 | 150341 | 2020-05-16 | Lycoming | Pennsylvania | 42081 | 146 | 7 |
153352 | 153352 | 2020-05-17 | Lycoming | Pennsylvania | 42081 | 147 | 7 |
156369 | 156369 | 2020-05-18 | Lycoming | Pennsylvania | 42081 | 149 | 8 |
159390 | 159390 | 2020-05-19 | Lycoming | Pennsylvania | 42081 | 149 | 9 |
162417 | 162417 | 2020-05-20 | Lycoming | Pennsylvania | 42081 | 152 | 9 |
165446 | 165446 | 2020-05-21 | Lycoming | Pennsylvania | 42081 | 152 | 10 |
168482 | 168482 | 2020-05-22 | Lycoming | Pennsylvania | 42081 | 155 | 12 |
171521 | 171521 | 2020-05-23 | Lycoming | Pennsylvania | 42081 | 158 | 13 |
174563 | 174563 | 2020-05-24 | Lycoming | Pennsylvania | 42081 | 158 | 14 |
177607 | 177607 | 2020-05-25 | Lycoming | Pennsylvania | 42081 | 160 | 14 |
180650 | 180650 | 2020-05-26 | Lycoming | Pennsylvania | 42081 | 161 | 14 |
183700 | 183700 | 2020-05-27 | Lycoming | Pennsylvania | 42081 | 161 | 15 |
186757 | 186757 | 2020-05-28 | Lycoming | Pennsylvania | 42081 | 162 | 16 |
189818 | 189818 | 2020-05-29 | Lycoming | Pennsylvania | 42081 | 162 | 16 |
192883 | 192883 | 2020-05-30 | Lycoming | Pennsylvania | 42081 | 164 | 17 |
195952 | 195952 | 2020-05-31 | Lycoming | Pennsylvania | 42081 | 164 | 17 |
199025 | 199025 | 2020-06-01 | Lycoming | Pennsylvania | 42081 | 164 | 17 |
202100 | 202100 | 2020-06-02 | Lycoming | Pennsylvania | 42081 | 164 | 17 |
205177 | 205177 | 2020-06-03 | Lycoming | Pennsylvania | 42081 | 166 | 17 |
208258 | 208258 | 2020-06-04 | Lycoming | Pennsylvania | 42081 | 166 | 17 |
211340 | 211340 | 2020-06-05 | Lycoming | Pennsylvania | 42081 | 166 | 17 |
214426 | 214426 | 2020-06-06 | Lycoming | Pennsylvania | 42081 | 166 | 17 |
217516 | 217516 | 2020-06-07 | Lycoming | Pennsylvania | 42081 | 167 | 17 |
220608 | 220608 | 2020-06-08 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
223703 | 223703 | 2020-06-09 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
226803 | 226803 | 2020-06-10 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
229907 | 229907 | 2020-06-11 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
233012 | 233012 | 2020-06-12 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
236117 | 236117 | 2020-06-13 | Lycoming | Pennsylvania | 42081 | 171 | 17 |
239225 | 239225 | 2020-06-14 | Lycoming | Pennsylvania | 42081 | 171 | 17 |
242334 | 242334 | 2020-06-15 | Lycoming | Pennsylvania | 42081 | 171 | 17 |
245446 | 245446 | 2020-06-16 | Lycoming | Pennsylvania | 42081 | 172 | 17 |
248559 | 248559 | 2020-06-17 | Lycoming | Pennsylvania | 42081 | 172 | 18 |
251674 | 251674 | 2020-06-18 | Lycoming | Pennsylvania | 42081 | 172 | 18 |
254789 | 254789 | 2020-06-19 | Lycoming | Pennsylvania | 42081 | 172 | 19 |
257915 | 257915 | 2020-06-20 | Lycoming | Pennsylvania | 42081 | 172 | 19 |
261042 | 261042 | 2020-06-21 | Lycoming | Pennsylvania | 42081 | 173 | 19 |
264170 | 264170 | 2020-06-22 | Lycoming | Pennsylvania | 42081 | 173 | 19 |
267298 | 267298 | 2020-06-23 | Lycoming | Pennsylvania | 42081 | 173 | 19 |
270432 | 270432 | 2020-06-24 | Lycoming | Pennsylvania | 42081 | 175 | 19 |
273571 | 273571 | 2020-06-25 | Lycoming | Pennsylvania | 42081 | 176 | 19 |
276718 | 276718 | 2020-06-26 | Lycoming | Pennsylvania | 42081 | 176 | 19 |
279866 | 279866 | 2020-06-27 | Lycoming | Pennsylvania | 42081 | 176 | 19 |
283012 | 283012 | 2020-06-28 | Lycoming | Pennsylvania | 42081 | 177 | 19 |
286157 | 286157 | 2020-06-29 | Lycoming | Pennsylvania | 42081 | 179 | 19 |
289308 | 289308 | 2020-06-30 | Lycoming | Pennsylvania | 42081 | 182 | 19 |
292460 | 292460 | 2020-07-01 | Lycoming | Pennsylvania | 42081 | 187 | 19 |
295616 | 295616 | 2020-07-02 | Lycoming | Pennsylvania | 42081 | 193 | 20 |
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);