ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 12069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 474 ✖
- 84293 14
- 84610 14
- 84961 14
- 85479 14
- 55176 11
- 86320 8
- 30604 7
- 30765 7
- 30911 7
- 31095 7
- 31360 7
- 31795 7
- 32523 7
- 33688 7
- 35650 7
- 37761 7
- 40252 7
- 42712 7
- 45262 7
- 47510 7
- 49249 7
- 50713 7
- 51932 7
- 52933 7
- 53476 7
- 53868 7
- 54129 7
- 54454 7
- 54697 7
- 54930 7
- 55508 7
- 55746 7
- 56032 7
- 56730 7
- 59574 7
- 63681 7
- 70093 7
- 74451 7
- 78050 7
- 80535 7
- 82492 7
- 83315 7
- 83878 7
- 84142 7
- 30960 4
- 55332 3
- 1 2
- 3 2
- 6 2
- 150 2
- 213 2
- 227 2
- 234 2
- 235 2
- 237 2
- 7862 2
- 10273 2
- 14280 2
- 15559 2
- 2 1
- 9 1
- 14 1
- 22 1
- 26 1
- 32 1
- 38 1
- 44 1
- 50 1
- 66 1
- 71 1
- 82 1
- 88 1
- 95 1
- 101 1
- 107 1
- 122 1
- 139 1
- 140 1
- 149 1
- 162 1
- 169 1
- 180 1
- 186 1
- 197 1
- 203 1
- 207 1
- 211 1
- 217 1
- 219 1
- 221 1
- 222 1
- 223 1
- 226 1
- 233 1
- 236 1
- 240 1
- 242 1
- 243 1
- 246 1
- 247 1
- 248 1
- 249 1
- 250 1
- 252 1
- 254 1
- 257 1
- 260 1
- 264 1
- 266 1
- 271 1
- 273 1
- 275 1
- 277 1
- 279 1
- 280 1
- 291 1
- 298 1
- 301 1
- 304 1
- 306 1
- 309 1
- 313 1
- 317 1
- 321 1
- 329 1
- 337 1
- 339 1
- 342 1
- 355 1
- 383 1
- 452 1
- 464 1
- 482 1
- 498 1
- 552 1
- 583 1
- 646 1
- 671 1
- 733 1
- 763 1
- 795 1
- 838 1
- 881 1
- 975 1
- 1098 1
- 1192 1
- 1252 1
- 1302 1
- 1410 1
- 1508 1
- 1603 1
- 1694 1
- 1845 1
- 1890 1
- 1998 1
- 2087 1
- 2181 1
- 2298 1
- 2394 1
- 2517 1
- 2645 1
- 2783 1
- 2882 1
- 3009 1
- 3139 1
- 3206 1
- 3343 1
- 3391 1
- 3473 1
- 3594 1
- 3757 1
- 3890 1
- 3988 1
- 4090 1
- 4169 1
- 4259 1
- 4326 1
- 4408 1
- 4516 1
- 4612 1
- 4661 1
- 4708 1
- 4769 1
- 4794 1
- 4840 1
- 4958 1
- 5073 1
- 5161 1
- 5177 1
- 5229 1
- 5291 1
- 5391 1
- 5489 1
- 5587 1
- 5619 1
- 5650 1
- 5698 1
- 5756 1
- 5852 1
- 5947 1
- 6004 1
- 6046 1
- 6089 1
- 6122 1
- 6163 1
- 6213 1
- 6275 1
- 6345 1
- 6385 1
- 6396 1
- 6538 1
- 6581 1
- 6622 1
- 6683 1
- 6754 1
- 6787 1
- 6824 1
- 6841 1
- 6871 1
- 6921 1
- 6972 1
- 7021 1
- 7046 1
- 7063 1
- 7092 1
- 7137 1
- 7173 1
- 7220 1
- 7262 1
- 7293 1
- 7313 1
- 7339 1
- 7365 1
- 7394 1
- 7420 1
- 7444 1
- 7466 1
- 7475 1
- 7517 1
- 7542 1
- 7567 1
- 7606 1
- 7650 1
- 7693 1
- 7712 1
- 7729 1
- 7770 1
- 7818 1
- 7917 1
- 7939 1
- 7973 1
- 8012 1
- 8047 1
- 8083 1
- 8130 1
- 8168 1
- 8195 1
- 8240 1
- 8266 1
- 8336 1
- 8387 1
- 8415 1
- 8445 1
- 8479 1
- 8520 1
- 8580 1
- 8613 1
- 8662 1
- 8680 1
- 8729 1
- 8785 1
- 8851 1
- 8947 1
- 9047 1
- 9103 1
- 9132 1
- 9195 1
- 9246 1
- 9312 1
- 9360 1
- 9424 1
- 9466 1
- 9527 1
- 9623 1
- 9665 1
- 9721 1
- 9815 1
- 9872 1
- 9946 1
- 10012 1
- 10084 1
- 10151 1
- 10208 1
- 10472 1
- 10531 1
- 10623 1
- 10671 1
- 10743 1
- 10809 1
- 10899 1
- 10982 1
- 11091 1
- 11183 1
- 11301 1
- 11524 1
- 11638 1
- 11798 1
- 11985 1
- 12136 1
- 12291 1
- 12435 1
- 12571 1
- 12727 1
- 12966 1
- 13157 1
- 13341 1
- 13492 1
- 13698 1
- 13863 1
- 14062 1
- 14627 1
- 14723 1
- 14841 1
- 14998 1
- 15201 1
- 16106 1
- 16261 1
- 16483 1
- 16697 1
- 16897 1
- 17228 1
- 17489 1
- 17742 1
- 17973 1
- 18142 1
- 18333 1
- 18537 1
- 18753 1
- 18962 1
- 19208 1
- 19387 1
- 19547 1
- 19713 1
- 19897 1
- 20128 1
- 20296 1
- 20470 1
- 20664 1
- 20797 1
- 20972 1
- 21131 1
- 21343 1
- 21511 1
- 21697 1
- 21824 1
- 21864 1
- 22058 1
- 22180 1
- 22311 1
- 22500 1
- 22618 1
- 22728 1
- 22800 1
- 22933 1
- 22989 1
- 23099 1
- 23215 1
- 23346 1
- 23442 1
- 23498 1
- 23587 1
- 23655 1
- 23728 1
- 23786 1
- 23903 1
- 23978 1
- 24030 1
- 24110 1
- 24228 1
- 24342 1
- 24445 1
- 24538 1
- 24611 1
- 24635 1
- 24744 1
- 24841 1
- 24928 1
- 25010 1
- 25083 1
- 25156 1
- 25192 1
- 25252 1
- 25312 1
- 25378 1
- 25444 1
- 25529 1
- 25591 1
- 25627 1
- 25678 1
- 25754 1
- 25831 1
- 25895 1
- 25943 1
- 25978 1
- 26009 1
- 26092 1
- 26199 1
- 26298 1
- 26354 1
- 26418 1
- 26470 1
- 26507 1
- 26604 1
- 26679 1
- 26776 1
- 26862 1
- 26924 1
- 26983 1
- 27028 1
- 27081 1
- 27173 1
- 27321 1
- 27447 1
- 27557 1
- 27632 1
- 27654 1
- 27771 1
- 27913 1
- 28022 1
- 28118 1
- 28213 1
- 28317 1
- 28379 1
- 28465 1
- 28542 1
- 28645 1
- 28721 1
- 28814 1
- 28892 1
- 28949 1
- 29027 1
- 29140 1
- 29228 1
- 29290 1
- 29369 1
- 29429 1
- 29468 1
- 29526 1
- 29593 1
- 29661 1
- 29736 1
- 29808 1
- 29856 1
- 29885 1
- 29932 1
- 29977 1
- 30075 1
- 30180 1
- 30241 1
- 30298 1
- 30338 1
- 30402 1
- 30468 1
- 30535 1
- 30622 1
- 30676 1
- 30726 1
- 30759 1
- 30848 1
- 30893 1
- 30924 1
- 31065 1
- 31099 1
- 31113 1
state 1
- Florida 789
fips 1
- 12069 · 789 ✖
county 1
- Lake 789
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499931 | 2499931 | 2022-05-13 | Lake | Florida | 12069 | 86320 | 1501 |
2496673 | 2496673 | 2022-05-12 | Lake | Florida | 12069 | 86320 | 1501 |
2493415 | 2493415 | 2022-05-11 | Lake | Florida | 12069 | 86320 | 1501 |
2490157 | 2490157 | 2022-05-10 | Lake | Florida | 12069 | 86320 | 1503 |
2486900 | 2486900 | 2022-05-09 | Lake | Florida | 12069 | 86320 | 1503 |
2483642 | 2483642 | 2022-05-08 | Lake | Florida | 12069 | 86320 | 1503 |
2480384 | 2480384 | 2022-05-07 | Lake | Florida | 12069 | 86320 | 1503 |
2477126 | 2477126 | 2022-05-06 | Lake | Florida | 12069 | 86320 | 1503 |
2473868 | 2473868 | 2022-05-05 | Lake | Florida | 12069 | 85479 | 1503 |
2470611 | 2470611 | 2022-05-04 | Lake | Florida | 12069 | 85479 | 1503 |
2467355 | 2467355 | 2022-05-03 | Lake | Florida | 12069 | 85479 | 1504 |
2464100 | 2464100 | 2022-05-02 | Lake | Florida | 12069 | 85479 | 1504 |
2460844 | 2460844 | 2022-05-01 | Lake | Florida | 12069 | 85479 | 1504 |
2457588 | 2457588 | 2022-04-30 | Lake | Florida | 12069 | 85479 | 1504 |
2454332 | 2454332 | 2022-04-29 | Lake | Florida | 12069 | 85479 | 1504 |
2451076 | 2451076 | 2022-04-28 | Lake | Florida | 12069 | 85479 | 1504 |
2447820 | 2447820 | 2022-04-27 | Lake | Florida | 12069 | 85479 | 1504 |
2444564 | 2444564 | 2022-04-26 | Lake | Florida | 12069 | 85479 | 1501 |
2441308 | 2441308 | 2022-04-25 | Lake | Florida | 12069 | 85479 | 1501 |
2438052 | 2438052 | 2022-04-24 | Lake | Florida | 12069 | 85479 | 1501 |
2434796 | 2434796 | 2022-04-23 | Lake | Florida | 12069 | 85479 | 1501 |
2431540 | 2431540 | 2022-04-22 | Lake | Florida | 12069 | 85479 | 1501 |
2428284 | 2428284 | 2022-04-21 | Lake | Florida | 12069 | 84961 | 1501 |
2425028 | 2425028 | 2022-04-20 | Lake | Florida | 12069 | 84961 | 1501 |
2421772 | 2421772 | 2022-04-19 | Lake | Florida | 12069 | 84961 | 1496 |
2418516 | 2418516 | 2022-04-18 | Lake | Florida | 12069 | 84961 | 1496 |
2415260 | 2415260 | 2022-04-17 | Lake | Florida | 12069 | 84961 | 1496 |
2412004 | 2412004 | 2022-04-16 | Lake | Florida | 12069 | 84961 | 1496 |
2408748 | 2408748 | 2022-04-15 | Lake | Florida | 12069 | 84961 | 1496 |
2405492 | 2405492 | 2022-04-14 | Lake | Florida | 12069 | 84961 | 1496 |
2402237 | 2402237 | 2022-04-13 | Lake | Florida | 12069 | 84961 | 1496 |
2398982 | 2398982 | 2022-04-12 | Lake | Florida | 12069 | 84961 | 1502 |
2395727 | 2395727 | 2022-04-11 | Lake | Florida | 12069 | 84961 | 1502 |
2392471 | 2392471 | 2022-04-10 | Lake | Florida | 12069 | 84961 | 1502 |
2389215 | 2389215 | 2022-04-09 | Lake | Florida | 12069 | 84961 | 1502 |
2385960 | 2385960 | 2022-04-08 | Lake | Florida | 12069 | 84961 | 1502 |
2382705 | 2382705 | 2022-04-07 | Lake | Florida | 12069 | 84610 | 1502 |
2379450 | 2379450 | 2022-04-06 | Lake | Florida | 12069 | 84610 | 1502 |
2376196 | 2376196 | 2022-04-05 | Lake | Florida | 12069 | 84610 | 1499 |
2372944 | 2372944 | 2022-04-04 | Lake | Florida | 12069 | 84610 | 1499 |
2369691 | 2369691 | 2022-04-03 | Lake | Florida | 12069 | 84610 | 1499 |
2366438 | 2366438 | 2022-04-02 | Lake | Florida | 12069 | 84610 | 1499 |
2363185 | 2363185 | 2022-04-01 | Lake | Florida | 12069 | 84610 | 1499 |
2359931 | 2359931 | 2022-03-31 | Lake | Florida | 12069 | 84610 | 1499 |
2356677 | 2356677 | 2022-03-30 | Lake | Florida | 12069 | 84610 | 1499 |
2353424 | 2353424 | 2022-03-29 | Lake | Florida | 12069 | 84610 | 1492 |
2350172 | 2350172 | 2022-03-28 | Lake | Florida | 12069 | 84610 | 1492 |
2346919 | 2346919 | 2022-03-27 | Lake | Florida | 12069 | 84610 | 1492 |
2343666 | 2343666 | 2022-03-26 | Lake | Florida | 12069 | 84610 | 1492 |
2340413 | 2340413 | 2022-03-25 | Lake | Florida | 12069 | 84610 | 1492 |
2337160 | 2337160 | 2022-03-24 | Lake | Florida | 12069 | 84293 | 1492 |
2333906 | 2333906 | 2022-03-23 | Lake | Florida | 12069 | 84293 | 1479 |
2330652 | 2330652 | 2022-03-22 | Lake | Florida | 12069 | 84293 | 1479 |
2327400 | 2327400 | 2022-03-21 | Lake | Florida | 12069 | 84293 | 1479 |
2324147 | 2324147 | 2022-03-20 | Lake | Florida | 12069 | 84293 | 1479 |
2320893 | 2320893 | 2022-03-19 | Lake | Florida | 12069 | 84293 | 1479 |
2317639 | 2317639 | 2022-03-18 | Lake | Florida | 12069 | 84293 | 1479 |
2314386 | 2314386 | 2022-03-17 | Lake | Florida | 12069 | 84293 | 1479 |
2311133 | 2311133 | 2022-03-16 | Lake | Florida | 12069 | 84293 | 1479 |
2307880 | 2307880 | 2022-03-15 | Lake | Florida | 12069 | 84293 | 1461 |
2304629 | 2304629 | 2022-03-14 | Lake | Florida | 12069 | 84293 | 1461 |
2301377 | 2301377 | 2022-03-13 | Lake | Florida | 12069 | 84293 | 1461 |
2298125 | 2298125 | 2022-03-12 | Lake | Florida | 12069 | 84293 | 1461 |
2294873 | 2294873 | 2022-03-11 | Lake | Florida | 12069 | 84293 | 1461 |
2291621 | 2291621 | 2022-03-10 | Lake | Florida | 12069 | 84142 | 1461 |
2288369 | 2288369 | 2022-03-09 | Lake | Florida | 12069 | 84142 | 1461 |
2285118 | 2285118 | 2022-03-08 | Lake | Florida | 12069 | 84142 | 1431 |
2281866 | 2281866 | 2022-03-07 | Lake | Florida | 12069 | 84142 | 1431 |
2278613 | 2278613 | 2022-03-06 | Lake | Florida | 12069 | 84142 | 1431 |
2275360 | 2275360 | 2022-03-05 | Lake | Florida | 12069 | 84142 | 1431 |
2272107 | 2272107 | 2022-03-04 | Lake | Florida | 12069 | 84142 | 1431 |
2268855 | 2268855 | 2022-03-03 | Lake | Florida | 12069 | 83878 | 1431 |
2265602 | 2265602 | 2022-03-02 | Lake | Florida | 12069 | 83878 | 1431 |
2262351 | 2262351 | 2022-03-01 | Lake | Florida | 12069 | 83878 | 1421 |
2259100 | 2259100 | 2022-02-28 | Lake | Florida | 12069 | 83878 | 1421 |
2255849 | 2255849 | 2022-02-27 | Lake | Florida | 12069 | 83878 | 1421 |
2252598 | 2252598 | 2022-02-26 | Lake | Florida | 12069 | 83878 | 1421 |
2249347 | 2249347 | 2022-02-25 | Lake | Florida | 12069 | 83878 | 1421 |
2246096 | 2246096 | 2022-02-24 | Lake | Florida | 12069 | 83315 | 1421 |
2242845 | 2242845 | 2022-02-23 | Lake | Florida | 12069 | 83315 | 1421 |
2239594 | 2239594 | 2022-02-22 | Lake | Florida | 12069 | 83315 | 1386 |
2236343 | 2236343 | 2022-02-21 | Lake | Florida | 12069 | 83315 | 1386 |
2233092 | 2233092 | 2022-02-20 | Lake | Florida | 12069 | 83315 | 1386 |
2229841 | 2229841 | 2022-02-19 | Lake | Florida | 12069 | 83315 | 1386 |
2226590 | 2226590 | 2022-02-18 | Lake | Florida | 12069 | 83315 | 1386 |
2223339 | 2223339 | 2022-02-17 | Lake | Florida | 12069 | 82492 | 1386 |
2220088 | 2220088 | 2022-02-16 | Lake | Florida | 12069 | 82492 | 1386 |
2216837 | 2216837 | 2022-02-15 | Lake | Florida | 12069 | 82492 | 1347 |
2213586 | 2213586 | 2022-02-14 | Lake | Florida | 12069 | 82492 | 1347 |
2210334 | 2210334 | 2022-02-13 | Lake | Florida | 12069 | 82492 | 1347 |
2207081 | 2207081 | 2022-02-12 | Lake | Florida | 12069 | 82492 | 1347 |
2203828 | 2203828 | 2022-02-11 | Lake | Florida | 12069 | 82492 | 1347 |
2200575 | 2200575 | 2022-02-10 | Lake | Florida | 12069 | 80535 | 1347 |
2197321 | 2197321 | 2022-02-09 | Lake | Florida | 12069 | 80535 | 1347 |
2194067 | 2194067 | 2022-02-08 | Lake | Florida | 12069 | 80535 | 1301 |
2190813 | 2190813 | 2022-02-07 | Lake | Florida | 12069 | 80535 | 1301 |
2187560 | 2187560 | 2022-02-06 | Lake | Florida | 12069 | 80535 | 1301 |
2184307 | 2184307 | 2022-02-05 | Lake | Florida | 12069 | 80535 | 1301 |
2181055 | 2181055 | 2022-02-04 | Lake | Florida | 12069 | 80535 | 1301 |
2177804 | 2177804 | 2022-02-03 | Lake | Florida | 12069 | 78050 | 1301 |
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);