ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
4251 | 4251 | 2020-03-18 | Northampton | Pennsylvania | 42095 | 1 | 1 |
4992 | 4992 | 2020-03-19 | Northampton | Pennsylvania | 42095 | 5 | 1 |
5864 | 5864 | 2020-03-20 | Northampton | Pennsylvania | 42095 | 10 | 1 |
6868 | 6868 | 2020-03-21 | Northampton | Pennsylvania | 42095 | 17 | 1 |
7987 | 7987 | 2020-03-22 | Northampton | Pennsylvania | 42095 | 21 | 1 |
9198 | 9198 | 2020-03-23 | Northampton | Pennsylvania | 42095 | 23 | 1 |
10522 | 10522 | 2020-03-24 | Northampton | Pennsylvania | 42095 | 33 | 2 |
11987 | 11987 | 2020-03-25 | Northampton | Pennsylvania | 42095 | 44 | 3 |
13608 | 13608 | 2020-03-26 | Northampton | Pennsylvania | 42095 | 56 | 3 |
15354 | 15354 | 2020-03-27 | Northampton | Pennsylvania | 42095 | 79 | 3 |
17205 | 17205 | 2020-03-28 | Northampton | Pennsylvania | 42095 | 94 | 4 |
19144 | 19144 | 2020-03-29 | Northampton | Pennsylvania | 42095 | 126 | 4 |
21194 | 21194 | 2020-03-30 | Northampton | Pennsylvania | 42095 | 184 | 5 |
23330 | 23330 | 2020-03-31 | Northampton | Pennsylvania | 42095 | 245 | 5 |
25528 | 25528 | 2020-04-01 | Northampton | Pennsylvania | 42095 | 312 | 5 |
27801 | 27801 | 2020-04-02 | Northampton | Pennsylvania | 42095 | 378 | 9 |
30135 | 30135 | 2020-04-03 | Northampton | Pennsylvania | 42095 | 466 | 10 |
32525 | 32525 | 2020-04-04 | Northampton | Pennsylvania | 42095 | 588 | 11 |
34961 | 34961 | 2020-04-05 | Northampton | Pennsylvania | 42095 | 636 | 11 |
37436 | 37436 | 2020-04-06 | Northampton | Pennsylvania | 42095 | 716 | 12 |
39959 | 39959 | 2020-04-07 | Northampton | Pennsylvania | 42095 | 774 | 14 |
42519 | 42519 | 2020-04-08 | Northampton | Pennsylvania | 42095 | 857 | 17 |
45105 | 45105 | 2020-04-09 | Northampton | Pennsylvania | 42095 | 949 | 20 |
47722 | 47722 | 2020-04-10 | Northampton | Pennsylvania | 42095 | 994 | 21 |
50379 | 50379 | 2020-04-11 | Northampton | Pennsylvania | 42095 | 1039 | 23 |
53052 | 53052 | 2020-04-12 | Northampton | Pennsylvania | 42095 | 1082 | 23 |
55737 | 55737 | 2020-04-13 | Northampton | Pennsylvania | 42095 | 1130 | 23 |
58440 | 58440 | 2020-04-14 | Northampton | Pennsylvania | 42095 | 1176 | 25 |
61155 | 61155 | 2020-04-15 | Northampton | Pennsylvania | 42095 | 1251 | 25 |
63881 | 63881 | 2020-04-16 | Northampton | Pennsylvania | 42095 | 1296 | 25 |
66627 | 66627 | 2020-04-17 | Northampton | Pennsylvania | 42095 | 1335 | 27 |
69385 | 69385 | 2020-04-18 | Northampton | Pennsylvania | 42095 | 1396 | 29 |
72152 | 72152 | 2020-04-19 | Northampton | Pennsylvania | 42095 | 1441 | 36 |
74927 | 74927 | 2020-04-20 | Northampton | Pennsylvania | 42095 | 1469 | 36 |
77709 | 77709 | 2020-04-21 | Northampton | Pennsylvania | 42095 | 1544 | 43 |
80499 | 80499 | 2020-04-22 | Northampton | Pennsylvania | 42095 | 1591 | 44 |
83298 | 83298 | 2020-04-23 | Northampton | Pennsylvania | 42095 | 1656 | 45 |
86102 | 86102 | 2020-04-24 | Northampton | Pennsylvania | 42095 | 1716 | 46 |
88916 | 88916 | 2020-04-25 | Northampton | Pennsylvania | 42095 | 1780 | 49 |
91732 | 91732 | 2020-04-26 | Northampton | Pennsylvania | 42095 | 1813 | 49 |
94559 | 94559 | 2020-04-27 | Northampton | Pennsylvania | 42095 | 1834 | 49 |
97398 | 97398 | 2020-04-28 | Northampton | Pennsylvania | 42095 | 1970 | 55 |
100247 | 100247 | 2020-04-29 | Northampton | Pennsylvania | 42095 | 2008 | 85 |
103100 | 103100 | 2020-04-30 | Northampton | Pennsylvania | 42095 | 2050 | 94 |
105963 | 105963 | 2020-05-01 | Northampton | Pennsylvania | 42095 | 2103 | 94 |
108830 | 108830 | 2020-05-02 | Northampton | Pennsylvania | 42095 | 2182 | 94 |
111704 | 111704 | 2020-05-03 | Northampton | Pennsylvania | 42095 | 2214 | 94 |
114586 | 114586 | 2020-05-04 | Northampton | Pennsylvania | 42095 | 2240 | 94 |
117467 | 117467 | 2020-05-05 | Northampton | Pennsylvania | 42095 | 2279 | 117 |
120429 | 120429 | 2020-05-06 | Northampton | Pennsylvania | 42095 | 2313 | 122 |
123406 | 123406 | 2020-05-07 | Northampton | Pennsylvania | 42095 | 2355 | 152 |
126389 | 126389 | 2020-05-08 | Northampton | Pennsylvania | 42095 | 2390 | 153 |
129378 | 129378 | 2020-05-09 | Northampton | Pennsylvania | 42095 | 2429 | 158 |
132367 | 132367 | 2020-05-10 | Northampton | Pennsylvania | 42095 | 2453 | 158 |
135358 | 135358 | 2020-05-11 | Northampton | Pennsylvania | 42095 | 2465 | 160 |
138348 | 138348 | 2020-05-12 | Northampton | Pennsylvania | 42095 | 2499 | 161 |
141344 | 141344 | 2020-05-13 | Northampton | Pennsylvania | 42095 | 2518 | 162 |
144340 | 144340 | 2020-05-14 | Northampton | Pennsylvania | 42095 | 2566 | 182 |
147341 | 147341 | 2020-05-15 | Northampton | Pennsylvania | 42095 | 2600 | 196 |
150348 | 150348 | 2020-05-16 | Northampton | Pennsylvania | 42095 | 2659 | 196 |
153359 | 153359 | 2020-05-17 | Northampton | Pennsylvania | 42095 | 2703 | 199 |
156376 | 156376 | 2020-05-18 | Northampton | Pennsylvania | 42095 | 2727 | 171 |
159397 | 159397 | 2020-05-19 | Northampton | Pennsylvania | 42095 | 2758 | 176 |
162424 | 162424 | 2020-05-20 | Northampton | Pennsylvania | 42095 | 2779 | 182 |
165453 | 165453 | 2020-05-21 | Northampton | Pennsylvania | 42095 | 2814 | 186 |
168489 | 168489 | 2020-05-22 | Northampton | Pennsylvania | 42095 | 2842 | 192 |
171528 | 171528 | 2020-05-23 | Northampton | Pennsylvania | 42095 | 2866 | 197 |
174570 | 174570 | 2020-05-24 | Northampton | Pennsylvania | 42095 | 2911 | 198 |
177614 | 177614 | 2020-05-25 | Northampton | Pennsylvania | 42095 | 2920 | 199 |
180657 | 180657 | 2020-05-26 | Northampton | Pennsylvania | 42095 | 2933 | 199 |
183707 | 183707 | 2020-05-27 | Northampton | Pennsylvania | 42095 | 2958 | 203 |
186764 | 186764 | 2020-05-28 | Northampton | Pennsylvania | 42095 | 3022 | 206 |
189825 | 189825 | 2020-05-29 | Northampton | Pennsylvania | 42095 | 3045 | 207 |
192890 | 192890 | 2020-05-30 | Northampton | Pennsylvania | 42095 | 3062 | 210 |
195959 | 195959 | 2020-05-31 | Northampton | Pennsylvania | 42095 | 3083 | 210 |
199032 | 199032 | 2020-06-01 | Northampton | Pennsylvania | 42095 | 3082 | 210 |
202107 | 202107 | 2020-06-02 | Northampton | Pennsylvania | 42095 | 3108 | 213 |
205184 | 205184 | 2020-06-03 | Northampton | Pennsylvania | 42095 | 3120 | 220 |
208265 | 208265 | 2020-06-04 | Northampton | Pennsylvania | 42095 | 3124 | 225 |
211347 | 211347 | 2020-06-05 | Northampton | Pennsylvania | 42095 | 3136 | 229 |
214433 | 214433 | 2020-06-06 | Northampton | Pennsylvania | 42095 | 3144 | 231 |
217523 | 217523 | 2020-06-07 | Northampton | Pennsylvania | 42095 | 3151 | 232 |
220615 | 220615 | 2020-06-08 | Northampton | Pennsylvania | 42095 | 3168 | 232 |
223710 | 223710 | 2020-06-09 | Northampton | Pennsylvania | 42095 | 3175 | 236 |
226810 | 226810 | 2020-06-10 | Northampton | Pennsylvania | 42095 | 3193 | 238 |
229914 | 229914 | 2020-06-11 | Northampton | Pennsylvania | 42095 | 3202 | 238 |
233019 | 233019 | 2020-06-12 | Northampton | Pennsylvania | 42095 | 3217 | 238 |
236124 | 236124 | 2020-06-13 | Northampton | Pennsylvania | 42095 | 3232 | 241 |
239232 | 239232 | 2020-06-14 | Northampton | Pennsylvania | 42095 | 3240 | 241 |
242341 | 242341 | 2020-06-15 | Northampton | Pennsylvania | 42095 | 3246 | 243 |
245453 | 245453 | 2020-06-16 | Northampton | Pennsylvania | 42095 | 3250 | 244 |
248566 | 248566 | 2020-06-17 | Northampton | Pennsylvania | 42095 | 3255 | 247 |
251681 | 251681 | 2020-06-18 | Northampton | Pennsylvania | 42095 | 3270 | 249 |
254796 | 254796 | 2020-06-19 | Northampton | Pennsylvania | 42095 | 3284 | 250 |
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);