ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 9001 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 590 ✖
- 19031 4
- 53101 4
- 99995 4
- 100549 4
- 106587 4
- 111001 4
- 128883 4
- 140261 4
- 16757 3
- 16906 3
- 17069 3
- 17421 3
- 17793 3
- 17956 3
- 18160 3
- 18434 3
- 18774 3
- 19360 3
- 19716 3
- 20015 3
- 20400 3
- 20752 3
- 21368 3
- 22322 3
- 24155 3
- 26435 3
- 29842 3
- 33648 3
- 37071 3
- 41535 3
- 46615 3
- 50614 3
- 61285 3
- 65725 3
- 69065 3
- 72026 3
- 74404 3
- 76511 3
- 78181 3
- 80243 3
- 81783 3
- 83303 3
- 85225 3
- 87890 3
- 90537 3
- 92953 3
- 95372 3
- 97049 3
- 98131 3
- 98965 3
- 99495 3
- 99788 3
- 100155 3
- 100257 3
- 100333 3
- 100430 3
- 100653 3
- 100816 3
- 101119 3
- 101695 3
- 102594 3
- 103462 3
- 104480 3
- 105657 3
- 107404 3
- 109004 3
- 109675 3
- 110458 3
- 111615 3
- 112149 3
- 112576 3
- 112972 3
- 113415 3
- 114474 3
- 115582 3
- 116976 3
- 119682 3
- 123222 3
- 159269 3
- 178205 3
- 186231 3
- 192393 3
- 194725 3
- 196221 3
- 197325 3
- 197958 3
- 198583 3
- 199851 3
- 200481 3
- 201183 3
- 202314 3
- 203593 3
- 205283 3
- 207102 3
- 208790 3
- 210830 3
- 2 2
- 11801 2
- 20587 2
- 36037 2
- 56288 2
- 57467 2
- 115148 2
- 1 1
- 3 1
- 5 1
- 8 1
- 15 1
- 16 1
- 29 1
- 48 1
- 69 1
- 102 1
- 122 1
- 140 1
- 208 1
- 270 1
- 384 1
- 546 1
- 607 1
- 752 1
- 908 1
- 1245 1
- 1445 1
- 1870 1
- 1986 1
- 2132 1
- 2717 1
- 2824 1
- 3050 1
- 3719 1
- 4136 1
- 4417 1
- 4882 1
- 5180 1
- 5407 1
- 5534 1
- 6004 1
- 6213 1
- 6480 1
- 6816 1
- 7146 1
- 7363 1
- 7434 1
- 8320 1
- 8472 1
- 9883 1
- 10008 1
- 10227 1
- 10373 1
- 10529 1
- 10763 1
- 10874 1
- 10985 1
- 11294 1
- 11612 1
- 12245 1
- 12360 1
- 12455 1
- 12679 1
- 12879 1
- 13030 1
- 13236 1
- 13312 1
- 13488 1
- 13636 1
- 13836 1
- 14009 1
- 14140 1
- 14248 1
- 14439 1
- 14522 1
- 14719 1
- 14751 1
- 14889 1
- 14989 1
- 15114 1
- 15213 1
- 15314 1
- 15353 1
- 15355 1
- 15409 1
- 15502 1
- 15549 1
- 15709 1
- 15776 1
- 15789 1
- 15843 1
- 15914 1
- 16020 1
- 16056 1
- 16092 1
- 16108 1
- 16134 1
- 16155 1
- 16178 1
- 16277 1
- 16306 1
- 16338 1
- 16359 1
- 16381 1
- 16398 1
- 16425 1
- 16469 1
- 16475 1
- 16483 1
- 16522 1
- 16527 1
- 16547 1
- 16564 1
- 16606 1
- 16633 1
- 16664 1
- 16703 1
- 16717 1
- 16733 1
- 16823 1
- 16837 1
- 16859 1
- 16886 1
- 16954 1
- 16960 1
- 16993 1
- 17027 1
- 17112 1
- 17123 1
- 17164 1
- 17184 1
- 17459 1
- 17494 1
- 17733 1
- 17786 1
- 17870 1
- 17876 1
- 17912 1
- 17926 1
- 18035 1
- 18081 1
- 18088 1
- 18126 1
- 18317 1
- 18322 1
- 18347 1
- 18401 1
- 18605 1
- 18622 1
- 18667 1
- 18721 1
- 18903 1
- 18939 1
- 18965 1
- 18995 1
- 19135 1
- 19159 1
- 19260 1
- 19518 1
- 19558 1
- 19611 1
- 19678 1
- 19848 1
- 19891 1
- 19949 1
- 19985 1
- 20141 1
- 20190 1
- 20225 1
- 20264 1
- 20612 1
- 20701 1
- 21052 1
- 21104 1
- 21128 1
- 21183 1
- 21674 1
- 21754 1
- 21898 1
- 22088 1
- 22893 1
- 23090 1
- 23280 1
- 23895 1
- 25048 1
- 25365 1
- 25538 1
- 26120 1
- 27652 1
- 28178 1
- 28731 1
- 29008 1
- 31212 1
- 31773 1
- 32369 1
- 33067 1
- 35272 1
- 35494 1
- 38305 1
- 38756 1
- 39773 1
- 41062 1
- 43840 1
- 44376 1
- 44980 1
- 45509 1
- 48308 1
- 48879 1
- 49422 1
- 50036 1
- 51717 1
- 52080 1
- 52574 1
- 55037 1
- 55253 1
- 55645 1
- 58431 1
- 58959 1
- 59565 1
- 60396 1
- 63073 1
- 64066 1
- 65000 1
- 65226 1
- 67081 1
- 67617 1
- 68079 1
- 68512 1
- 70347 1
- 70766 1
- 71416 1
- 71697 1
- 72987 1
- 73651 1
- 73762 1
- 74033 1
- 75471 1
- 75752 1
- 76010 1
- 76266 1
- 77266 1
- 77457 1
- 77597 1
- 77794 1
- 78803 1
- 79237 1
- 79710 1
- 80011 1
- 81025 1
- 81181 1
- 81312 1
- 81558 1
- 82350 1
- 82621 1
- 82772 1
- 82981 1
- 84130 1
- 84401 1
- 84510 1
- 84837 1
- 86134 1
- 86392 1
- 86878 1
- 87366 1
- 88876 1
- 89346 1
- 89598 1
- 90096 1
- 91364 1
- 91622 1
- 91935 1
- 92269 1
- 93979 1
- 94341 1
- 94841 1
- 95011 1
- 96083 1
- 96334 1
- 96586 1
- 96797 1
- 97641 1
- 97724 1
- 97853 1
- 97948 1
- 98443 1
- 98503 1
- 98651 1
- 98850 1
- 99161 1
- 99238 1
- 99275 1
- 99436 1
- 99646 1
- 99667 1
- 99703 1
- 99736 1
- 99867 1
- 99903 1
- 99916 1
- 99951 1
- 100048 1
- 100082 1
- 100093 1
- 100188 1
- 100200 1
- 100226 1
- 100247 1
- 100293 1
- 100308 1
- 100318 1
- 100319 1
- 100357 1
- 100381 1
- 100388 1
- 100408 1
- 100492 1
- 100498 1
- 100516 1
- 100529 1
- 100573 1
- 100603 1
- 100619 1
- 100670 1
- 100729 1
- 100760 1
- 100790 1
- 100919 1
- 100956 1
- 101024 1
- 101086 1
- 101256 1
- 101416 1
- 101507 1
- 101575 1
- 101975 1
- 102136 1
- 102265 1
- 102430 1
- 102873 1
- 102951 1
- 103154 1
- 103326 1
- 103849 1
- 104091 1
- 104252 1
- 104359 1
- 104837 1
- 105111 1
- 105279 1
- 105493 1
- 105960 1
- 106173 1
- 106300 1
- 106458 1
- 106924 1
- 107113 1
- 107273 1
- 107683 1
- 107840 1
- 107929 1
- 108321 1
- 109270 1
- 109346 1
- 109448 1
- 109589 1
- 109999 1
- 110105 1
- 110235 1
- 110289 1
- 110643 1
- 110735 1
- 110809 1
- 110901 1
- 111333 1
- 111386 1
- 111545 1
- 111812 1
- 111942 1
- 111988 1
- 112061 1
- 112283 1
- 112345 1
- 112387 1
- 112494 1
- 112708 1
- 112783 1
- 112852 1
- 112921 1
- 113081 1
- 113125 1
- 113222 1
- 113337 1
- 113869 1
- 113993 1
- 114149 1
- 114301 1
- 114835 1
- 114991 1
- 116031 1
- 116232 1
- 116384 1
- 116752 1
- 118151 1
- 118422 1
- 118652 1
- 119156 1
- 121457 1
- 122075 1
- 122366 1
- 122906 1
- 125013 1
- 126561 1
- 127699 1
- 134225 1
- 135622 1
- 137944 1
- 148249 1
- 150957 1
- 153836 1
- 156761 1
- 169549 1
- 171407 1
- 173159 1
- 175775 1
- 181852 1
- 183127 1
- 184094 1
- 185326 1
- 189800 1
- 190640 1
- 191156 1
- 191808 1
- 193175 1
- 193441 1
- 193850 1
- 194466 1
- 195214 1
- 195518 1
- 195800 1
- 196035 1
- 196644 1
- 196835 1
- 196996 1
- 197116 1
- 197585 1
- 197661 1
- 197774 1
- 197830 1
- 198201 1
- 198268 1
- 198301 1
- 198498 1
- 199323 1
- 199642 1
- 199692 1
- 199775 1
- 200091 1
- 200186 1
- 200265 1
- 200403 1
- 200642 1
- 200786 1
- 200891 1
- 201048 1
- 201502 1
- 201596 1
- 201737 1
- 202152 1
- 202689 1
- 202854 1
- 203001 1
- 203279 1
- 204191 1
- 204516 1
- 204732 1
- 204868 1
- 205991 1
- 206262 1
- 206516 1
- 206776 1
- 207639 1
- 207943 1
- 208202 1
- 208537 1
- 209399 1
- 209878 1
- 210120 1
- 210521 1
- 212056 1
- 212518 1
- 213009 1
- 213432 1
- 214106 1
state 1
- Connecticut 797
fips 1
- 9001 · 797 ✖
county 1
- Fairfield 797
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
778 | 778 | 2020-03-08 | Fairfield | Connecticut | 9001 | 1 | 0 |
895 | 895 | 2020-03-09 | Fairfield | Connecticut | 9001 | 2 | 0 |
1030 | 1030 | 2020-03-10 | Fairfield | Connecticut | 9001 | 2 | 0 |
1198 | 1198 | 2020-03-11 | Fairfield | Connecticut | 9001 | 3 | 0 |
1406 | 1406 | 2020-03-12 | Fairfield | Connecticut | 9001 | 5 | 0 |
1672 | 1672 | 2020-03-13 | Fairfield | Connecticut | 9001 | 8 | 0 |
1992 | 1992 | 2020-03-14 | Fairfield | Connecticut | 9001 | 15 | 0 |
2374 | 2374 | 2020-03-15 | Fairfield | Connecticut | 9001 | 16 | 0 |
2809 | 2809 | 2020-03-16 | Fairfield | Connecticut | 9001 | 29 | 0 |
3291 | 3291 | 2020-03-17 | Fairfield | Connecticut | 9001 | 48 | 0 |
3846 | 3846 | 2020-03-18 | Fairfield | Connecticut | 9001 | 69 | 1 |
4509 | 4509 | 2020-03-19 | Fairfield | Connecticut | 9001 | 102 | 4 |
5287 | 5287 | 2020-03-20 | Fairfield | Connecticut | 9001 | 122 | 4 |
6214 | 6214 | 2020-03-21 | Fairfield | Connecticut | 9001 | 140 | 4 |
7250 | 7250 | 2020-03-22 | Fairfield | Connecticut | 9001 | 208 | 5 |
8396 | 8396 | 2020-03-23 | Fairfield | Connecticut | 9001 | 270 | 6 |
9641 | 9641 | 2020-03-24 | Fairfield | Connecticut | 9001 | 384 | 7 |
11015 | 11015 | 2020-03-25 | Fairfield | Connecticut | 9001 | 546 | 12 |
12563 | 12563 | 2020-03-26 | Fairfield | Connecticut | 9001 | 607 | 13 |
14232 | 14232 | 2020-03-27 | Fairfield | Connecticut | 9001 | 752 | 15 |
16016 | 16016 | 2020-03-28 | Fairfield | Connecticut | 9001 | 908 | 20 |
17908 | 17908 | 2020-03-29 | Fairfield | Connecticut | 9001 | 1245 | 21 |
19887 | 19887 | 2020-03-30 | Fairfield | Connecticut | 9001 | 1445 | 21 |
21964 | 21964 | 2020-03-31 | Fairfield | Connecticut | 9001 | 1870 | 38 |
24123 | 24123 | 2020-04-01 | Fairfield | Connecticut | 9001 | 1986 | 46 |
26353 | 26353 | 2020-04-02 | Fairfield | Connecticut | 9001 | 2132 | 65 |
28655 | 28655 | 2020-04-03 | Fairfield | Connecticut | 9001 | 2717 | 76 |
31013 | 31013 | 2020-04-04 | Fairfield | Connecticut | 9001 | 2824 | 86 |
33419 | 33419 | 2020-04-05 | Fairfield | Connecticut | 9001 | 3050 | 96 |
35864 | 35864 | 2020-04-06 | Fairfield | Connecticut | 9001 | 3719 | 101 |
38354 | 38354 | 2020-04-07 | Fairfield | Connecticut | 9001 | 4136 | 132 |
40897 | 40897 | 2020-04-08 | Fairfield | Connecticut | 9001 | 4417 | 155 |
43471 | 43471 | 2020-04-09 | Fairfield | Connecticut | 9001 | 4882 | 178 |
46071 | 46071 | 2020-04-10 | Fairfield | Connecticut | 9001 | 5180 | 203 |
48701 | 48701 | 2020-04-11 | Fairfield | Connecticut | 9001 | 5407 | 220 |
51363 | 51363 | 2020-04-12 | Fairfield | Connecticut | 9001 | 5534 | 248 |
54042 | 54042 | 2020-04-13 | Fairfield | Connecticut | 9001 | 6004 | 262 |
56734 | 56734 | 2020-04-14 | Fairfield | Connecticut | 9001 | 6213 | 287 |
59442 | 59442 | 2020-04-15 | Fairfield | Connecticut | 9001 | 6480 | 365 |
62161 | 62161 | 2020-04-16 | Fairfield | Connecticut | 9001 | 6816 | 406 |
64894 | 64894 | 2020-04-17 | Fairfield | Connecticut | 9001 | 7146 | 425 |
67642 | 67642 | 2020-04-18 | Fairfield | Connecticut | 9001 | 7363 | 432 |
70404 | 70404 | 2020-04-19 | Fairfield | Connecticut | 9001 | 7434 | 447 |
73173 | 73173 | 2020-04-20 | Fairfield | Connecticut | 9001 | 8320 | 512 |
75949 | 75949 | 2020-04-21 | Fairfield | Connecticut | 9001 | 8472 | 544 |
78733 | 78733 | 2020-04-22 | Fairfield | Connecticut | 9001 | 9883 | 584 |
81527 | 81527 | 2020-04-23 | Fairfield | Connecticut | 9001 | 10008 | 615 |
84327 | 84327 | 2020-04-24 | Fairfield | Connecticut | 9001 | 10227 | 662 |
87135 | 87135 | 2020-04-25 | Fairfield | Connecticut | 9001 | 10373 | 689 |
89952 | 89952 | 2020-04-26 | Fairfield | Connecticut | 9001 | 10529 | 707 |
92770 | 92770 | 2020-04-27 | Fairfield | Connecticut | 9001 | 10763 | 727 |
95602 | 95602 | 2020-04-28 | Fairfield | Connecticut | 9001 | 10874 | 747 |
98447 | 98447 | 2020-04-29 | Fairfield | Connecticut | 9001 | 10985 | 774 |
101297 | 101297 | 2020-04-30 | Fairfield | Connecticut | 9001 | 11294 | 810 |
104152 | 104152 | 2020-05-01 | Fairfield | Connecticut | 9001 | 11612 | 839 |
107017 | 107017 | 2020-05-02 | Fairfield | Connecticut | 9001 | 11801 | 865 |
109886 | 109886 | 2020-05-03 | Fairfield | Connecticut | 9001 | 11801 | 865 |
112761 | 112761 | 2020-05-04 | Fairfield | Connecticut | 9001 | 12245 | 910 |
115644 | 115644 | 2020-05-05 | Fairfield | Connecticut | 9001 | 12360 | 935 |
118604 | 118604 | 2020-05-06 | Fairfield | Connecticut | 9001 | 12455 | 952 |
121573 | 121573 | 2020-05-07 | Fairfield | Connecticut | 9001 | 12679 | 977 |
124553 | 124553 | 2020-05-08 | Fairfield | Connecticut | 9001 | 12879 | 1006 |
127539 | 127539 | 2020-05-09 | Fairfield | Connecticut | 9001 | 13030 | 1017 |
130530 | 130530 | 2020-05-10 | Fairfield | Connecticut | 9001 | 13236 | 1024 |
133521 | 133521 | 2020-05-11 | Fairfield | Connecticut | 9001 | 13312 | 1034 |
136510 | 136510 | 2020-05-12 | Fairfield | Connecticut | 9001 | 13488 | 1046 |
139501 | 139501 | 2020-05-13 | Fairfield | Connecticut | 9001 | 13636 | 1068 |
142497 | 142497 | 2020-05-14 | Fairfield | Connecticut | 9001 | 13836 | 1093 |
145497 | 145497 | 2020-05-15 | Fairfield | Connecticut | 9001 | 14009 | 1109 |
148500 | 148500 | 2020-05-16 | Fairfield | Connecticut | 9001 | 14140 | 1125 |
151509 | 151509 | 2020-05-17 | Fairfield | Connecticut | 9001 | 14248 | 1146 |
154521 | 154521 | 2020-05-18 | Fairfield | Connecticut | 9001 | 14439 | 1153 |
157537 | 157537 | 2020-05-19 | Fairfield | Connecticut | 9001 | 14522 | 1160 |
160563 | 160563 | 2020-05-20 | Fairfield | Connecticut | 9001 | 14719 | 1167 |
163591 | 163591 | 2020-05-21 | Fairfield | Connecticut | 9001 | 14751 | 1180 |
166624 | 166624 | 2020-05-22 | Fairfield | Connecticut | 9001 | 14889 | 1195 |
169661 | 169661 | 2020-05-23 | Fairfield | Connecticut | 9001 | 14989 | 1208 |
172702 | 172702 | 2020-05-24 | Fairfield | Connecticut | 9001 | 15114 | 1215 |
175745 | 175745 | 2020-05-25 | Fairfield | Connecticut | 9001 | 15213 | 1221 |
178789 | 178789 | 2020-05-26 | Fairfield | Connecticut | 9001 | 15355 | 1231 |
181833 | 181833 | 2020-05-27 | Fairfield | Connecticut | 9001 | 15314 | 1242 |
184887 | 184887 | 2020-05-28 | Fairfield | Connecticut | 9001 | 15353 | 1246 |
187943 | 187943 | 2020-05-29 | Fairfield | Connecticut | 9001 | 15409 | 1257 |
191008 | 191008 | 2020-05-30 | Fairfield | Connecticut | 9001 | 15502 | 1267 |
194075 | 194075 | 2020-05-31 | Fairfield | Connecticut | 9001 | 15549 | 1277 |
197145 | 197145 | 2020-06-01 | Fairfield | Connecticut | 9001 | 15709 | 1288 |
200218 | 200218 | 2020-06-02 | Fairfield | Connecticut | 9001 | 15776 | 1287 |
203294 | 203294 | 2020-06-03 | Fairfield | Connecticut | 9001 | 15789 | 1289 |
206374 | 206374 | 2020-06-04 | Fairfield | Connecticut | 9001 | 15843 | 1293 |
209455 | 209455 | 2020-06-05 | Fairfield | Connecticut | 9001 | 15914 | 1304 |
212540 | 212540 | 2020-06-06 | Fairfield | Connecticut | 9001 | 16020 | 1309 |
215627 | 215627 | 2020-06-07 | Fairfield | Connecticut | 9001 | 16056 | 1312 |
218718 | 218718 | 2020-06-08 | Fairfield | Connecticut | 9001 | 16092 | 1316 |
221813 | 221813 | 2020-06-09 | Fairfield | Connecticut | 9001 | 16108 | 1319 |
224908 | 224908 | 2020-06-10 | Fairfield | Connecticut | 9001 | 16134 | 1321 |
228010 | 228010 | 2020-06-11 | Fairfield | Connecticut | 9001 | 16155 | 1333 |
231113 | 231113 | 2020-06-12 | Fairfield | Connecticut | 9001 | 16178 | 1337 |
234219 | 234219 | 2020-06-13 | Fairfield | Connecticut | 9001 | 16277 | 1345 |
237326 | 237326 | 2020-06-14 | Fairfield | Connecticut | 9001 | 16306 | 1346 |
240434 | 240434 | 2020-06-15 | Fairfield | Connecticut | 9001 | 16338 | 1347 |
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);