ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 11001 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 650 ✖
- 141943 13
- 134678 7
- 135223 6
- 137603 6
- 66510 5
- 136886 5
- 139772 5
- 48898 4
- 49378 4
- 55918 4
- 62266 4
- 68702 4
- 79565 4
- 94286 4
- 121871 4
- 133697 4
- 141355 4
- 10 3
- 49068 3
- 49158 3
- 49243 3
- 49305 3
- 49455 3
- 49652 3
- 49973 3
- 50398 3
- 51103 3
- 52201 3
- 53342 3
- 54556 3
- 56966 3
- 58851 3
- 60205 3
- 61331 3
- 62976 3
- 63588 3
- 64240 3
- 64799 3
- 65371 3
- 66028 3
- 67430 3
- 71219 3
- 110040 3
- 127200 3
- 129817 3
- 131543 3
- 132820 3
- 134326 3
- 135752 3
- 136322 3
- 1 2
- 4 2
- 27436 2
- 50160 2
- 52843 2
- 65159 2
- 135086 2
- 136598 2
- 139160 2
- 140845 2
- 143005 2
- 143943 2
- 16 1
- 17 1
- 22 1
- 31 1
- 36 1
- 39 1
- 71 1
- 77 1
- 98 1
- 116 1
- 137 1
- 183 1
- 231 1
- 267 1
- 304 1
- 342 1
- 401 1
- 495 1
- 586 1
- 653 1
- 757 1
- 902 1
- 998 1
- 1097 1
- 1211 1
- 1440 1
- 1523 1
- 1660 1
- 1778 1
- 1875 1
- 1955 1
- 2058 1
- 2197 1
- 2350 1
- 2476 1
- 2666 1
- 2793 1
- 2927 1
- 3098 1
- 3206 1
- 3361 1
- 3528 1
- 3699 1
- 3841 1
- 3892 1
- 3994 1
- 4106 1
- 4323 1
- 4658 1
- 4797 1
- 5016 1
- 5170 1
- 5322 1
- 5461 1
- 5654 1
- 5899 1
- 6102 1
- 6272 1
- 6389 1
- 6485 1
- 6584 1
- 6736 1
- 6871 1
- 7042 1
- 7123 1
- 7270 1
- 7434 1
- 7551 1
- 7788 1
- 7893 1
- 7966 1
- 8110 1
- 8225 1
- 8334 1
- 8406 1
- 8492 1
- 8538 1
- 8717 1
- 8801 1
- 8857 1
- 8886 1
- 9016 1
- 9120 1
- 9199 1
- 9269 1
- 9332 1
- 9389 1
- 9474 1
- 9537 1
- 9589 1
- 9654 1
- 9709 1
- 9767 1
- 9799 1
- 9818 1
- 9847 1
- 9903 1
- 9952 1
- 9984 1
- 10020 1
- 10058 1
- 10094 1
- 10128 1
- 10159 1
- 10185 1
- 10216 1
- 10248 1
- 10292 1
- 10327 1
- 10365 1
- 10390 1
- 10435 1
- 10447 1
- 10482 1
- 10515 1
- 10569 1
- 10642 1
- 10679 1
- 10743 1
- 10801 1
- 10847 1
- 10906 1
- 10946 1
- 11026 1
- 11076 1
- 11115 1
- 11194 1
- 11261 1
- 11339 1
- 11427 1
- 11529 1
- 11571 1
- 11649 1
- 11717 1
- 11780 1
- 11858 1
- 11945 1
- 11999 1
- 12057 1
- 12126 1
- 12205 1
- 12274 1
- 12313 1
- 12398 1
- 12443 1
- 12518 1
- 12589 1
- 12653 1
- 12753 1
- 12807 1
- 12896 1
- 12959 1
- 13024 1
- 13118 1
- 13159 1
- 13220 1
- 13273 1
- 13325 1
- 13354 1
- 13409 1
- 13469 1
- 13534 1
- 13590 1
- 13639 1
- 13684 1
- 13722 1
- 13794 1
- 13851 1
- 13925 1
- 13959 1
- 13992 1
- 14049 1
- 14077 1
- 14135 1
- 14186 1
- 14238 1
- 14279 1
- 14315 1
- 14362 1
- 14387 1
- 14412 1
- 14493 1
- 14552 1
- 14592 1
- 14622 1
- 14687 1
- 14743 1
- 14790 1
- 14852 1
- 14902 1
- 14955 1
- 14978 1
- 15021 1
- 15050 1
- 15106 1
- 15163 1
- 15215 1
- 15250 1
- 15264 1
- 15300 1
- 15326 1
- 15358 1
- 15423 1
- 15473 1
- 15519 1
- 15547 1
- 15652 1
- 15697 1
- 15765 1
- 15843 1
- 15918 1
- 15984 1
- 16022 1
- 16068 1
- 16132 1
- 16166 1
- 16255 1
- 16334 1
- 16370 1
- 16395 1
- 16445 1
- 16498 1
- 16537 1
- 16609 1
- 16706 1
- 16767 1
- 16812 1
- 16906 1
- 16973 1
- 17074 1
- 17144 1
- 17266 1
- 17369 1
- 17438 1
- 17524 1
- 17601 1
- 17682 1
- 17792 1
- 17891 1
- 18001 1
- 18087 1
- 18173 1
- 18379 1
- 18507 1
- 18666 1
- 18814 1
- 18977 1
- 19064 1
- 19309 1
- 19465 1
- 19678 1
- 19808 1
- 19961 1
- 20151 1
- 20290 1
- 20409 1
- 20516 1
- 20736 1
- 20937 1
- 21308 1
- 21448 1
- 21552 1
- 21685 1
- 21842 1
- 22164 1
- 22480 1
- 22872 1
- 23136 1
- 23319 1
- 23589 1
- 23854 1
- 24098 1
- 24357 1
- 24643 1
- 24874 1
- 25038 1
- 25339 1
- 25602 1
- 25830 1
- 26104 1
- 26342 1
- 26601 1
- 26740 1
- 26900 1
- 27226 1
- 27710 1
- 28202 1
- 28342 1
- 28535 1
- 28758 1
- 28983 1
- 29252 1
- 29509 1
- 29764 1
- 29904 1
- 30166 1
- 30482 1
- 30750 1
- 31107 1
- 31457 1
- 31791 1
- 31993 1
- 32423 1
- 32600 1
- 32820 1
- 33140 1
- 33537 1
- 33851 1
- 34033 1
- 34259 1
- 34403 1
- 34612 1
- 34905 1
- 35077 1
- 35301 1
- 35505 1
- 35700 1
- 35865 1
- 36132 1
- 36414 1
- 36662 1
- 36872 1
- 37008 1
- 37138 1
- 37199 1
- 37365 1
- 37634 1
- 37877 1
- 38035 1
- 38136 1
- 38281 1
- 38348 1
- 38533 1
- 38670 1
- 38796 1
- 38918 1
- 39001 1
- 39131 1
- 39180 1
- 39301 1
- 39461 1
- 39553 1
- 39648 1
- 39755 1
- 39844 1
- 39943 1
- 40122 1
- 40284 1
- 40478 1
- 40598 1
- 40684 1
- 40767 1
- 40818 1
- 41014 1
- 41122 1
- 41273 1
- 41419 1
- 41579 1
- 41910 1
- 42006 1
- 42128 1
- 42282 1
- 42432 1
- 42511 1
- 42623 1
- 42730 1
- 42811 1
- 42892 1
- 43034 1
- 43175 1
- 43229 1
- 43383 1
- 43488 1
- 43595 1
- 43669 1
- 43825 1
- 44051 1
- 44175 1
- 44248 1
- 44413 1
- 44513 1
- 44656 1
- 44807 1
- 44932 1
- 45037 1
- 45112 1
- 45234 1
- 45328 1
- 45498 1
- 45634 1
- 45762 1
- 45830 1
- 45903 1
- 46016 1
- 46209 1
- 46315 1
- 46449 1
- 46579 1
- 46662 1
- 46740 1
- 46869 1
- 46941 1
- 47040 1
- 47141 1
- 47219 1
- 47323 1
- 47378 1
- 47471 1
- 47533 1
- 47614 1
- 47697 1
- 47800 1
- 47855 1
- 47903 1
- 47986 1
- 48041 1
- 48080 1
- 48136 1
- 48164 1
- 48180 1
- 48195 1
- 48282 1
- 48336 1
- 48404 1
- 48424 1
- 48530 1
- 48545 1
- 48590 1
- 48616 1
- 48634 1
- 48662 1
- 48689 1
- 48727 1
- 48748 1
- 48762 1
- 48803 1
- 48822 1
- 48844 1
- 49000 1
- 49011 1
- 49041 1
- 49110 1
- 49119 1
- 49127 1
- 49151 1
- 49179 1
- 49213 1
- 49223 1
- 49232 1
- 49248 1
- 49275 1
- 49284 1
- 49297 1
- 49315 1
- 49335 1
- 49347 1
- 49362 1
- 49417 1
- 49423 1
- 49434 1
- 49526 1
- 49536 1
- 49574 1
- 49615 1
- 49793 1
- 49827 1
- 49858 1
- 49930 1
- 50268 1
- 50329 1
- 50716 1
- 50800 1
- 50858 1
- 50975 1
- 51589 1
- 51726 1
- 51853 1
- 52005 1
- 52777 1
- 53162 1
- 53898 1
- 54031 1
- 54156 1
- 54366 1
- 55253 1
- 55431 1
- 55570 1
- 55718 1
- 56569 1
- 56694 1
- 56859 1
- 57771 1
- 58146 1
- 58440 1
- 58649 1
- 59563 1
- 59712 1
- 59849 1
- 60018 1
- 60772 1
- 60898 1
- 60996 1
- 61153 1
- 61791 1
- 61863 1
- 61978 1
- 62098 1
- 62702 1
- 62750 1
- 62852 1
- 63305 1
- 63345 1
- 63400 1
- 63474 1
- 63879 1
- 63919 1
- 63990 1
- 64108 1
- 64470 1
- 64541 1
- 64602 1
- 64708 1
- 65050 1
- 65094 1
- 65623 1
- 65707 1
- 65793 1
- 65889 1
- 66347 1
- 66433 1
- 66857 1
- 66912 1
- 67047 1
- 67173 1
- 67996 1
- 68134 1
- 68262 1
- 68460 1
- 69540 1
- 69867 1
- 70375 1
- 74982 1
- 76137 1
- 77661 1
- 88765 1
- 90633 1
- 92045 1
- 103487 1
- 105493 1
- 106819 1
- 108112 1
- 116278 1
- 117586 1
- 118802 1
- 120327 1
- 125707 1
- 126187 1
- 126675 1
- 128550 1
- 128739 1
- 129108 1
- 129479 1
- 130888 1
- 130949 1
- 131093 1
- 131284 1
- 132170 1
- 132257 1
- 132384 1
- 132628 1
- 133295 1
- 133339 1
- 133459 1
- 133587 1
- 134066 1
- 134114 1
- 134214 1
- 134564 1
- 134623 1
- 135575 1
- 135681 1
- 135884 1
- 135955 1
- 136062 1
- 136213 1
- 136506 1
- 138939 1
- 140674 1
state 1
fips 1
- 11001 · 798 ✖
county 1
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
683 | 683 | 2020-03-07 | District of Columbia | District of Columbia | 11001 | 1 | 0 |
779 | 779 | 2020-03-08 | District of Columbia | District of Columbia | 11001 | 1 | 0 |
896 | 896 | 2020-03-09 | District of Columbia | District of Columbia | 11001 | 4 | 0 |
1031 | 1031 | 2020-03-10 | District of Columbia | District of Columbia | 11001 | 4 | 0 |
1200 | 1200 | 2020-03-11 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1409 | 1409 | 2020-03-12 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1675 | 1675 | 2020-03-13 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1997 | 1997 | 2020-03-14 | District of Columbia | District of Columbia | 11001 | 16 | 0 |
2379 | 2379 | 2020-03-15 | District of Columbia | District of Columbia | 11001 | 17 | 0 |
2814 | 2814 | 2020-03-16 | District of Columbia | District of Columbia | 11001 | 22 | 0 |
3297 | 3297 | 2020-03-17 | District of Columbia | District of Columbia | 11001 | 31 | 0 |
3854 | 3854 | 2020-03-18 | District of Columbia | District of Columbia | 11001 | 36 | 0 |
4519 | 4519 | 2020-03-19 | District of Columbia | District of Columbia | 11001 | 39 | 0 |
5298 | 5298 | 2020-03-20 | District of Columbia | District of Columbia | 11001 | 71 | 0 |
6225 | 6225 | 2020-03-21 | District of Columbia | District of Columbia | 11001 | 77 | 1 |
7261 | 7261 | 2020-03-22 | District of Columbia | District of Columbia | 11001 | 98 | 1 |
8407 | 8407 | 2020-03-23 | District of Columbia | District of Columbia | 11001 | 116 | 2 |
9652 | 9652 | 2020-03-24 | District of Columbia | District of Columbia | 11001 | 137 | 2 |
11026 | 11026 | 2020-03-25 | District of Columbia | District of Columbia | 11001 | 183 | 2 |
12574 | 12574 | 2020-03-26 | District of Columbia | District of Columbia | 11001 | 231 | 3 |
14243 | 14243 | 2020-03-27 | District of Columbia | District of Columbia | 11001 | 267 | 3 |
16027 | 16027 | 2020-03-28 | District of Columbia | District of Columbia | 11001 | 304 | 4 |
17919 | 17919 | 2020-03-29 | District of Columbia | District of Columbia | 11001 | 342 | 5 |
19899 | 19899 | 2020-03-30 | District of Columbia | District of Columbia | 11001 | 401 | 9 |
21976 | 21976 | 2020-03-31 | District of Columbia | District of Columbia | 11001 | 495 | 9 |
24135 | 24135 | 2020-04-01 | District of Columbia | District of Columbia | 11001 | 586 | 11 |
26365 | 26365 | 2020-04-02 | District of Columbia | District of Columbia | 11001 | 653 | 12 |
28667 | 28667 | 2020-04-03 | District of Columbia | District of Columbia | 11001 | 757 | 15 |
31025 | 31025 | 2020-04-04 | District of Columbia | District of Columbia | 11001 | 902 | 21 |
33431 | 33431 | 2020-04-05 | District of Columbia | District of Columbia | 11001 | 998 | 22 |
35876 | 35876 | 2020-04-06 | District of Columbia | District of Columbia | 11001 | 1097 | 24 |
38366 | 38366 | 2020-04-07 | District of Columbia | District of Columbia | 11001 | 1211 | 24 |
40909 | 40909 | 2020-04-08 | District of Columbia | District of Columbia | 11001 | 1440 | 27 |
43483 | 43483 | 2020-04-09 | District of Columbia | District of Columbia | 11001 | 1523 | 32 |
46084 | 46084 | 2020-04-10 | District of Columbia | District of Columbia | 11001 | 1660 | 38 |
48714 | 48714 | 2020-04-11 | District of Columbia | District of Columbia | 11001 | 1778 | 47 |
51375 | 51375 | 2020-04-12 | District of Columbia | District of Columbia | 11001 | 1875 | 50 |
54055 | 54055 | 2020-04-13 | District of Columbia | District of Columbia | 11001 | 1955 | 52 |
56747 | 56747 | 2020-04-14 | District of Columbia | District of Columbia | 11001 | 2058 | 67 |
59455 | 59455 | 2020-04-15 | District of Columbia | District of Columbia | 11001 | 2197 | 72 |
62174 | 62174 | 2020-04-16 | District of Columbia | District of Columbia | 11001 | 2350 | 81 |
64907 | 64907 | 2020-04-17 | District of Columbia | District of Columbia | 11001 | 2476 | 86 |
67655 | 67655 | 2020-04-18 | District of Columbia | District of Columbia | 11001 | 2666 | 91 |
70417 | 70417 | 2020-04-19 | District of Columbia | District of Columbia | 11001 | 2793 | 96 |
73186 | 73186 | 2020-04-20 | District of Columbia | District of Columbia | 11001 | 2927 | 105 |
75962 | 75962 | 2020-04-21 | District of Columbia | District of Columbia | 11001 | 3098 | 112 |
78746 | 78746 | 2020-04-22 | District of Columbia | District of Columbia | 11001 | 3206 | 127 |
81540 | 81540 | 2020-04-23 | District of Columbia | District of Columbia | 11001 | 3361 | 139 |
84340 | 84340 | 2020-04-24 | District of Columbia | District of Columbia | 11001 | 3528 | 153 |
87148 | 87148 | 2020-04-25 | District of Columbia | District of Columbia | 11001 | 3699 | 165 |
89965 | 89965 | 2020-04-26 | District of Columbia | District of Columbia | 11001 | 3841 | 178 |
92783 | 92783 | 2020-04-27 | District of Columbia | District of Columbia | 11001 | 3892 | 185 |
95615 | 95615 | 2020-04-28 | District of Columbia | District of Columbia | 11001 | 3994 | 190 |
98460 | 98460 | 2020-04-29 | District of Columbia | District of Columbia | 11001 | 4106 | 205 |
101310 | 101310 | 2020-04-30 | District of Columbia | District of Columbia | 11001 | 4323 | 224 |
104165 | 104165 | 2020-05-01 | District of Columbia | District of Columbia | 11001 | 4658 | 231 |
107030 | 107030 | 2020-05-02 | District of Columbia | District of Columbia | 11001 | 4797 | 240 |
109899 | 109899 | 2020-05-03 | District of Columbia | District of Columbia | 11001 | 5016 | 251 |
112774 | 112774 | 2020-05-04 | District of Columbia | District of Columbia | 11001 | 5170 | 258 |
115657 | 115657 | 2020-05-05 | District of Columbia | District of Columbia | 11001 | 5322 | 264 |
118617 | 118617 | 2020-05-06 | District of Columbia | District of Columbia | 11001 | 5461 | 277 |
121586 | 121586 | 2020-05-07 | District of Columbia | District of Columbia | 11001 | 5654 | 285 |
124565 | 124565 | 2020-05-08 | District of Columbia | District of Columbia | 11001 | 5899 | 304 |
127552 | 127552 | 2020-05-09 | District of Columbia | District of Columbia | 11001 | 6102 | 311 |
130543 | 130543 | 2020-05-10 | District of Columbia | District of Columbia | 11001 | 6272 | 323 |
133534 | 133534 | 2020-05-11 | District of Columbia | District of Columbia | 11001 | 6389 | 328 |
136523 | 136523 | 2020-05-12 | District of Columbia | District of Columbia | 11001 | 6485 | 336 |
139514 | 139514 | 2020-05-13 | District of Columbia | District of Columbia | 11001 | 6584 | 350 |
142510 | 142510 | 2020-05-14 | District of Columbia | District of Columbia | 11001 | 6736 | 358 |
145510 | 145510 | 2020-05-15 | District of Columbia | District of Columbia | 11001 | 6871 | 368 |
148513 | 148513 | 2020-05-16 | District of Columbia | District of Columbia | 11001 | 7042 | 375 |
151522 | 151522 | 2020-05-17 | District of Columbia | District of Columbia | 11001 | 7123 | 383 |
154534 | 154534 | 2020-05-18 | District of Columbia | District of Columbia | 11001 | 7270 | 392 |
157550 | 157550 | 2020-05-19 | District of Columbia | District of Columbia | 11001 | 7434 | 400 |
160576 | 160576 | 2020-05-20 | District of Columbia | District of Columbia | 11001 | 7551 | 407 |
163604 | 163604 | 2020-05-21 | District of Columbia | District of Columbia | 11001 | 7788 | 412 |
166637 | 166637 | 2020-05-22 | District of Columbia | District of Columbia | 11001 | 7893 | 418 |
169674 | 169674 | 2020-05-23 | District of Columbia | District of Columbia | 11001 | 7966 | 427 |
172715 | 172715 | 2020-05-24 | District of Columbia | District of Columbia | 11001 | 8110 | 432 |
175758 | 175758 | 2020-05-25 | District of Columbia | District of Columbia | 11001 | 8225 | 440 |
178802 | 178802 | 2020-05-26 | District of Columbia | District of Columbia | 11001 | 8334 | 440 |
181846 | 181846 | 2020-05-27 | District of Columbia | District of Columbia | 11001 | 8406 | 445 |
184900 | 184900 | 2020-05-28 | District of Columbia | District of Columbia | 11001 | 8492 | 453 |
187956 | 187956 | 2020-05-29 | District of Columbia | District of Columbia | 11001 | 8538 | 460 |
191021 | 191021 | 2020-05-30 | District of Columbia | District of Columbia | 11001 | 8717 | 462 |
194088 | 194088 | 2020-05-31 | District of Columbia | District of Columbia | 11001 | 8801 | 466 |
197158 | 197158 | 2020-06-01 | District of Columbia | District of Columbia | 11001 | 8857 | 468 |
200231 | 200231 | 2020-06-02 | District of Columbia | District of Columbia | 11001 | 8886 | 470 |
203307 | 203307 | 2020-06-03 | District of Columbia | District of Columbia | 11001 | 9016 | 473 |
206387 | 206387 | 2020-06-04 | District of Columbia | District of Columbia | 11001 | 9120 | 475 |
209468 | 209468 | 2020-06-05 | District of Columbia | District of Columbia | 11001 | 9199 | 479 |
212553 | 212553 | 2020-06-06 | District of Columbia | District of Columbia | 11001 | 9269 | 483 |
215640 | 215640 | 2020-06-07 | District of Columbia | District of Columbia | 11001 | 9332 | 489 |
218731 | 218731 | 2020-06-08 | District of Columbia | District of Columbia | 11001 | 9389 | 491 |
221826 | 221826 | 2020-06-09 | District of Columbia | District of Columbia | 11001 | 9474 | 495 |
224921 | 224921 | 2020-06-10 | District of Columbia | District of Columbia | 11001 | 9537 | 499 |
228023 | 228023 | 2020-06-11 | District of Columbia | District of Columbia | 11001 | 9589 | 502 |
231126 | 231126 | 2020-06-12 | District of Columbia | District of Columbia | 11001 | 9654 | 506 |
234232 | 234232 | 2020-06-13 | District of Columbia | District of Columbia | 11001 | 9709 | 511 |
237339 | 237339 | 2020-06-14 | District of Columbia | District of Columbia | 11001 | 9767 | 515 |
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);