ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pasco" and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- …
state 1
- Florida · 795 ✖
fips 1
- 12101 795
county 1
- Pasco · 795 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1041 | 1041 | 2020-03-10 | Pasco | Florida | 12101 | 1 | 0 |
1211 | 1211 | 2020-03-11 | Pasco | Florida | 12101 | 1 | 0 |
1423 | 1423 | 2020-03-12 | Pasco | Florida | 12101 | 1 | 0 |
1691 | 1691 | 2020-03-13 | Pasco | Florida | 12101 | 1 | 0 |
2013 | 2013 | 2020-03-14 | Pasco | Florida | 12101 | 1 | 0 |
2397 | 2397 | 2020-03-15 | Pasco | Florida | 12101 | 2 | 0 |
2834 | 2834 | 2020-03-16 | Pasco | Florida | 12101 | 2 | 0 |
3318 | 3318 | 2020-03-17 | Pasco | Florida | 12101 | 2 | 0 |
3876 | 3876 | 2020-03-18 | Pasco | Florida | 12101 | 3 | 0 |
4545 | 4545 | 2020-03-19 | Pasco | Florida | 12101 | 5 | 0 |
5325 | 5325 | 2020-03-20 | Pasco | Florida | 12101 | 6 | 0 |
6255 | 6255 | 2020-03-21 | Pasco | Florida | 12101 | 8 | 0 |
7295 | 7295 | 2020-03-22 | Pasco | Florida | 12101 | 11 | 1 |
8441 | 8441 | 2020-03-23 | Pasco | Florida | 12101 | 14 | 1 |
9686 | 9686 | 2020-03-24 | Pasco | Florida | 12101 | 16 | 1 |
11061 | 11061 | 2020-03-25 | Pasco | Florida | 12101 | 18 | 1 |
12609 | 12609 | 2020-03-26 | Pasco | Florida | 12101 | 21 | 1 |
14279 | 14279 | 2020-03-27 | Pasco | Florida | 12101 | 25 | 1 |
16064 | 16064 | 2020-03-28 | Pasco | Florida | 12101 | 34 | 2 |
17957 | 17957 | 2020-03-29 | Pasco | Florida | 12101 | 35 | 2 |
19938 | 19938 | 2020-03-30 | Pasco | Florida | 12101 | 38 | 2 |
22016 | 22016 | 2020-03-31 | Pasco | Florida | 12101 | 40 | 2 |
24179 | 24179 | 2020-04-01 | Pasco | Florida | 12101 | 51 | 2 |
26409 | 26409 | 2020-04-02 | Pasco | Florida | 12101 | 66 | 2 |
28712 | 28712 | 2020-04-03 | Pasco | Florida | 12101 | 77 | 2 |
31072 | 31072 | 2020-04-04 | Pasco | Florida | 12101 | 90 | 2 |
33478 | 33478 | 2020-04-05 | Pasco | Florida | 12101 | 102 | 2 |
35924 | 35924 | 2020-04-06 | Pasco | Florida | 12101 | 114 | 2 |
38415 | 38415 | 2020-04-07 | Pasco | Florida | 12101 | 122 | 2 |
40959 | 40959 | 2020-04-08 | Pasco | Florida | 12101 | 127 | 2 |
43533 | 43533 | 2020-04-09 | Pasco | Florida | 12101 | 139 | 2 |
46135 | 46135 | 2020-04-10 | Pasco | Florida | 12101 | 143 | 2 |
48765 | 48765 | 2020-04-11 | Pasco | Florida | 12101 | 150 | 2 |
51426 | 51426 | 2020-04-12 | Pasco | Florida | 12101 | 160 | 3 |
54106 | 54106 | 2020-04-13 | Pasco | Florida | 12101 | 169 | 3 |
56798 | 56798 | 2020-04-14 | Pasco | Florida | 12101 | 177 | 3 |
59506 | 59506 | 2020-04-15 | Pasco | Florida | 12101 | 186 | 3 |
62225 | 62225 | 2020-04-16 | Pasco | Florida | 12101 | 190 | 3 |
64958 | 64958 | 2020-04-17 | Pasco | Florida | 12101 | 192 | 3 |
67706 | 67706 | 2020-04-18 | Pasco | Florida | 12101 | 198 | 3 |
70468 | 70468 | 2020-04-19 | Pasco | Florida | 12101 | 205 | 3 |
73237 | 73237 | 2020-04-20 | Pasco | Florida | 12101 | 209 | 3 |
76013 | 76013 | 2020-04-21 | Pasco | Florida | 12101 | 213 | 3 |
78797 | 78797 | 2020-04-22 | Pasco | Florida | 12101 | 218 | 3 |
81591 | 81591 | 2020-04-23 | Pasco | Florida | 12101 | 221 | 3 |
84391 | 84391 | 2020-04-24 | Pasco | Florida | 12101 | 230 | 4 |
87199 | 87199 | 2020-04-25 | Pasco | Florida | 12101 | 233 | 4 |
90016 | 90016 | 2020-04-26 | Pasco | Florida | 12101 | 232 | 4 |
92834 | 92834 | 2020-04-27 | Pasco | Florida | 12101 | 237 | 5 |
95666 | 95666 | 2020-04-28 | Pasco | Florida | 12101 | 239 | 6 |
98511 | 98511 | 2020-04-29 | Pasco | Florida | 12101 | 241 | 6 |
101361 | 101361 | 2020-04-30 | Pasco | Florida | 12101 | 249 | 7 |
104216 | 104216 | 2020-05-01 | Pasco | Florida | 12101 | 252 | 8 |
107081 | 107081 | 2020-05-02 | Pasco | Florida | 12101 | 275 | 8 |
109950 | 109950 | 2020-05-03 | Pasco | Florida | 12101 | 278 | 8 |
112825 | 112825 | 2020-05-04 | Pasco | Florida | 12101 | 282 | 8 |
115708 | 115708 | 2020-05-05 | Pasco | Florida | 12101 | 284 | 8 |
118668 | 118668 | 2020-05-06 | Pasco | Florida | 12101 | 285 | 8 |
121637 | 121637 | 2020-05-07 | Pasco | Florida | 12101 | 289 | 9 |
124616 | 124616 | 2020-05-08 | Pasco | Florida | 12101 | 291 | 9 |
127603 | 127603 | 2020-05-09 | Pasco | Florida | 12101 | 293 | 9 |
130594 | 130594 | 2020-05-10 | Pasco | Florida | 12101 | 297 | 9 |
133585 | 133585 | 2020-05-11 | Pasco | Florida | 12101 | 300 | 9 |
136574 | 136574 | 2020-05-12 | Pasco | Florida | 12101 | 302 | 9 |
139565 | 139565 | 2020-05-13 | Pasco | Florida | 12101 | 306 | 9 |
142561 | 142561 | 2020-05-14 | Pasco | Florida | 12101 | 308 | 9 |
145561 | 145561 | 2020-05-15 | Pasco | Florida | 12101 | 313 | 9 |
148564 | 148564 | 2020-05-16 | Pasco | Florida | 12101 | 314 | 9 |
151573 | 151573 | 2020-05-17 | Pasco | Florida | 12101 | 316 | 9 |
154585 | 154585 | 2020-05-18 | Pasco | Florida | 12101 | 319 | 9 |
157601 | 157601 | 2020-05-19 | Pasco | Florida | 12101 | 327 | 12 |
160627 | 160627 | 2020-05-20 | Pasco | Florida | 12101 | 328 | 12 |
163655 | 163655 | 2020-05-21 | Pasco | Florida | 12101 | 335 | 12 |
166688 | 166688 | 2020-05-22 | Pasco | Florida | 12101 | 338 | 12 |
169725 | 169725 | 2020-05-23 | Pasco | Florida | 12101 | 341 | 12 |
172766 | 172766 | 2020-05-24 | Pasco | Florida | 12101 | 349 | 12 |
175809 | 175809 | 2020-05-25 | Pasco | Florida | 12101 | 360 | 12 |
178853 | 178853 | 2020-05-26 | Pasco | Florida | 12101 | 369 | 13 |
181897 | 181897 | 2020-05-27 | Pasco | Florida | 12101 | 373 | 12 |
184951 | 184951 | 2020-05-28 | Pasco | Florida | 12101 | 375 | 13 |
188007 | 188007 | 2020-05-29 | Pasco | Florida | 12101 | 377 | 13 |
191072 | 191072 | 2020-05-30 | Pasco | Florida | 12101 | 381 | 13 |
194139 | 194139 | 2020-05-31 | Pasco | Florida | 12101 | 386 | 13 |
197209 | 197209 | 2020-06-01 | Pasco | Florida | 12101 | 388 | 13 |
200282 | 200282 | 2020-06-02 | Pasco | Florida | 12101 | 394 | 15 |
203358 | 203358 | 2020-06-03 | Pasco | Florida | 12101 | 398 | 15 |
206438 | 206438 | 2020-06-04 | Pasco | Florida | 12101 | 405 | 15 |
209519 | 209519 | 2020-06-05 | Pasco | Florida | 12101 | 416 | 15 |
212604 | 212604 | 2020-06-06 | Pasco | Florida | 12101 | 419 | 15 |
215691 | 215691 | 2020-06-07 | Pasco | Florida | 12101 | 424 | 15 |
218782 | 218782 | 2020-06-08 | Pasco | Florida | 12101 | 434 | 15 |
221877 | 221877 | 2020-06-09 | Pasco | Florida | 12101 | 442 | 15 |
224972 | 224972 | 2020-06-10 | Pasco | Florida | 12101 | 457 | 15 |
228074 | 228074 | 2020-06-11 | Pasco | Florida | 12101 | 473 | 15 |
231177 | 231177 | 2020-06-12 | Pasco | Florida | 12101 | 484 | 15 |
234283 | 234283 | 2020-06-13 | Pasco | Florida | 12101 | 500 | 15 |
237390 | 237390 | 2020-06-14 | Pasco | Florida | 12101 | 521 | 15 |
240498 | 240498 | 2020-06-15 | Pasco | Florida | 12101 | 543 | 15 |
243609 | 243609 | 2020-06-16 | Pasco | Florida | 12101 | 560 | 16 |
246722 | 246722 | 2020-06-17 | Pasco | Florida | 12101 | 583 | 16 |
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);