ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pasco" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 483 ✖
- 121462 14
- 121807 14
- 122195 14
- 122821 14
- 79767 11
- 123993 8
- 42625 7
- 42903 7
- 43061 7
- 43160 7
- 43428 7
- 43825 7
- 44705 7
- 46341 7
- 49233 7
- 52639 7
- 56511 7
- 60753 7
- 65142 7
- 68963 7
- 72254 7
- 74913 7
- 76559 7
- 77645 7
- 78245 7
- 78642 7
- 78907 7
- 79142 7
- 79364 7
- 79553 7
- 80176 7
- 80464 7
- 80859 7
- 81832 7
- 85229 7
- 91476 7
- 99718 7
- 106816 7
- 112390 7
- 116068 7
- 119010 7
- 120110 7
- 120768 7
- 121183 7
- 1 5
- 42754 4
- 2 3
- 79942 3
- 9720 2
- 14131 2
- 20474 2
- 21932 2
- 3 1
- 5 1
- 6 1
- 8 1
- 11 1
- 14 1
- 16 1
- 18 1
- 21 1
- 25 1
- 34 1
- 35 1
- 38 1
- 40 1
- 51 1
- 66 1
- 77 1
- 90 1
- 102 1
- 114 1
- 122 1
- 127 1
- 139 1
- 143 1
- 150 1
- 160 1
- 169 1
- 177 1
- 186 1
- 190 1
- 192 1
- 198 1
- 205 1
- 209 1
- 213 1
- 218 1
- 221 1
- 230 1
- 232 1
- 233 1
- 237 1
- 239 1
- 241 1
- 249 1
- 252 1
- 275 1
- 278 1
- 282 1
- 284 1
- 285 1
- 289 1
- 291 1
- 293 1
- 297 1
- 300 1
- 302 1
- 306 1
- 308 1
- 313 1
- 314 1
- 316 1
- 319 1
- 327 1
- 328 1
- 335 1
- 338 1
- 341 1
- 349 1
- 360 1
- 369 1
- 373 1
- 375 1
- 377 1
- 381 1
- 386 1
- 388 1
- 394 1
- 398 1
- 405 1
- 416 1
- 419 1
- 424 1
- 434 1
- 442 1
- 457 1
- 473 1
- 484 1
- 500 1
- 521 1
- 543 1
- 560 1
- 583 1
- 627 1
- 686 1
- 750 1
- 809 1
- 872 1
- 954 1
- 1084 1
- 1170 1
- 1326 1
- 1630 1
- 1780 1
- 1909 1
- 1992 1
- 2133 1
- 2274 1
- 2443 1
- 2608 1
- 2757 1
- 2850 1
- 3004 1
- 3193 1
- 3330 1
- 3559 1
- 3748 1
- 3875 1
- 4060 1
- 4189 1
- 4363 1
- 4489 1
- 4654 1
- 4769 1
- 4943 1
- 5050 1
- 5161 1
- 5260 1
- 5363 1
- 5526 1
- 5674 1
- 5803 1
- 5911 1
- 5992 1
- 6101 1
- 6201 1
- 6299 1
- 6394 1
- 6479 1
- 6548 1
- 6636 1
- 6708 1
- 6802 1
- 6893 1
- 6982 1
- 7080 1
- 7114 1
- 7172 1
- 7213 1
- 7283 1
- 7348 1
- 7406 1
- 7453 1
- 7490 1
- 7527 1
- 7560 1
- 7608 1
- 7651 1
- 7693 1
- 7758 1
- 7777 1
- 7807 1
- 7868 1
- 7915 1
- 7949 1
- 7989 1
- 8028 1
- 8048 1
- 8135 1
- 8165 1
- 8198 1
- 8230 1
- 8267 1
- 8316 1
- 8338 1
- 8357 1
- 8381 1
- 8411 1
- 8464 1
- 8507 1
- 8527 1
- 8551 1
- 8600 1
- 8640 1
- 8680 1
- 8729 1
- 8816 1
- 8865 1
- 8893 1
- 8934 1
- 8988 1
- 9040 1
- 9101 1
- 9162 1
- 9204 1
- 9233 1
- 9279 1
- 9322 1
- 9371 1
- 9411 1
- 9444 1
- 9476 1
- 9499 1
- 9538 1
- 9569 1
- 9652 1
- 9831 1
- 9871 1
- 9919 1
- 9989 1
- 10054 1
- 10089 1
- 10169 1
- 10216 1
- 10238 1
- 10294 1
- 10316 1
- 10406 1
- 10465 1
- 10539 1
- 10600 1
- 10637 1
- 10717 1
- 10781 1
- 10826 1
- 10923 1
- 10972 1
- 11063 1
- 11147 1
- 11242 1
- 11328 1
- 11445 1
- 11558 1
- 11671 1
- 11788 1
- 11863 1
- 11969 1
- 12088 1
- 12199 1
- 12319 1
- 12403 1
- 12547 1
- 12666 1
- 12771 1
- 12968 1
- 13156 1
- 13373 1
- 13532 1
- 13679 1
- 13809 1
- 13982 1
- 14488 1
- 14619 1
- 14783 1
- 14899 1
- 15041 1
- 15248 1
- 15480 1
- 15700 1
- 15948 1
- 16153 1
- 16338 1
- 16543 1
- 16716 1
- 16988 1
- 17315 1
- 17578 1
- 17810 1
- 17975 1
- 18190 1
- 18385 1
- 18733 1
- 19017 1
- 19291 1
- 19496 1
- 19787 1
- 19969 1
- 20164 1
- 20919 1
- 21036 1
- 21222 1
- 21370 1
- 21602 1
- 22634 1
- 22879 1
- 23082 1
- 23258 1
- 23606 1
- 23948 1
- 24363 1
- 24663 1
- 24942 1
- 25224 1
- 25483 1
- 25785 1
- 26053 1
- 26344 1
- 26584 1
- 26798 1
- 27006 1
- 27190 1
- 27367 1
- 27610 1
- 27865 1
- 28076 1
- 28299 1
- 28466 1
- 28624 1
- 28795 1
- 29020 1
- 29171 1
- 29432 1
- 29608 1
- 29693 1
- 29917 1
- 30049 1
- 30214 1
- 30396 1
- 30536 1
- 30641 1
- 30749 1
- 30883 1
- 31007 1
- 31188 1
- 31371 1
- 31508 1
- 31631 1
- 31744 1
- 31872 1
- 32036 1
- 32152 1
- 32289 1
- 32440 1
- 32581 1
- 32662 1
- 32754 1
- 32900 1
- 33035 1
- 33139 1
- 33265 1
- 33377 1
- 33426 1
- 33551 1
- 33658 1
- 33778 1
- 33888 1
- 33975 1
- 34054 1
- 34098 1
- 34178 1
- 34271 1
- 34391 1
- 34495 1
- 34631 1
- 34720 1
- 34778 1
- 34868 1
- 34961 1
- 35039 1
- 35136 1
- 35248 1
- 35336 1
- 35373 1
- 35492 1
- 35583 1
- 35730 1
- 35863 1
- 35990 1
- 36074 1
- 36147 1
- 36265 1
- 36391 1
- 36511 1
- 36645 1
- 36787 1
- 36906 1
- 37013 1
- 37136 1
- 37272 1
- 37424 1
- 37618 1
- 37783 1
- 37924 1
- 37975 1
- 38199 1
- 38387 1
- 38522 1
- 38721 1
- 38883 1
- 39036 1
- 39145 1
- 39315 1
- 39466 1
- 39628 1
- 39805 1
- 39990 1
- 40085 1
- 40168 1
- 40308 1
- 40434 1
- 40556 1
- 40692 1
- 40808 1
- 40895 1
- 40984 1
- 41088 1
- 41197 1
- 41342 1
- 41431 1
- 41555 1
- 41638 1
- 41687 1
- 41776 1
- 41854 1
- 41921 1
- 41998 1
- 42063 1
- 42109 1
- 42158 1
- 42203 1
- 42268 1
- 42329 1
- 42391 1
- 42452 1
- 42506 1
- 42542 1
- 42594 1
- 42645 1
- 42709 1
- 42888 1
- 42914 1
- 42933 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);