ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 49005 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 599 ✖
- 43 7
- 37080 7
- 37095 7
- 40 6
- 2 5
- 28678 5
- 37113 5
- 36 4
- 16608 4
- 16712 4
- 16888 4
- 17492 4
- 18356 4
- 19289 4
- 19815 4
- 20690 4
- 21061 4
- 21944 4
- 22330 4
- 22715 4
- 23940 4
- 24702 4
- 26686 4
- 32233 4
- 36733 4
- 36940 4
- 36984 4
- 37159 4
- 37203 4
- 5 3
- 44 3
- 16025 3
- 16667 3
- 17111 3
- 17325 3
- 17728 3
- 18001 3
- 18803 3
- 20220 3
- 21530 3
- 23218 3
- 23592 3
- 24236 3
- 24492 3
- 25185 3
- 34747 3
- 35870 3
- 36428 3
- 36885 3
- 37024 3
- 37066 3
- 37142 3
- 37152 3
- 3 2
- 4 2
- 7 2
- 15 2
- 30 2
- 41 2
- 45 2
- 51 2
- 59 2
- 60 2
- 63 2
- 64 2
- 72 2
- 77 2
- 1620 2
- 2044 2
- 6062 2
- 10539 2
- 11167 2
- 15813 2
- 15883 2
- 16205 2
- 16251 2
- 16328 2
- 16496 2
- 16753 2
- 19118 2
- 21330 2
- 21815 2
- 22517 2
- 22969 2
- 23483 2
- 23724 2
- 25077 2
- 25533 2
- 27490 2
- 37127 2
- 37192 2
- 37265 2
- 6 1
- 10 1
- 19 1
- 20 1
- 23 1
- 28 1
- 29 1
- 33 1
- 38 1
- 58 1
- 61 1
- 74 1
- 78 1
- 79 1
- 89 1
- 111 1
- 142 1
- 179 1
- 219 1
- 238 1
- 268 1
- 310 1
- 329 1
- 514 1
- 709 1
- 731 1
- 773 1
- 805 1
- 861 1
- 913 1
- 939 1
- 966 1
- 982 1
- 1020 1
- 1060 1
- 1087 1
- 1136 1
- 1205 1
- 1245 1
- 1283 1
- 1301 1
- 1317 1
- 1328 1
- 1357 1
- 1389 1
- 1400 1
- 1426 1
- 1445 1
- 1453 1
- 1470 1
- 1477 1
- 1499 1
- 1521 1
- 1532 1
- 1540 1
- 1557 1
- 1571 1
- 1582 1
- 1605 1
- 1632 1
- 1640 1
- 1650 1
- 1654 1
- 1656 1
- 1657 1
- 1658 1
- 1663 1
- 1681 1
- 1685 1
- 1706 1
- 1736 1
- 1751 1
- 1758 1
- 1764 1
- 1770 1
- 1790 1
- 1798 1
- 1805 1
- 1809 1
- 1828 1
- 1833 1
- 1857 1
- 1872 1
- 1886 1
- 1908 1
- 1911 1
- 1926 1
- 1937 1
- 1943 1
- 1950 1
- 1960 1
- 1965 1
- 1971 1
- 1973 1
- 1974 1
- 1982 1
- 1993 1
- 2005 1
- 2017 1
- 2046 1
- 2054 1
- 2068 1
- 2078 1
- 2088 1
- 2097 1
- 2109 1
- 2114 1
- 2119 1
- 2143 1
- 2182 1
- 2184 1
- 2194 1
- 2202 1
- 2217 1
- 2225 1
- 2232 1
- 2260 1
- 2301 1
- 2321 1
- 2346 1
- 2365 1
- 2389 1
- 2422 1
- 2442 1
- 2501 1
- 2536 1
- 2557 1
- 2573 1
- 2598 1
- 2635 1
- 2659 1
- 2695 1
- 2728 1
- 2736 1
- 2762 1
- 2785 1
- 2803 1
- 2854 1
- 2895 1
- 2929 1
- 2992 1
- 3025 1
- 3053 1
- 3122 1
- 3170 1
- 3202 1
- 3255 1
- 3288 1
- 3343 1
- 3376 1
- 3459 1
- 3509 1
- 3560 1
- 3609 1
- 3677 1
- 3703 1
- 3738 1
- 3790 1
- 3851 1
- 3940 1
- 3998 1
- 4044 1
- 4077 1
- 4125 1
- 4209 1
- 4277 1
- 4343 1
- 4422 1
- 4458 1
- 4479 1
- 4498 1
- 4615 1
- 4682 1
- 4772 1
- 4874 1
- 4975 1
- 5041 1
- 5078 1
- 5231 1
- 5380 1
- 5560 1
- 5811 1
- 5909 1
- 6235 1
- 6456 1
- 6637 1
- 6886 1
- 6990 1
- 7095 1
- 7165 1
- 7262 1
- 7444 1
- 7550 1
- 7655 1
- 7698 1
- 7808 1
- 7920 1
- 8091 1
- 8247 1
- 8416 1
- 8567 1
- 8682 1
- 8760 1
- 8829 1
- 8913 1
- 9067 1
- 9136 1
- 9325 1
- 9396 1
- 9491 1
- 9565 1
- 9720 1
- 9908 1
- 10026 1
- 10150 1
- 10201 1
- 10279 1
- 10355 1
- 10454 1
- 10700 1
- 10723 1
- 10790 1
- 10887 1
- 10967 1
- 11351 1
- 11417 1
- 11500 1
- 11620 1
- 11807 1
- 11941 1
- 12065 1
- 12144 1
- 12211 1
- 12239 1
- 12289 1
- 12471 1
- 12578 1
- 12727 1
- 12815 1
- 12867 1
- 12898 1
- 12925 1
- 13025 1
- 13128 1
- 13247 1
- 13314 1
- 13382 1
- 13408 1
- 13476 1
- 13581 1
- 13642 1
- 13704 1
- 13765 1
- 13804 1
- 13824 1
- 13879 1
- 13980 1
- 14024 1
- 14072 1
- 14144 1
- 14163 1
- 14174 1
- 14234 1
- 14276 1
- 14324 1
- 14378 1
- 14419 1
- 14455 1
- 14465 1
- 14485 1
- 14521 1
- 14560 1
- 14614 1
- 14648 1
- 14686 1
- 14700 1
- 14723 1
- 14760 1
- 14808 1
- 14818 1
- 14836 1
- 14853 1
- 14865 1
- 14880 1
- 14901 1
- 14926 1
- 14951 1
- 14971 1
- 14991 1
- 15004 1
- 15038 1
- 15063 1
- 15098 1
- 15137 1
- 15166 1
- 15194 1
- 15208 1
- 15222 1
- 15263 1
- 15284 1
- 15298 1
- 15322 1
- 15342 1
- 15351 1
- 15367 1
- 15400 1
- 15426 1
- 15441 1
- 15458 1
- 15470 1
- 15480 1
- 15497 1
- 15524 1
- 15553 1
- 15563 1
- 15571 1
- 15599 1
- 15601 1
- 15608 1
- 15621 1
- 15645 1
- 15665 1
- 15680 1
- 15693 1
- 15696 1
- 15718 1
- 15766 1
- 15786 1
- 15803 1
- 15831 1
- 15837 1
- 15928 1
- 15938 1
- 15939 1
- 15946 1
- 15953 1
- 15961 1
- 15973 1
- 15986 1
- 16007 1
- 16021 1
- 16049 1
- 16071 1
- 16083 1
- 16091 1
- 16102 1
- 16108 1
- 16128 1
- 16142 1
- 16156 1
- 16164 1
- 16174 1
- 16181 1
- 16188 1
- 16219 1
- 16227 1
- 16231 1
- 16237 1
- 16242 1
- 16269 1
- 16278 1
- 16285 1
- 16290 1
- 16296 1
- 16302 1
- 16318 1
- 16354 1
- 16362 1
- 16368 1
- 16379 1
- 16388 1
- 16398 1
- 16422 1
- 16430 1
- 16436 1
- 16440 1
- 16451 1
- 16460 1
- 16465 1
- 16472 1
- 16480 1
- 16483 1
- 16485 1
- 16514 1
- 16529 1
- 16545 1
- 16557 1
- 16567 1
- 16583 1
- 16595 1
- 16641 1
- 16648 1
- 16657 1
- 16695 1
- 16806 1
- 16822 1
- 16854 1
- 16962 1
- 16969 1
- 16989 1
- 17066 1
- 17186 1
- 17209 1
- 17237 1
- 17299 1
- 17408 1
- 17428 1
- 17453 1
- 17478 1
- 17595 1
- 17650 1
- 17688 1
- 17834 1
- 17855 1
- 17898 1
- 17958 1
- 18118 1
- 18160 1
- 18237 1
- 18283 1
- 18565 1
- 18614 1
- 18710 1
- 18999 1
- 19040 1
- 19592 1
- 19658 1
- 19740 1
- 19996 1
- 20067 1
- 20138 1
- 20378 1
- 20432 1
- 20551 1
- 20615 1
- 20883 1
- 20960 1
- 20998 1
- 21278 1
- 21680 1
- 21731 1
- 22082 1
- 22156 1
- 22266 1
- 22570 1
- 23146 1
- 23371 1
- 23390 1
- 23695 1
- 23879 1
- 24064 1
- 24105 1
- 24161 1
- 24343 1
- 24367 1
- 24418 1
- 24459 1
- 24570 1
- 24596 1
- 24658 1
- 24896 1
- 24943 1
- 25534 1
- 26464 1
- 28408 1
- 30947 1
- 31483 1
- 33712 1
- 34036 1
- 34388 1
- 35293 1
- 35346 1
- 35553 1
- 35712 1
- 36137 1
- 36179 1
- 36278 1
- 36353 1
- 36578 1
- 36602 1
- 36669 1
- 36698 1
- 36811 1
- 36835 1
- 36864 1
- 36911 1
- 36915 1
- 36926 1
- 36932 1
- 36965 1
- 36973 1
- 36978 1
- 37001 1
- 37014 1
- 37022 1
- 37030 1
- 37032 1
- 37037 1
- 37052 1
- 37069 1
- 37071 1
- 37074 1
- 37135 1
- 37187 1
- 37229 1
- 37241 1
- 37254 1
state 1
- Utah 787
fips 1
- 49005 · 787 ✖
county 1
- Cache 787
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4321 | 4321 | 2020-03-18 | Cache | Utah | 49005 | 2 | 0 |
5077 | 5077 | 2020-03-19 | Cache | Utah | 49005 | 2 | 0 |
5971 | 5971 | 2020-03-20 | Cache | Utah | 49005 | 2 | 0 |
6994 | 6994 | 2020-03-21 | Cache | Utah | 49005 | 2 | 0 |
8124 | 8124 | 2020-03-22 | Cache | Utah | 49005 | 2 | 0 |
9343 | 9343 | 2020-03-23 | Cache | Utah | 49005 | 3 | 0 |
10687 | 10687 | 2020-03-24 | Cache | Utah | 49005 | 3 | 0 |
12197 | 12197 | 2020-03-25 | Cache | Utah | 49005 | 4 | 0 |
13832 | 13832 | 2020-03-26 | Cache | Utah | 49005 | 4 | 0 |
15597 | 15597 | 2020-03-27 | Cache | Utah | 49005 | 5 | 0 |
17469 | 17469 | 2020-03-28 | Cache | Utah | 49005 | 5 | 0 |
19428 | 19428 | 2020-03-29 | Cache | Utah | 49005 | 5 | 0 |
21491 | 21491 | 2020-03-30 | Cache | Utah | 49005 | 6 | 0 |
23630 | 23630 | 2020-03-31 | Cache | Utah | 49005 | 7 | 0 |
25845 | 25845 | 2020-04-01 | Cache | Utah | 49005 | 7 | 0 |
28133 | 28133 | 2020-04-02 | Cache | Utah | 49005 | 10 | 0 |
30470 | 30470 | 2020-04-03 | Cache | Utah | 49005 | 15 | 0 |
32868 | 32868 | 2020-04-04 | Cache | Utah | 49005 | 15 | 0 |
35306 | 35306 | 2020-04-05 | Cache | Utah | 49005 | 19 | 0 |
37784 | 37784 | 2020-04-06 | Cache | Utah | 49005 | 20 | 0 |
40313 | 40313 | 2020-04-07 | Cache | Utah | 49005 | 23 | 0 |
42881 | 42881 | 2020-04-08 | Cache | Utah | 49005 | 28 | 0 |
45475 | 45475 | 2020-04-09 | Cache | Utah | 49005 | 29 | 0 |
48099 | 48099 | 2020-04-10 | Cache | Utah | 49005 | 30 | 0 |
50757 | 50757 | 2020-04-11 | Cache | Utah | 49005 | 30 | 0 |
53432 | 53432 | 2020-04-12 | Cache | Utah | 49005 | 33 | 0 |
56121 | 56121 | 2020-04-13 | Cache | Utah | 49005 | 36 | 0 |
58827 | 58827 | 2020-04-14 | Cache | Utah | 49005 | 36 | 0 |
61545 | 61545 | 2020-04-15 | Cache | Utah | 49005 | 36 | 0 |
64277 | 64277 | 2020-04-16 | Cache | Utah | 49005 | 36 | 0 |
67025 | 67025 | 2020-04-17 | Cache | Utah | 49005 | 38 | 0 |
69786 | 69786 | 2020-04-18 | Cache | Utah | 49005 | 40 | 0 |
72556 | 72556 | 2020-04-19 | Cache | Utah | 49005 | 40 | 0 |
75332 | 75332 | 2020-04-20 | Cache | Utah | 49005 | 40 | 0 |
78114 | 78114 | 2020-04-21 | Cache | Utah | 49005 | 40 | 0 |
80906 | 80906 | 2020-04-22 | Cache | Utah | 49005 | 40 | 0 |
83707 | 83707 | 2020-04-23 | Cache | Utah | 49005 | 40 | 0 |
86514 | 86514 | 2020-04-24 | Cache | Utah | 49005 | 41 | 0 |
89329 | 89329 | 2020-04-25 | Cache | Utah | 49005 | 41 | 0 |
92146 | 92146 | 2020-04-26 | Cache | Utah | 49005 | 43 | 0 |
94975 | 94975 | 2020-04-27 | Cache | Utah | 49005 | 43 | 0 |
97817 | 97817 | 2020-04-28 | Cache | Utah | 49005 | 43 | 0 |
100667 | 100667 | 2020-04-29 | Cache | Utah | 49005 | 43 | 0 |
103522 | 103522 | 2020-04-30 | Cache | Utah | 49005 | 43 | 0 |
106386 | 106386 | 2020-05-01 | Cache | Utah | 49005 | 43 | 0 |
109255 | 109255 | 2020-05-02 | Cache | Utah | 49005 | 43 | 0 |
112129 | 112129 | 2020-05-03 | Cache | Utah | 49005 | 44 | 0 |
115012 | 115012 | 2020-05-04 | Cache | Utah | 49005 | 44 | 0 |
117971 | 117971 | 2020-05-05 | Cache | Utah | 49005 | 44 | 0 |
120935 | 120935 | 2020-05-06 | Cache | Utah | 49005 | 45 | 0 |
123915 | 123915 | 2020-05-07 | Cache | Utah | 49005 | 45 | 0 |
126900 | 126900 | 2020-05-08 | Cache | Utah | 49005 | 51 | 0 |
129889 | 129889 | 2020-05-09 | Cache | Utah | 49005 | 51 | 0 |
132879 | 132879 | 2020-05-10 | Cache | Utah | 49005 | 58 | 0 |
135870 | 135870 | 2020-05-11 | Cache | Utah | 49005 | 59 | 0 |
138860 | 138860 | 2020-05-12 | Cache | Utah | 49005 | 59 | 0 |
141856 | 141856 | 2020-05-13 | Cache | Utah | 49005 | 60 | 0 |
144853 | 144853 | 2020-05-14 | Cache | Utah | 49005 | 60 | 0 |
147857 | 147857 | 2020-05-15 | Cache | Utah | 49005 | 61 | 0 |
150865 | 150865 | 2020-05-16 | Cache | Utah | 49005 | 63 | 0 |
153876 | 153876 | 2020-05-17 | Cache | Utah | 49005 | 63 | 0 |
156893 | 156893 | 2020-05-18 | Cache | Utah | 49005 | 64 | 0 |
159917 | 159917 | 2020-05-19 | Cache | Utah | 49005 | 64 | 0 |
162945 | 162945 | 2020-05-20 | Cache | Utah | 49005 | 72 | 0 |
165974 | 165974 | 2020-05-21 | Cache | Utah | 49005 | 72 | 0 |
169010 | 169010 | 2020-05-22 | Cache | Utah | 49005 | 74 | 0 |
172051 | 172051 | 2020-05-23 | Cache | Utah | 49005 | 77 | 0 |
175094 | 175094 | 2020-05-24 | Cache | Utah | 49005 | 77 | 0 |
178139 | 178139 | 2020-05-25 | Cache | Utah | 49005 | 78 | 1 |
181183 | 181183 | 2020-05-26 | Cache | Utah | 49005 | 79 | 1 |
184234 | 184234 | 2020-05-27 | Cache | Utah | 49005 | 89 | 1 |
187291 | 187291 | 2020-05-28 | Cache | Utah | 49005 | 111 | 1 |
190355 | 190355 | 2020-05-29 | Cache | Utah | 49005 | 142 | 1 |
193421 | 193421 | 2020-05-30 | Cache | Utah | 49005 | 179 | 1 |
196491 | 196491 | 2020-05-31 | Cache | Utah | 49005 | 219 | 1 |
199564 | 199564 | 2020-06-01 | Cache | Utah | 49005 | 238 | 1 |
202640 | 202640 | 2020-06-02 | Cache | Utah | 49005 | 268 | 1 |
205719 | 205719 | 2020-06-03 | Cache | Utah | 49005 | 310 | 1 |
208801 | 208801 | 2020-06-04 | Cache | Utah | 49005 | 329 | 1 |
211886 | 211886 | 2020-06-05 | Cache | Utah | 49005 | 514 | 1 |
214973 | 214973 | 2020-06-06 | Cache | Utah | 49005 | 709 | 1 |
218063 | 218063 | 2020-06-07 | Cache | Utah | 49005 | 731 | 1 |
221155 | 221155 | 2020-06-08 | Cache | Utah | 49005 | 773 | 1 |
224251 | 224251 | 2020-06-09 | Cache | Utah | 49005 | 805 | 1 |
227351 | 227351 | 2020-06-10 | Cache | Utah | 49005 | 861 | 1 |
230455 | 230455 | 2020-06-11 | Cache | Utah | 49005 | 913 | 1 |
233559 | 233559 | 2020-06-12 | Cache | Utah | 49005 | 939 | 1 |
236666 | 236666 | 2020-06-13 | Cache | Utah | 49005 | 966 | 1 |
239774 | 239774 | 2020-06-14 | Cache | Utah | 49005 | 982 | 1 |
242885 | 242885 | 2020-06-15 | Cache | Utah | 49005 | 1020 | 1 |
245997 | 245997 | 2020-06-16 | Cache | Utah | 49005 | 1060 | 1 |
249110 | 249110 | 2020-06-17 | Cache | Utah | 49005 | 1087 | 1 |
252225 | 252225 | 2020-06-18 | Cache | Utah | 49005 | 1136 | 1 |
255342 | 255342 | 2020-06-19 | Cache | Utah | 49005 | 1205 | 1 |
258469 | 258469 | 2020-06-20 | Cache | Utah | 49005 | 1245 | 1 |
261596 | 261596 | 2020-06-21 | Cache | Utah | 49005 | 1283 | 1 |
264725 | 264725 | 2020-06-22 | Cache | Utah | 49005 | 1301 | 1 |
267854 | 267854 | 2020-06-23 | Cache | Utah | 49005 | 1317 | 1 |
270988 | 270988 | 2020-06-24 | Cache | Utah | 49005 | 1328 | 1 |
274128 | 274128 | 2020-06-25 | Cache | Utah | 49005 | 1357 | 1 |
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);