ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
809 rows where fips = 49035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283584 | 283584 | 2020-06-28 | Salt Lake | Utah | 49035 | 10629 | 106 |
280438 | 280438 | 2020-06-27 | Salt Lake | Utah | 49035 | 10458 | 106 |
277290 | 277290 | 2020-06-26 | Salt Lake | Utah | 49035 | 10163 | 106 |
274142 | 274142 | 2020-06-25 | Salt Lake | Utah | 49035 | 9830 | 105 |
271002 | 271002 | 2020-06-24 | Salt Lake | Utah | 49035 | 9501 | 105 |
267868 | 267868 | 2020-06-23 | Salt Lake | Utah | 49035 | 9252 | 105 |
264739 | 264739 | 2020-06-22 | Salt Lake | Utah | 49035 | 9073 | 102 |
261610 | 261610 | 2020-06-21 | Salt Lake | Utah | 49035 | 8878 | 102 |
258483 | 258483 | 2020-06-20 | Salt Lake | Utah | 49035 | 8713 | 102 |
255356 | 255356 | 2020-06-19 | Salt Lake | Utah | 49035 | 8404 | 102 |
252239 | 252239 | 2020-06-18 | Salt Lake | Utah | 49035 | 8140 | 100 |
249124 | 249124 | 2020-06-17 | Salt Lake | Utah | 49035 | 7846 | 99 |
246011 | 246011 | 2020-06-16 | Salt Lake | Utah | 49035 | 7644 | 96 |
242899 | 242899 | 2020-06-15 | Salt Lake | Utah | 49035 | 7506 | 95 |
239788 | 239788 | 2020-06-14 | Salt Lake | Utah | 49035 | 7309 | 93 |
236680 | 236680 | 2020-06-13 | Salt Lake | Utah | 49035 | 7187 | 93 |
233573 | 233573 | 2020-06-12 | Salt Lake | Utah | 49035 | 6966 | 93 |
230468 | 230468 | 2020-06-11 | Salt Lake | Utah | 49035 | 6783 | 87 |
227364 | 227364 | 2020-06-10 | Salt Lake | Utah | 49035 | 6619 | 85 |
224264 | 224264 | 2020-06-09 | Salt Lake | Utah | 49035 | 6437 | 85 |
221168 | 221168 | 2020-06-08 | Salt Lake | Utah | 49035 | 6313 | 83 |
218076 | 218076 | 2020-06-07 | Salt Lake | Utah | 49035 | 6182 | 81 |
214986 | 214986 | 2020-06-06 | Salt Lake | Utah | 49035 | 6096 | 81 |
211899 | 211899 | 2020-06-05 | Salt Lake | Utah | 49035 | 5918 | 81 |
208814 | 208814 | 2020-06-04 | Salt Lake | Utah | 49035 | 5760 | 78 |
205732 | 205732 | 2020-06-03 | Salt Lake | Utah | 49035 | 5621 | 78 |
202653 | 202653 | 2020-06-02 | Salt Lake | Utah | 49035 | 5449 | 74 |
199577 | 199577 | 2020-06-01 | Salt Lake | Utah | 49035 | 5340 | 74 |
196504 | 196504 | 2020-05-31 | Salt Lake | Utah | 49035 | 5242 | 74 |
193434 | 193434 | 2020-05-30 | Salt Lake | Utah | 49035 | 5118 | 74 |
190368 | 190368 | 2020-05-29 | Salt Lake | Utah | 49035 | 4994 | 71 |
187304 | 187304 | 2020-05-28 | Salt Lake | Utah | 49035 | 4806 | 71 |
184247 | 184247 | 2020-05-27 | Salt Lake | Utah | 49035 | 4682 | 71 |
181196 | 181196 | 2020-05-26 | Salt Lake | Utah | 49035 | 4632 | 70 |
178152 | 178152 | 2020-05-25 | Salt Lake | Utah | 49035 | 4583 | 68 |
175107 | 175107 | 2020-05-24 | Salt Lake | Utah | 49035 | 4515 | 68 |
172064 | 172064 | 2020-05-23 | Salt Lake | Utah | 49035 | 4441 | 68 |
169023 | 169023 | 2020-05-22 | Salt Lake | Utah | 49035 | 4308 | 65 |
165987 | 165987 | 2020-05-21 | Salt Lake | Utah | 49035 | 4217 | 65 |
162958 | 162958 | 2020-05-20 | Salt Lake | Utah | 49035 | 4123 | 62 |
159930 | 159930 | 2020-05-19 | Salt Lake | Utah | 49035 | 4019 | 62 |
156906 | 156906 | 2020-05-18 | Salt Lake | Utah | 49035 | 3942 | 56 |
153889 | 153889 | 2020-05-17 | Salt Lake | Utah | 49035 | 3883 | 56 |
150878 | 150878 | 2020-05-16 | Salt Lake | Utah | 49035 | 3785 | 55 |
147870 | 147870 | 2020-05-15 | Salt Lake | Utah | 49035 | 3717 | 55 |
144866 | 144866 | 2020-05-14 | Salt Lake | Utah | 49035 | 3609 | 52 |
141869 | 141869 | 2020-05-13 | Salt Lake | Utah | 49035 | 3530 | 52 |
138873 | 138873 | 2020-05-12 | Salt Lake | Utah | 49035 | 3425 | 51 |
135883 | 135883 | 2020-05-11 | Salt Lake | Utah | 49035 | 3370 | 48 |
132892 | 132892 | 2020-05-10 | Salt Lake | Utah | 49035 | 3291 | 44 |
129902 | 129902 | 2020-05-09 | Salt Lake | Utah | 49035 | 3206 | 44 |
126913 | 126913 | 2020-05-08 | Salt Lake | Utah | 49035 | 3104 | 39 |
123928 | 123928 | 2020-05-07 | Salt Lake | Utah | 49035 | 3010 | 39 |
120947 | 120947 | 2020-05-06 | Salt Lake | Utah | 49035 | 2919 | 38 |
117983 | 117983 | 2020-05-05 | Salt Lake | Utah | 49035 | 2832 | 35 |
115024 | 115024 | 2020-05-04 | Salt Lake | Utah | 49035 | 2769 | 31 |
112141 | 112141 | 2020-05-03 | Salt Lake | Utah | 49035 | 2707 | 31 |
109267 | 109267 | 2020-05-02 | Salt Lake | Utah | 49035 | 2609 | 30 |
106398 | 106398 | 2020-05-01 | Salt Lake | Utah | 49035 | 2526 | 30 |
103534 | 103534 | 2020-04-30 | Salt Lake | Utah | 49035 | 2438 | 29 |
100679 | 100679 | 2020-04-29 | Salt Lake | Utah | 49035 | 2348 | 28 |
97829 | 97829 | 2020-04-28 | Salt Lake | Utah | 49035 | 2256 | 28 |
94987 | 94987 | 2020-04-27 | Salt Lake | Utah | 49035 | 2190 | 24 |
92158 | 92158 | 2020-04-26 | Salt Lake | Utah | 49035 | 2144 | 25 |
89341 | 89341 | 2020-04-25 | Salt Lake | Utah | 49035 | 2051 | 25 |
86526 | 86526 | 2020-04-24 | Salt Lake | Utah | 49035 | 1975 | 23 |
83719 | 83719 | 2020-04-23 | Salt Lake | Utah | 49035 | 1889 | 20 |
80918 | 80918 | 2020-04-22 | Salt Lake | Utah | 49035 | 1795 | 19 |
78126 | 78126 | 2020-04-21 | Salt Lake | Utah | 49035 | 1714 | 18 |
75344 | 75344 | 2020-04-20 | Salt Lake | Utah | 49035 | 1671 | 15 |
72568 | 72568 | 2020-04-19 | Salt Lake | Utah | 49035 | 1615 | 15 |
69798 | 69798 | 2020-04-18 | Salt Lake | Utah | 49035 | 1547 | 13 |
67037 | 67037 | 2020-04-17 | Salt Lake | Utah | 49035 | 1456 | 12 |
64289 | 64289 | 2020-04-16 | Salt Lake | Utah | 49035 | 1377 | 12 |
61557 | 61557 | 2020-04-15 | Salt Lake | Utah | 49035 | 1285 | 7 |
58839 | 58839 | 2020-04-14 | Salt Lake | Utah | 49035 | 1187 | 7 |
56133 | 56133 | 2020-04-13 | Salt Lake | Utah | 49035 | 1157 | 7 |
53444 | 53444 | 2020-04-12 | Salt Lake | Utah | 49035 | 1126 | 7 |
50769 | 50769 | 2020-04-11 | Salt Lake | Utah | 49035 | 1071 | 7 |
48111 | 48111 | 2020-04-10 | Salt Lake | Utah | 49035 | 1011 | 7 |
45487 | 45487 | 2020-04-09 | Salt Lake | Utah | 49035 | 935 | 7 |
42893 | 42893 | 2020-04-08 | Salt Lake | Utah | 49035 | 868 | 7 |
40325 | 40325 | 2020-04-07 | Salt Lake | Utah | 49035 | 807 | 1 |
37796 | 37796 | 2020-04-06 | Salt Lake | Utah | 49035 | 741 | 1 |
35318 | 35318 | 2020-04-05 | Salt Lake | Utah | 49035 | 741 | 1 |
32880 | 32880 | 2020-04-04 | Salt Lake | Utah | 49035 | 650 | 1 |
30482 | 30482 | 2020-04-03 | Salt Lake | Utah | 49035 | 541 | 1 |
28139 | 28139 | 2020-04-02 | Salt Lake | Utah | 49035 | 476 | 1 |
25850 | 25850 | 2020-04-01 | Salt Lake | Utah | 49035 | 444 | 1 |
23635 | 23635 | 2020-03-31 | Salt Lake | Utah | 49035 | 396 | 0 |
21496 | 21496 | 2020-03-30 | Salt Lake | Utah | 49035 | 363 | 0 |
19433 | 19433 | 2020-03-29 | Salt Lake | Utah | 49035 | 324 | 0 |
17474 | 17474 | 2020-03-28 | Salt Lake | Utah | 49035 | 276 | 0 |
15601 | 15601 | 2020-03-27 | Salt Lake | Utah | 49035 | 212 | 0 |
13836 | 13836 | 2020-03-26 | Salt Lake | Utah | 49035 | 181 | 0 |
12200 | 12200 | 2020-03-25 | Salt Lake | Utah | 49035 | 151 | 0 |
10690 | 10690 | 2020-03-24 | Salt Lake | Utah | 49035 | 127 | 0 |
9346 | 9346 | 2020-03-23 | Salt Lake | Utah | 49035 | 112 | 0 |
8126 | 8126 | 2020-03-22 | Salt Lake | Utah | 49035 | 84 | 0 |
6996 | 6996 | 2020-03-21 | Salt Lake | Utah | 49035 | 60 | 0 |
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);