ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lehigh", fips = 42077 and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2634 | 2634 | 2020-03-15 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3099 | 3099 | 2020-03-16 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3629 | 3629 | 2020-03-17 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
4247 | 4247 | 2020-03-18 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
4988 | 4988 | 2020-03-19 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
5860 | 5860 | 2020-03-20 | Lehigh | Pennsylvania | 42077 | 2 | 0 |
6863 | 6863 | 2020-03-21 | Lehigh | Pennsylvania | 42077 | 13 | 0 |
7981 | 7981 | 2020-03-22 | Lehigh | Pennsylvania | 42077 | 19 | 0 |
9192 | 9192 | 2020-03-23 | Lehigh | Pennsylvania | 42077 | 25 | 0 |
10516 | 10516 | 2020-03-24 | Lehigh | Pennsylvania | 42077 | 27 | 0 |
11980 | 11980 | 2020-03-25 | Lehigh | Pennsylvania | 42077 | 38 | 0 |
13601 | 13601 | 2020-03-26 | Lehigh | Pennsylvania | 42077 | 63 | 1 |
15347 | 15347 | 2020-03-27 | Lehigh | Pennsylvania | 42077 | 93 | 2 |
17197 | 17197 | 2020-03-28 | Lehigh | Pennsylvania | 42077 | 109 | 3 |
19135 | 19135 | 2020-03-29 | Lehigh | Pennsylvania | 42077 | 151 | 3 |
21185 | 21185 | 2020-03-30 | Lehigh | Pennsylvania | 42077 | 231 | 3 |
23321 | 23321 | 2020-03-31 | Lehigh | Pennsylvania | 42077 | 272 | 4 |
25519 | 25519 | 2020-04-01 | Lehigh | Pennsylvania | 42077 | 374 | 5 |
27792 | 27792 | 2020-04-02 | Lehigh | Pennsylvania | 42077 | 479 | 5 |
30126 | 30126 | 2020-04-03 | Lehigh | Pennsylvania | 42077 | 584 | 5 |
32516 | 32516 | 2020-04-04 | Lehigh | Pennsylvania | 42077 | 804 | 7 |
34952 | 34952 | 2020-04-05 | Lehigh | Pennsylvania | 42077 | 877 | 8 |
37427 | 37427 | 2020-04-06 | Lehigh | Pennsylvania | 42077 | 1006 | 8 |
39950 | 39950 | 2020-04-07 | Lehigh | Pennsylvania | 42077 | 1146 | 10 |
42510 | 42510 | 2020-04-08 | Lehigh | Pennsylvania | 42077 | 1319 | 11 |
45096 | 45096 | 2020-04-09 | Lehigh | Pennsylvania | 42077 | 1466 | 13 |
47713 | 47713 | 2020-04-10 | Lehigh | Pennsylvania | 42077 | 1562 | 16 |
50370 | 50370 | 2020-04-11 | Lehigh | Pennsylvania | 42077 | 1620 | 16 |
53043 | 53043 | 2020-04-12 | Lehigh | Pennsylvania | 42077 | 1684 | 18 |
55728 | 55728 | 2020-04-13 | Lehigh | Pennsylvania | 42077 | 1747 | 19 |
58431 | 58431 | 2020-04-14 | Lehigh | Pennsylvania | 42077 | 1803 | 23 |
61146 | 61146 | 2020-04-15 | Lehigh | Pennsylvania | 42077 | 1922 | 25 |
63872 | 63872 | 2020-04-16 | Lehigh | Pennsylvania | 42077 | 1999 | 28 |
66618 | 66618 | 2020-04-17 | Lehigh | Pennsylvania | 42077 | 2092 | 29 |
69376 | 69376 | 2020-04-18 | Lehigh | Pennsylvania | 42077 | 2141 | 29 |
72143 | 72143 | 2020-04-19 | Lehigh | Pennsylvania | 42077 | 2203 | 32 |
74918 | 74918 | 2020-04-20 | Lehigh | Pennsylvania | 42077 | 2245 | 33 |
77700 | 77700 | 2020-04-21 | Lehigh | Pennsylvania | 42077 | 2295 | 49 |
80490 | 80490 | 2020-04-22 | Lehigh | Pennsylvania | 42077 | 2374 | 49 |
83289 | 83289 | 2020-04-23 | Lehigh | Pennsylvania | 42077 | 2418 | 49 |
86093 | 86093 | 2020-04-24 | Lehigh | Pennsylvania | 42077 | 2478 | 49 |
88907 | 88907 | 2020-04-25 | Lehigh | Pennsylvania | 42077 | 2551 | 50 |
91723 | 91723 | 2020-04-26 | Lehigh | Pennsylvania | 42077 | 2601 | 51 |
94550 | 94550 | 2020-04-27 | Lehigh | Pennsylvania | 42077 | 2636 | 56 |
97389 | 97389 | 2020-04-28 | Lehigh | Pennsylvania | 42077 | 2685 | 64 |
100238 | 100238 | 2020-04-29 | Lehigh | Pennsylvania | 42077 | 2719 | 72 |
103091 | 103091 | 2020-04-30 | Lehigh | Pennsylvania | 42077 | 2796 | 74 |
105954 | 105954 | 2020-05-01 | Lehigh | Pennsylvania | 42077 | 2850 | 80 |
108821 | 108821 | 2020-05-02 | Lehigh | Pennsylvania | 42077 | 2896 | 83 |
111695 | 111695 | 2020-05-03 | Lehigh | Pennsylvania | 42077 | 2924 | 83 |
114577 | 114577 | 2020-05-04 | Lehigh | Pennsylvania | 42077 | 2963 | 83 |
117458 | 117458 | 2020-05-05 | Lehigh | Pennsylvania | 42077 | 2999 | 94 |
120420 | 120420 | 2020-05-06 | Lehigh | Pennsylvania | 42077 | 3063 | 102 |
123397 | 123397 | 2020-05-07 | Lehigh | Pennsylvania | 42077 | 3102 | 111 |
126380 | 126380 | 2020-05-08 | Lehigh | Pennsylvania | 42077 | 3140 | 114 |
129369 | 129369 | 2020-05-09 | Lehigh | Pennsylvania | 42077 | 3169 | 120 |
132358 | 132358 | 2020-05-10 | Lehigh | Pennsylvania | 42077 | 3241 | 121 |
135349 | 135349 | 2020-05-11 | Lehigh | Pennsylvania | 42077 | 3259 | 121 |
138339 | 138339 | 2020-05-12 | Lehigh | Pennsylvania | 42077 | 3286 | 123 |
141335 | 141335 | 2020-05-13 | Lehigh | Pennsylvania | 42077 | 3318 | 129 |
144331 | 144331 | 2020-05-14 | Lehigh | Pennsylvania | 42077 | 3378 | 133 |
147332 | 147332 | 2020-05-15 | Lehigh | Pennsylvania | 42077 | 3396 | 136 |
150339 | 150339 | 2020-05-16 | Lehigh | Pennsylvania | 42077 | 3440 | 139 |
153350 | 153350 | 2020-05-17 | Lehigh | Pennsylvania | 42077 | 3470 | 139 |
156367 | 156367 | 2020-05-18 | Lehigh | Pennsylvania | 42077 | 3491 | 173 |
159388 | 159388 | 2020-05-19 | Lehigh | Pennsylvania | 42077 | 3513 | 182 |
162415 | 162415 | 2020-05-20 | Lehigh | Pennsylvania | 42077 | 3550 | 188 |
165444 | 165444 | 2020-05-21 | Lehigh | Pennsylvania | 42077 | 3586 | 192 |
168480 | 168480 | 2020-05-22 | Lehigh | Pennsylvania | 42077 | 3613 | 197 |
171519 | 171519 | 2020-05-23 | Lehigh | Pennsylvania | 42077 | 3628 | 202 |
174561 | 174561 | 2020-05-24 | Lehigh | Pennsylvania | 42077 | 3651 | 206 |
177605 | 177605 | 2020-05-25 | Lehigh | Pennsylvania | 42077 | 3667 | 209 |
180648 | 180648 | 2020-05-26 | Lehigh | Pennsylvania | 42077 | 3676 | 210 |
183698 | 183698 | 2020-05-27 | Lehigh | Pennsylvania | 42077 | 3699 | 215 |
186755 | 186755 | 2020-05-28 | Lehigh | Pennsylvania | 42077 | 3719 | 218 |
189816 | 189816 | 2020-05-29 | Lehigh | Pennsylvania | 42077 | 3738 | 222 |
192881 | 192881 | 2020-05-30 | Lehigh | Pennsylvania | 42077 | 3747 | 228 |
195950 | 195950 | 2020-05-31 | Lehigh | Pennsylvania | 42077 | 3765 | 228 |
199023 | 199023 | 2020-06-01 | Lehigh | Pennsylvania | 42077 | 3770 | 228 |
202098 | 202098 | 2020-06-02 | Lehigh | Pennsylvania | 42077 | 3780 | 235 |
205175 | 205175 | 2020-06-03 | Lehigh | Pennsylvania | 42077 | 3802 | 239 |
208256 | 208256 | 2020-06-04 | Lehigh | Pennsylvania | 42077 | 3817 | 242 |
211338 | 211338 | 2020-06-05 | Lehigh | Pennsylvania | 42077 | 3829 | 245 |
214424 | 214424 | 2020-06-06 | Lehigh | Pennsylvania | 42077 | 3846 | 248 |
217514 | 217514 | 2020-06-07 | Lehigh | Pennsylvania | 42077 | 3858 | 248 |
220606 | 220606 | 2020-06-08 | Lehigh | Pennsylvania | 42077 | 3871 | 249 |
223701 | 223701 | 2020-06-09 | Lehigh | Pennsylvania | 42077 | 3890 | 253 |
226801 | 226801 | 2020-06-10 | Lehigh | Pennsylvania | 42077 | 3895 | 259 |
229905 | 229905 | 2020-06-11 | Lehigh | Pennsylvania | 42077 | 3907 | 263 |
233010 | 233010 | 2020-06-12 | Lehigh | Pennsylvania | 42077 | 3926 | 264 |
236115 | 236115 | 2020-06-13 | Lehigh | Pennsylvania | 42077 | 3939 | 267 |
239223 | 239223 | 2020-06-14 | Lehigh | Pennsylvania | 42077 | 3953 | 267 |
242332 | 242332 | 2020-06-15 | Lehigh | Pennsylvania | 42077 | 3957 | 269 |
245444 | 245444 | 2020-06-16 | Lehigh | Pennsylvania | 42077 | 3973 | 271 |
248557 | 248557 | 2020-06-17 | Lehigh | Pennsylvania | 42077 | 3978 | 273 |
251672 | 251672 | 2020-06-18 | Lehigh | Pennsylvania | 42077 | 3997 | 276 |
254787 | 254787 | 2020-06-19 | Lehigh | Pennsylvania | 42077 | 4024 | 277 |
257913 | 257913 | 2020-06-20 | Lehigh | Pennsylvania | 42077 | 4072 | 278 |
261040 | 261040 | 2020-06-21 | Lehigh | Pennsylvania | 42077 | 4085 | 278 |
264168 | 264168 | 2020-06-22 | Lehigh | Pennsylvania | 42077 | 4091 | 279 |
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);