ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where county = "San Mateo" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 654 ✖
- 1 7
- 128573 6
- 56058 5
- 42691 4
- 54168 4
- 59051 4
- 123477 4
- 127776 4
- 129753 4
- 131329 4
- 133181 4
- 135173 4
- 8617 3
- 10510 3
- 43443 3
- 43819 3
- 44416 3
- 45194 3
- 52540 3
- 53106 3
- 53517 3
- 53828 3
- 54579 3
- 55023 3
- 55830 3
- 56585 3
- 57192 3
- 57703 3
- 63074 3
- 72463 3
- 87189 3
- 101729 3
- 114055 3
- 119836 3
- 122691 3
- 124726 3
- 125568 3
- 126271 3
- 126788 3
- 127211 3
- 128100 3
- 130380 3
- 132241 3
- 134174 3
- 136379 3
- 9 2
- 20 2
- 32 2
- 309 2
- 652 2
- 767 2
- 838 2
- 1019 2
- 2553 2
- 3536 2
- 5544 2
- 6110 2
- 6952 2
- 7535 2
- 8074 2
- 9077 2
- 9332 2
- 9522 2
- 9843 2
- 10207 2
- 10743 2
- 11075 2
- 11371 2
- 11810 2
- 12127 2
- 12465 2
- 13203 2
- 13707 2
- 14148 2
- 17724 2
- 20479 2
- 22241 2
- 24589 2
- 33731 2
- 35466 2
- 42059 2
- 42386 2
- 42389 2
- 46180 2
- 55364 2
- 55495 2
- 15 1
- 42 1
- 64 1
- 80 1
- 89 1
- 100 1
- 110 1
- 117 1
- 142 1
- 161 1
- 165 1
- 195 1
- 239 1
- 274 1
- 277 1
- 388 1
- 453 1
- 486 1
- 538 1
- 555 1
- 579 1
- 589 1
- 617 1
- 633 1
- 638 1
- 701 1
- 747 1
- 797 1
- 920 1
- 935 1
- 958 1
- 966 1
- 989 1
- 1080 1
- 1099 1
- 1136 1
- 1177 1
- 1197 1
- 1233 1
- 1272 1
- 1281 1
- 1315 1
- 1341 1
- 1377 1
- 1398 1
- 1425 1
- 1453 1
- 1464 1
- 1499 1
- 1533 1
- 1550 1
- 1588 1
- 1612 1
- 1652 1
- 1680 1
- 1701 1
- 1704 1
- 1739 1
- 1791 1
- 1847 1
- 1862 1
- 1925 1
- 1938 1
- 1967 1
- 2045 1
- 2070 1
- 2104 1
- 2129 1
- 2169 1
- 2190 1
- 2212 1
- 2244 1
- 2299 1
- 2331 1
- 2342 1
- 2399 1
- 2437 1
- 2475 1
- 2494 1
- 2533 1
- 2571 1
- 2591 1
- 2618 1
- 2649 1
- 2674 1
- 2713 1
- 2755 1
- 2781 1
- 2813 1
- 2907 1
- 2964 1
- 2996 1
- 3055 1
- 3083 1
- 3124 1
- 3170 1
- 3268 1
- 3376 1
- 3441 1
- 3599 1
- 3692 1
- 3743 1
- 3787 1
- 3846 1
- 3949 1
- 3956 1
- 4045 1
- 4168 1
- 4254 1
- 4333 1
- 4403 1
- 4465 1
- 4488 1
- 4551 1
- 4674 1
- 4776 1
- 4885 1
- 4957 1
- 5022 1
- 5023 1
- 5124 1
- 5198 1
- 5306 1
- 5398 1
- 5469 1
- 5683 1
- 5744 1
- 5758 1
- 5891 1
- 5978 1
- 6318 1
- 6431 1
- 6535 1
- 6640 1
- 6803 1
- 7150 1
- 7228 1
- 7321 1
- 7382 1
- 7472 1
- 7670 1
- 7788 1
- 7849 1
- 7911 1
- 7978 1
- 8169 1
- 8260 1
- 8311 1
- 8390 1
- 8452 1
- 8750 1
- 8807 1
- 8895 1
- 8966 1
- 9166 1
- 9242 1
- 9264 1
- 9598 1
- 9625 1
- 9664 1
- 9714 1
- 9785 1
- 9897 1
- 9950 1
- 9990 1
- 10069 1
- 10126 1
- 10275 1
- 10309 1
- 10347 1
- 10395 1
- 10452 1
- 10601 1
- 10622 1
- 10655 1
- 10687 1
- 10810 1
- 10889 1
- 10918 1
- 10961 1
- 11002 1
- 11149 1
- 11198 1
- 11232 1
- 11278 1
- 11341 1
- 11451 1
- 11479 1
- 11564 1
- 11629 1
- 11710 1
- 11937 1
- 12049 1
- 12332 1
- 12565 1
- 12684 1
- 12780 1
- 12878 1
- 12988 1
- 13334 1
- 13561 1
- 13715 1
- 14458 1
- 14614 1
- 14812 1
- 15040 1
- 15217 1
- 15468 1
- 15512 1
- 16101 1
- 16371 1
- 16666 1
- 16884 1
- 17176 1
- 18584 1
- 18875 1
- 19330 1
- 19645 1
- 20089 1
- 21160 1
- 21558 1
- 21913 1
- 22568 1
- 22908 1
- 23681 1
- 23916 1
- 24246 1
- 25041 1
- 25483 1
- 25767 1
- 26150 1
- 26497 1
- 27050 1
- 27494 1
- 28072 1
- 28512 1
- 28972 1
- 29355 1
- 29747 1
- 30196 1
- 30694 1
- 31291 1
- 31805 1
- 32186 1
- 32596 1
- 32887 1
- 33207 1
- 33468 1
- 34294 1
- 34510 1
- 34738 1
- 34958 1
- 35235 1
- 35882 1
- 36052 1
- 36214 1
- 36451 1
- 36599 1
- 36689 1
- 36824 1
- 37058 1
- 37139 1
- 37277 1
- 37437 1
- 37548 1
- 37621 1
- 37745 1
- 37859 1
- 37969 1
- 38041 1
- 38124 1
- 38229 1
- 38256 1
- 38371 1
- 38448 1
- 38552 1
- 38662 1
- 38763 1
- 38872 1
- 38922 1
- 38998 1
- 39059 1
- 39096 1
- 39148 1
- 39189 1
- 39225 1
- 39305 1
- 39384 1
- 39436 1
- 39492 1
- 39535 1
- 39571 1
- 39590 1
- 39638 1
- 39689 1
- 39744 1
- 39765 1
- 39806 1
- 39838 1
- 39874 1
- 39893 1
- 39958 1
- 39988 1
- 40024 1
- 40032 1
- 40083 1
- 40147 1
- 40199 1
- 40264 1
- 40305 1
- 40357 1
- 40385 1
- 40424 1
- 40462 1
- 40542 1
- 40560 1
- 40595 1
- 40618 1
- 40649 1
- 40708 1
- 40754 1
- 40800 1
- 40878 1
- 40901 1
- 40920 1
- 40955 1
- 41015 1
- 41050 1
- 41107 1
- 41157 1
- 41201 1
- 41226 1
- 41251 1
- 41318 1
- 41345 1
- 41386 1
- 41424 1
- 41457 1
- 41465 1
- 41474 1
- 41498 1
- 41538 1
- 41583 1
- 41617 1
- 41656 1
- 41689 1
- 41708 1
- 41755 1
- 41802 1
- 41844 1
- 41871 1
- 41903 1
- 41926 1
- 41985 1
- 42038 1
- 42041 1
- 42063 1
- 42083 1
- 42099 1
- 42126 1
- 42152 1
- 42163 1
- 42218 1
- 42248 1
- 42249 1
- 42268 1
- 42331 1
- 42345 1
- 42364 1
- 42375 1
- 42396 1
- 42413 1
- 42433 1
- 42457 1
- 42479 1
- 42488 1
- 42502 1
- 42540 1
- 42562 1
- 42585 1
- 42593 1
- 42599 1
- 42601 1
- 42604 1
- 42611 1
- 42615 1
- 42619 1
- 42630 1
- 42646 1
- 42681 1
- 42685 1
- 42725 1
- 42756 1
- 42814 1
- 42849 1
- 42876 1
- 42895 1
- 42898 1
- 42925 1
- 42927 1
- 43403 1
- 43602 1
- 43633 1
- 43675 1
- 43744 1
- 44001 1
- 44058 1
- 44165 1
- 44291 1
- 44725 1
- 44833 1
- 44914 1
- 45049 1
- 45608 1
- 45726 1
- 45827 1
- 46018 1
- 46430 1
- 46553 1
- 46666 1
- 46810 1
- 46926 1
- 47061 1
- 47286 1
- 47418 1
- 47523 1
- 47650 1
- 47753 1
- 48115 1
- 48291 1
- 48421 1
- 48545 1
- 48681 1
- 48795 1
- 48910 1
- 49093 1
- 49203 1
- 49364 1
- 49515 1
- 49677 1
- 49779 1
- 50239 1
- 50421 1
- 50517 1
- 50644 1
- 50748 1
- 50836 1
- 50886 1
- 50940 1
- 51155 1
- 51247 1
- 51355 1
- 51445 1
- 51536 1
- 51629 1
- 51706 1
- 51902 1
- 51984 1
- 52065 1
- 52172 1
- 52239 1
- 52311 1
- 52347 1
- 52471 1
- 52770 1
- 52826 1
- 52894 1
- 53012 1
- 53262 1
- 53297 1
- 53347 1
- 53452 1
- 53669 1
- 53694 1
- 53724 1
- 53781 1
- 53970 1
- 54023 1
- 54046 1
- 54112 1
- 54376 1
- 54423 1
- 54528 1
- 54780 1
- 54810 1
- 54847 1
- 54977 1
- 55181 1
- 55239 1
- 55278 1
- 55620 1
- 55652 1
- 55676 1
- 55790 1
- 55988 1
- 56028 1
- 56265 1
- 56320 1
- 56354 1
- 56522 1
- 56861 1
- 56923 1
- 56974 1
- 57128 1
- 57413 1
- 57477 1
- 57509 1
- 57630 1
- 58105 1
- 58220 1
- 58354 1
- 58682 1
- 60475 1
- 60790 1
- 62048 1
- 64291 1
- 67040 1
- 67727 1
- 70563 1
- 78412 1
- 79755 1
- 81301 1
- 85171 1
- 92661 1
- 93708 1
- 94920 1
- 100004 1
- 106229 1
- 107257 1
- 108299 1
- 112765 1
- 116728 1
- 117062 1
- 117617 1
- 119227 1
- 120582 1
- 122086 1
- 122346 1
- 123267 1
- 123332 1
- 123585 1
- 123709 1
- 124088 1
- 124247 1
- 124451 1
- 125110 1
- 125167 1
- 125224 1
- 125440 1
- 125838 1
- 125957 1
- 126025 1
- 126177 1
- 126504 1
- 126547 1
- 126569 1
- 126686 1
- 126905 1
- 126907 1
- 126981 1
- 127126 1
- 127370 1
- 127383 1
- 127481 1
- 127607 1
- 129268 1
- 129567 1
- 137238 1
state 1
- California 803
fips 1
- 6081 803
county 1
- San Mateo · 803 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
437 | 437 | 2020-03-02 | San Mateo | California | 6081 | 1 | 0 |
471 | 471 | 2020-03-03 | San Mateo | California | 6081 | 1 | 0 |
506 | 506 | 2020-03-04 | San Mateo | California | 6081 | 1 | 0 |
545 | 545 | 2020-03-05 | San Mateo | California | 6081 | 1 | 0 |
595 | 595 | 2020-03-06 | San Mateo | California | 6081 | 1 | 0 |
672 | 672 | 2020-03-07 | San Mateo | California | 6081 | 1 | 0 |
767 | 767 | 2020-03-08 | San Mateo | California | 6081 | 1 | 0 |
881 | 881 | 2020-03-09 | San Mateo | California | 6081 | 9 | 0 |
1014 | 1014 | 2020-03-10 | San Mateo | California | 6081 | 9 | 0 |
1180 | 1180 | 2020-03-11 | San Mateo | California | 6081 | 15 | 0 |
1386 | 1386 | 2020-03-12 | San Mateo | California | 6081 | 20 | 0 |
1647 | 1647 | 2020-03-13 | San Mateo | California | 6081 | 20 | 0 |
1965 | 1965 | 2020-03-14 | San Mateo | California | 6081 | 32 | 0 |
2345 | 2345 | 2020-03-15 | San Mateo | California | 6081 | 32 | 1 |
2780 | 2780 | 2020-03-16 | San Mateo | California | 6081 | 42 | 1 |
3262 | 3262 | 2020-03-17 | San Mateo | California | 6081 | 64 | 1 |
3816 | 3816 | 2020-03-18 | San Mateo | California | 6081 | 80 | 1 |
4476 | 4476 | 2020-03-19 | San Mateo | California | 6081 | 89 | 1 |
5251 | 5251 | 2020-03-20 | San Mateo | California | 6081 | 100 | 1 |
6172 | 6172 | 2020-03-21 | San Mateo | California | 6081 | 110 | 1 |
7206 | 7206 | 2020-03-22 | San Mateo | California | 6081 | 117 | 1 |
8349 | 8349 | 2020-03-23 | San Mateo | California | 6081 | 142 | 1 |
9592 | 9592 | 2020-03-24 | San Mateo | California | 6081 | 161 | 1 |
10964 | 10964 | 2020-03-25 | San Mateo | California | 6081 | 165 | 5 |
12509 | 12509 | 2020-03-26 | San Mateo | California | 6081 | 195 | 5 |
14175 | 14175 | 2020-03-27 | San Mateo | California | 6081 | 239 | 6 |
15957 | 15957 | 2020-03-28 | San Mateo | California | 6081 | 274 | 6 |
17846 | 17846 | 2020-03-29 | San Mateo | California | 6081 | 277 | 6 |
19823 | 19823 | 2020-03-30 | San Mateo | California | 6081 | 309 | 6 |
21898 | 21898 | 2020-03-31 | San Mateo | California | 6081 | 309 | 10 |
24056 | 24056 | 2020-04-01 | San Mateo | California | 6081 | 388 | 10 |
26285 | 26285 | 2020-04-02 | San Mateo | California | 6081 | 453 | 10 |
28584 | 28584 | 2020-04-03 | San Mateo | California | 6081 | 486 | 13 |
30942 | 30942 | 2020-04-04 | San Mateo | California | 6081 | 538 | 13 |
33348 | 33348 | 2020-04-05 | San Mateo | California | 6081 | 555 | 13 |
35793 | 35793 | 2020-04-06 | San Mateo | California | 6081 | 579 | 13 |
38282 | 38282 | 2020-04-07 | San Mateo | California | 6081 | 589 | 21 |
40826 | 40826 | 2020-04-08 | San Mateo | California | 6081 | 617 | 21 |
43398 | 43398 | 2020-04-09 | San Mateo | California | 6081 | 633 | 21 |
45998 | 45998 | 2020-04-10 | San Mateo | California | 6081 | 638 | 21 |
48628 | 48628 | 2020-04-11 | San Mateo | California | 6081 | 652 | 21 |
51290 | 51290 | 2020-04-12 | San Mateo | California | 6081 | 652 | 21 |
53969 | 53969 | 2020-04-13 | San Mateo | California | 6081 | 701 | 21 |
56661 | 56661 | 2020-04-14 | San Mateo | California | 6081 | 747 | 21 |
59369 | 59369 | 2020-04-15 | San Mateo | California | 6081 | 767 | 28 |
62088 | 62088 | 2020-04-16 | San Mateo | California | 6081 | 767 | 28 |
64821 | 64821 | 2020-04-17 | San Mateo | California | 6081 | 797 | 28 |
67569 | 67569 | 2020-04-18 | San Mateo | California | 6081 | 838 | 28 |
70331 | 70331 | 2020-04-19 | San Mateo | California | 6081 | 838 | 28 |
73100 | 73100 | 2020-04-20 | San Mateo | California | 6081 | 920 | 28 |
75876 | 75876 | 2020-04-21 | San Mateo | California | 6081 | 935 | 28 |
78660 | 78660 | 2020-04-22 | San Mateo | California | 6081 | 958 | 39 |
81454 | 81454 | 2020-04-23 | San Mateo | California | 6081 | 966 | 39 |
84254 | 84254 | 2020-04-24 | San Mateo | California | 6081 | 989 | 41 |
87062 | 87062 | 2020-04-25 | San Mateo | California | 6081 | 1019 | 41 |
89879 | 89879 | 2020-04-26 | San Mateo | California | 6081 | 1019 | 41 |
92697 | 92697 | 2020-04-27 | San Mateo | California | 6081 | 1080 | 46 |
95529 | 95529 | 2020-04-28 | San Mateo | California | 6081 | 1099 | 48 |
98374 | 98374 | 2020-04-29 | San Mateo | California | 6081 | 1136 | 48 |
101224 | 101224 | 2020-04-30 | San Mateo | California | 6081 | 1177 | 50 |
104079 | 104079 | 2020-05-01 | San Mateo | California | 6081 | 1197 | 52 |
106944 | 106944 | 2020-05-02 | San Mateo | California | 6081 | 1233 | 52 |
109813 | 109813 | 2020-05-03 | San Mateo | California | 6081 | 1272 | 52 |
112688 | 112688 | 2020-05-04 | San Mateo | California | 6081 | 1281 | 53 |
115571 | 115571 | 2020-05-05 | San Mateo | California | 6081 | 1315 | 53 |
118530 | 118530 | 2020-05-06 | San Mateo | California | 6081 | 1341 | 56 |
121497 | 121497 | 2020-05-07 | San Mateo | California | 6081 | 1377 | 56 |
124477 | 124477 | 2020-05-08 | San Mateo | California | 6081 | 1398 | 57 |
127462 | 127462 | 2020-05-09 | San Mateo | California | 6081 | 1425 | 62 |
130452 | 130452 | 2020-05-10 | San Mateo | California | 6081 | 1453 | 65 |
133442 | 133442 | 2020-05-11 | San Mateo | California | 6081 | 1464 | 65 |
136432 | 136432 | 2020-05-12 | San Mateo | California | 6081 | 1499 | 65 |
139423 | 139423 | 2020-05-13 | San Mateo | California | 6081 | 1533 | 66 |
142419 | 142419 | 2020-05-14 | San Mateo | California | 6081 | 1550 | 66 |
145418 | 145418 | 2020-05-15 | San Mateo | California | 6081 | 1588 | 66 |
148422 | 148422 | 2020-05-16 | San Mateo | California | 6081 | 1612 | 67 |
151431 | 151431 | 2020-05-17 | San Mateo | California | 6081 | 1652 | 68 |
154443 | 154443 | 2020-05-18 | San Mateo | California | 6081 | 1680 | 68 |
157459 | 157459 | 2020-05-19 | San Mateo | California | 6081 | 1701 | 68 |
160485 | 160485 | 2020-05-20 | San Mateo | California | 6081 | 1704 | 75 |
163513 | 163513 | 2020-05-21 | San Mateo | California | 6081 | 1739 | 75 |
166545 | 166545 | 2020-05-22 | San Mateo | California | 6081 | 1791 | 76 |
169582 | 169582 | 2020-05-23 | San Mateo | California | 6081 | 1847 | 76 |
172623 | 172623 | 2020-05-24 | San Mateo | California | 6081 | 1862 | 76 |
175667 | 175667 | 2020-05-25 | San Mateo | California | 6081 | 1925 | 76 |
178711 | 178711 | 2020-05-26 | San Mateo | California | 6081 | 1938 | 82 |
181755 | 181755 | 2020-05-27 | San Mateo | California | 6081 | 1967 | 82 |
184809 | 184809 | 2020-05-28 | San Mateo | California | 6081 | 2045 | 82 |
187865 | 187865 | 2020-05-29 | San Mateo | California | 6081 | 2070 | 84 |
190930 | 190930 | 2020-05-30 | San Mateo | California | 6081 | 2104 | 84 |
193997 | 193997 | 2020-05-31 | San Mateo | California | 6081 | 2129 | 84 |
197067 | 197067 | 2020-06-01 | San Mateo | California | 6081 | 2169 | 84 |
200140 | 200140 | 2020-06-02 | San Mateo | California | 6081 | 2190 | 84 |
203216 | 203216 | 2020-06-03 | San Mateo | California | 6081 | 2212 | 84 |
206296 | 206296 | 2020-06-04 | San Mateo | California | 6081 | 2244 | 84 |
209377 | 209377 | 2020-06-05 | San Mateo | California | 6081 | 2299 | 84 |
212462 | 212462 | 2020-06-06 | San Mateo | California | 6081 | 2331 | 88 |
215549 | 215549 | 2020-06-07 | San Mateo | California | 6081 | 2342 | 88 |
218640 | 218640 | 2020-06-08 | San Mateo | California | 6081 | 2399 | 88 |
221735 | 221735 | 2020-06-09 | San Mateo | California | 6081 | 2437 | 93 |
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);