ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6039 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 594 ✖
- 1 12
- 43445 10
- 43525 7
- 33 6
- 5094 6
- 43423 6
- 30 5
- 26005 5
- 3 4
- 3953 4
- 4458 4
- 4748 4
- 16696 4
- 23955 4
- 27054 4
- 27347 4
- 42339 4
- 43400 4
- 43490 4
- 28 3
- 36 3
- 46 3
- 67 3
- 69 3
- 578 3
- 2302 3
- 3339 3
- 3674 3
- 4150 3
- 4296 3
- 4642 3
- 4706 3
- 4836 3
- 4981 3
- 5249 3
- 5426 3
- 5714 3
- 6047 3
- 17723 3
- 17783 3
- 17885 3
- 18086 3
- 22042 3
- 22597 3
- 23058 3
- 23518 3
- 24479 3
- 25022 3
- 25845 3
- 26388 3
- 26666 3
- 26851 3
- 28215 3
- 30136 3
- 33030 3
- 37110 3
- 39854 3
- 41353 3
- 42857 3
- 43075 3
- 43238 3
- 43293 3
- 43360 3
- 43416 3
- 43436 3
- 43585 3
- 6 2
- 7 2
- 23 2
- 32 2
- 34 2
- 39 2
- 51 2
- 54 2
- 71 2
- 82 2
- 84 2
- 104 2
- 163 2
- 198 2
- 314 2
- 415 2
- 857 2
- 2463 2
- 2924 2
- 3551 2
- 4424 2
- 4557 2
- 5330 2
- 6537 2
- 16680 2
- 18362 2
- 25400 2
- 25546 2
- 11 1
- 15 1
- 18 1
- 21 1
- 40 1
- 41 1
- 44 1
- 45 1
- 55 1
- 62 1
- 66 1
- 70 1
- 78 1
- 81 1
- 83 1
- 85 1
- 90 1
- 94 1
- 98 1
- 106 1
- 114 1
- 117 1
- 129 1
- 141 1
- 155 1
- 172 1
- 174 1
- 178 1
- 188 1
- 203 1
- 226 1
- 250 1
- 275 1
- 295 1
- 321 1
- 334 1
- 359 1
- 370 1
- 383 1
- 427 1
- 488 1
- 519 1
- 541 1
- 566 1
- 713 1
- 784 1
- 893 1
- 914 1
- 988 1
- 1025 1
- 1059 1
- 1118 1
- 1147 1
- 1192 1
- 1214 1
- 1260 1
- 1439 1
- 1451 1
- 1530 1
- 1599 1
- 1659 1
- 1679 1
- 1724 1
- 1744 1
- 1841 1
- 1889 1
- 1941 1
- 2007 1
- 2036 1
- 2103 1
- 2123 1
- 2143 1
- 2161 1
- 2267 1
- 2759 1
- 2853 1
- 2950 1
- 3129 1
- 3196 1
- 3236 1
- 3278 1
- 3484 1
- 3509 1
- 3783 1
- 3836 1
- 3876 1
- 3889 1
- 4025 1
- 4064 1
- 4079 1
- 4226 1
- 4230 1
- 4267 1
- 4270 1
- 4391 1
- 4539 1
- 4614 1
- 4739 1
- 4796 1
- 4808 1
- 4822 1
- 4886 1
- 4920 1
- 4928 1
- 4945 1
- 5020 1
- 5037 1
- 5057 1
- 5066 1
- 5219 1
- 5306 1
- 5361 1
- 5514 1
- 5561 1
- 5602 1
- 5624 1
- 5885 1
- 5938 1
- 6050 1
- 6119 1
- 6290 1
- 6346 1
- 6427 1
- 6482 1
- 6619 1
- 6940 1
- 7115 1
- 7251 1
- 7468 1
- 7612 1
- 7648 1
- 7765 1
- 8019 1
- 8120 1
- 8269 1
- 8441 1
- 8574 1
- 8609 1
- 8717 1
- 8995 1
- 9150 1
- 9305 1
- 9371 1
- 9547 1
- 9770 1
- 9908 1
- 10015 1
- 10172 1
- 10273 1
- 10491 1
- 10609 1
- 10752 1
- 11039 1
- 11151 1
- 11280 1
- 11359 1
- 11532 1
- 11645 1
- 11846 1
- 12063 1
- 12270 1
- 12389 1
- 12485 1
- 12570 1
- 12778 1
- 12883 1
- 13193 1
- 13328 1
- 13443 1
- 13528 1
- 13585 1
- 13664 1
- 13781 1
- 13858 1
- 14000 1
- 14068 1
- 14130 1
- 14194 1
- 14301 1
- 14377 1
- 14443 1
- 14496 1
- 14572 1
- 14595 1
- 14605 1
- 14706 1
- 14752 1
- 14807 1
- 14850 1
- 14887 1
- 14912 1
- 14925 1
- 14984 1
- 15022 1
- 15053 1
- 15089 1
- 15108 1
- 15120 1
- 15135 1
- 15175 1
- 15222 1
- 15274 1
- 15298 1
- 15325 1
- 15352 1
- 15390 1
- 15414 1
- 15436 1
- 15467 1
- 15496 1
- 15505 1
- 15523 1
- 15553 1
- 15596 1
- 15624 1
- 15646 1
- 15675 1
- 15691 1
- 15701 1
- 15705 1
- 15725 1
- 15761 1
- 15780 1
- 15804 1
- 15806 1
- 15822 1
- 15835 1
- 15860 1
- 15877 1
- 15891 1
- 15895 1
- 15904 1
- 15908 1
- 15918 1
- 15937 1
- 15952 1
- 15968 1
- 15973 1
- 15987 1
- 16003 1
- 16015 1
- 16023 1
- 16036 1
- 16051 1
- 16052 1
- 16065 1
- 16085 1
- 16090 1
- 16103 1
- 16118 1
- 16143 1
- 16166 1
- 16174 1
- 16207 1
- 16218 1
- 16234 1
- 16250 1
- 16260 1
- 16277 1
- 16289 1
- 16301 1
- 16309 1
- 16316 1
- 16328 1
- 16338 1
- 16346 1
- 16353 1
- 16365 1
- 16372 1
- 16383 1
- 16395 1
- 16408 1
- 16410 1
- 16414 1
- 16418 1
- 16423 1
- 16430 1
- 16439 1
- 16442 1
- 16444 1
- 16450 1
- 16459 1
- 16462 1
- 16467 1
- 16474 1
- 16482 1
- 16483 1
- 16486 1
- 16491 1
- 16496 1
- 16499 1
- 16500 1
- 16503 1
- 16504 1
- 16513 1
- 16519 1
- 16520 1
- 16527 1
- 16530 1
- 16535 1
- 16538 1
- 16543 1
- 16549 1
- 16550 1
- 16554 1
- 16557 1
- 16563 1
- 16567 1
- 16572 1
- 16579 1
- 16580 1
- 16581 1
- 16582 1
- 16586 1
- 16590 1
- 16597 1
- 16600 1
- 16603 1
- 16618 1
- 16625 1
- 16632 1
- 16638 1
- 16647 1
- 16652 1
- 16660 1
- 16662 1
- 16670 1
- 16679 1
- 16683 1
- 16688 1
- 16722 1
- 16730 1
- 17712 1
- 17745 1
- 17751 1
- 17752 1
- 17765 1
- 17817 1
- 17825 1
- 17835 1
- 17858 1
- 17947 1
- 17971 1
- 17998 1
- 18052 1
- 18174 1
- 18186 1
- 18248 1
- 18312 1
- 18427 1
- 18459 1
- 18490 1
- 18542 1
- 18572 1
- 18625 1
- 18675 1
- 18752 1
- 18775 1
- 18817 1
- 18899 1
- 19069 1
- 19145 1
- 19216 1
- 19265 1
- 19318 1
- 19353 1
- 19449 1
- 19592 1
- 19674 1
- 19757 1
- 19834 1
- 19875 1
- 19903 1
- 20092 1
- 20225 1
- 20310 1
- 20394 1
- 20485 1
- 20528 1
- 20564 1
- 20689 1
- 20826 1
- 20875 1
- 20994 1
- 21122 1
- 21165 1
- 21209 1
- 21274 1
- 21426 1
- 21520 1
- 21586 1
- 21672 1
- 21707 1
- 21749 1
- 21863 1
- 21992 1
- 22239 1
- 22301 1
- 22374 1
- 22484 1
- 22732 1
- 22792 1
- 22849 1
- 22975 1
- 23231 1
- 23300 1
- 23319 1
- 23420 1
- 23680 1
- 23720 1
- 23761 1
- 23876 1
- 24218 1
- 24256 1
- 24368 1
- 24699 1
- 24756 1
- 24792 1
- 24921 1
- 25253 1
- 25281 1
- 25313 1
- 25650 1
- 25689 1
- 25726 1
- 25798 1
- 25981 1
- 25997 1
- 26180 1
- 26194 1
- 26233 1
- 26334 1
- 26511 1
- 26534 1
- 26567 1
- 26645 1
- 26742 1
- 26776 1
- 26784 1
- 26825 1
- 26918 1
- 26944 1
- 26964 1
- 27015 1
- 27153 1
- 27178 1
- 27268 1
- 27668 1
- 27770 1
- 27840 1
- 28773 1
- 28949 1
- 29136 1
- 29794 1
- 31155 1
- 31410 1
- 31559 1
- 32456 1
- 34397 1
- 34774 1
- 35229 1
- 36680 1
- 38109 1
- 38243 1
- 38481 1
- 39648 1
- 40284 1
- 40466 1
- 40764 1
- 41202 1
- 41697 1
- 41837 1
- 41903 1
- 42195 1
- 42609 1
- 42646 1
- 42800 1
- 42933 1
- 42947 1
- 42970 1
- 43052 1
- 43110 1
- 43139 1
- 43160 1
- 43222 1
- 43263 1
- 43270 1
- 43273 1
- 43282 1
- 43304 1
- 43308 1
- 43324 1
- 43356 1
- 43362 1
- 43363 1
- 43364 1
- 43397 1
- 43430 1
- 43444 1
- 43685 1
state 1
- California · 798 ✖
fips 1
- 6039 · 798 ✖
county 1
- Madera 798
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499781 | 2499781 | 2022-05-13 | Madera | California | 6039 | 43685 | 365 |
2496523 | 2496523 | 2022-05-12 | Madera | California | 6039 | 43585 | 365 |
2493265 | 2493265 | 2022-05-11 | Madera | California | 6039 | 43585 | 365 |
2490007 | 2490007 | 2022-05-10 | Madera | California | 6039 | 43585 | 365 |
2486750 | 2486750 | 2022-05-09 | Madera | California | 6039 | 43525 | 365 |
2483492 | 2483492 | 2022-05-08 | Madera | California | 6039 | 43525 | 365 |
2480234 | 2480234 | 2022-05-07 | Madera | California | 6039 | 43525 | 365 |
2476976 | 2476976 | 2022-05-06 | Madera | California | 6039 | 43525 | 365 |
2473718 | 2473718 | 2022-05-05 | Madera | California | 6039 | 43525 | 365 |
2470461 | 2470461 | 2022-05-04 | Madera | California | 6039 | 43525 | 365 |
2467205 | 2467205 | 2022-05-03 | Madera | California | 6039 | 43525 | 365 |
2463950 | 2463950 | 2022-05-02 | Madera | California | 6039 | 43490 | 365 |
2460694 | 2460694 | 2022-05-01 | Madera | California | 6039 | 43490 | 365 |
2457438 | 2457438 | 2022-04-30 | Madera | California | 6039 | 43490 | 365 |
2454182 | 2454182 | 2022-04-29 | Madera | California | 6039 | 43490 | 365 |
2450926 | 2450926 | 2022-04-28 | Madera | California | 6039 | 43436 | 354 |
2447670 | 2447670 | 2022-04-27 | Madera | California | 6039 | 43436 | 354 |
2444414 | 2444414 | 2022-04-26 | Madera | California | 6039 | 43436 | 354 |
2441158 | 2441158 | 2022-04-25 | Madera | California | 6039 | 43430 | 354 |
2437902 | 2437902 | 2022-04-24 | Madera | California | 6039 | 43445 | 354 |
2434646 | 2434646 | 2022-04-23 | Madera | California | 6039 | 43445 | 354 |
2431390 | 2431390 | 2022-04-22 | Madera | California | 6039 | 43445 | 354 |
2428134 | 2428134 | 2022-04-21 | Madera | California | 6039 | 43445 | 354 |
2424878 | 2424878 | 2022-04-20 | Madera | California | 6039 | 43445 | 354 |
2421622 | 2421622 | 2022-04-19 | Madera | California | 6039 | 43445 | 354 |
2418366 | 2418366 | 2022-04-18 | Madera | California | 6039 | 43445 | 354 |
2415110 | 2415110 | 2022-04-17 | Madera | California | 6039 | 43445 | 354 |
2411854 | 2411854 | 2022-04-16 | Madera | California | 6039 | 43445 | 354 |
2408598 | 2408598 | 2022-04-15 | Madera | California | 6039 | 43445 | 354 |
2405342 | 2405342 | 2022-04-14 | Madera | California | 6039 | 43444 | 354 |
2402087 | 2402087 | 2022-04-13 | Madera | California | 6039 | 43423 | 354 |
2398832 | 2398832 | 2022-04-12 | Madera | California | 6039 | 43423 | 354 |
2395577 | 2395577 | 2022-04-11 | Madera | California | 6039 | 43423 | 354 |
2392321 | 2392321 | 2022-04-10 | Madera | California | 6039 | 43423 | 354 |
2389065 | 2389065 | 2022-04-09 | Madera | California | 6039 | 43423 | 354 |
2385810 | 2385810 | 2022-04-08 | Madera | California | 6039 | 43423 | 354 |
2382555 | 2382555 | 2022-04-07 | Madera | California | 6039 | 43416 | 354 |
2379300 | 2379300 | 2022-04-06 | Madera | California | 6039 | 43416 | 354 |
2376046 | 2376046 | 2022-04-05 | Madera | California | 6039 | 43416 | 354 |
2372794 | 2372794 | 2022-04-04 | Madera | California | 6039 | 43400 | 354 |
2369541 | 2369541 | 2022-04-03 | Madera | California | 6039 | 43400 | 354 |
2366288 | 2366288 | 2022-04-02 | Madera | California | 6039 | 43400 | 354 |
2363035 | 2363035 | 2022-04-01 | Madera | California | 6039 | 43400 | 354 |
2359781 | 2359781 | 2022-03-31 | Madera | California | 6039 | 43397 | 354 |
2356527 | 2356527 | 2022-03-30 | Madera | California | 6039 | 43364 | 354 |
2353274 | 2353274 | 2022-03-29 | Madera | California | 6039 | 43363 | 354 |
2350022 | 2350022 | 2022-03-28 | Madera | California | 6039 | 43362 | 354 |
2346769 | 2346769 | 2022-03-27 | Madera | California | 6039 | 43360 | 354 |
2343516 | 2343516 | 2022-03-26 | Madera | California | 6039 | 43360 | 354 |
2340263 | 2340263 | 2022-03-25 | Madera | California | 6039 | 43360 | 354 |
2337010 | 2337010 | 2022-03-24 | Madera | California | 6039 | 43356 | 354 |
2333756 | 2333756 | 2022-03-23 | Madera | California | 6039 | 43324 | 354 |
2330502 | 2330502 | 2022-03-22 | Madera | California | 6039 | 43308 | 354 |
2327250 | 2327250 | 2022-03-21 | Madera | California | 6039 | 43304 | 354 |
2323997 | 2323997 | 2022-03-20 | Madera | California | 6039 | 43293 | 354 |
2320743 | 2320743 | 2022-03-19 | Madera | California | 6039 | 43293 | 354 |
2317489 | 2317489 | 2022-03-18 | Madera | California | 6039 | 43293 | 354 |
2314236 | 2314236 | 2022-03-17 | Madera | California | 6039 | 43282 | 354 |
2310983 | 2310983 | 2022-03-16 | Madera | California | 6039 | 43273 | 354 |
2307730 | 2307730 | 2022-03-15 | Madera | California | 6039 | 43270 | 354 |
2304479 | 2304479 | 2022-03-14 | Madera | California | 6039 | 43263 | 354 |
2301227 | 2301227 | 2022-03-13 | Madera | California | 6039 | 43238 | 354 |
2297975 | 2297975 | 2022-03-12 | Madera | California | 6039 | 43238 | 354 |
2294723 | 2294723 | 2022-03-11 | Madera | California | 6039 | 43238 | 354 |
2291471 | 2291471 | 2022-03-10 | Madera | California | 6039 | 43222 | 354 |
2288219 | 2288219 | 2022-03-09 | Madera | California | 6039 | 43160 | 354 |
2284968 | 2284968 | 2022-03-08 | Madera | California | 6039 | 43139 | 354 |
2281716 | 2281716 | 2022-03-07 | Madera | California | 6039 | 43110 | 354 |
2278463 | 2278463 | 2022-03-06 | Madera | California | 6039 | 43075 | 354 |
2275210 | 2275210 | 2022-03-05 | Madera | California | 6039 | 43075 | 354 |
2271957 | 2271957 | 2022-03-04 | Madera | California | 6039 | 43075 | 354 |
2268705 | 2268705 | 2022-03-03 | Madera | California | 6039 | 43052 | 354 |
2265452 | 2265452 | 2022-03-02 | Madera | California | 6039 | 42970 | 354 |
2262201 | 2262201 | 2022-03-01 | Madera | California | 6039 | 42947 | 354 |
2258950 | 2258950 | 2022-02-28 | Madera | California | 6039 | 42933 | 354 |
2255699 | 2255699 | 2022-02-27 | Madera | California | 6039 | 42857 | 330 |
2252448 | 2252448 | 2022-02-26 | Madera | California | 6039 | 42857 | 330 |
2249197 | 2249197 | 2022-02-25 | Madera | California | 6039 | 42857 | 330 |
2245946 | 2245946 | 2022-02-24 | Madera | California | 6039 | 42800 | 330 |
2242695 | 2242695 | 2022-02-23 | Madera | California | 6039 | 42646 | 330 |
2239444 | 2239444 | 2022-02-22 | Madera | California | 6039 | 42609 | 330 |
2236193 | 2236193 | 2022-02-21 | Madera | California | 6039 | 42339 | 330 |
2232942 | 2232942 | 2022-02-20 | Madera | California | 6039 | 42339 | 330 |
2229691 | 2229691 | 2022-02-19 | Madera | California | 6039 | 42339 | 330 |
2226440 | 2226440 | 2022-02-18 | Madera | California | 6039 | 42339 | 330 |
2223189 | 2223189 | 2022-02-17 | Madera | California | 6039 | 42195 | 330 |
2219938 | 2219938 | 2022-02-16 | Madera | California | 6039 | 41903 | 330 |
2216687 | 2216687 | 2022-02-15 | Madera | California | 6039 | 41837 | 330 |
2213436 | 2213436 | 2022-02-14 | Madera | California | 6039 | 41697 | 330 |
2210184 | 2210184 | 2022-02-13 | Madera | California | 6039 | 41353 | 330 |
2206931 | 2206931 | 2022-02-12 | Madera | California | 6039 | 41353 | 330 |
2203678 | 2203678 | 2022-02-11 | Madera | California | 6039 | 41353 | 330 |
2200425 | 2200425 | 2022-02-10 | Madera | California | 6039 | 41202 | 330 |
2197171 | 2197171 | 2022-02-09 | Madera | California | 6039 | 40764 | 330 |
2193916 | 2193916 | 2022-02-08 | Madera | California | 6039 | 40466 | 330 |
2190663 | 2190663 | 2022-02-07 | Madera | California | 6039 | 40284 | 339 |
2187410 | 2187410 | 2022-02-06 | Madera | California | 6039 | 39854 | 339 |
2184157 | 2184157 | 2022-02-05 | Madera | California | 6039 | 39854 | 339 |
2180905 | 2180905 | 2022-02-04 | Madera | California | 6039 | 39854 | 339 |
2177654 | 2177654 | 2022-02-03 | Madera | California | 6039 | 39648 | 339 |
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);