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 |
---|---|---|---|---|---|---|---|
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 |
5973 | 5973 | 2020-03-20 | Salt Lake | Utah | 49035 | 46 | 0 |
5079 | 5079 | 2020-03-19 | Salt Lake | Utah | 49035 | 31 | 0 |
4323 | 4323 | 2020-03-18 | Salt Lake | Utah | 49035 | 24 | 0 |
3691 | 3691 | 2020-03-17 | Salt Lake | Utah | 49035 | 23 | 0 |
3155 | 3155 | 2020-03-16 | Salt Lake | Utah | 49035 | 20 | 0 |
2686 | 2686 | 2020-03-15 | Salt Lake | Utah | 49035 | 15 | 0 |
2260 | 2260 | 2020-03-14 | Salt Lake | Utah | 49035 | 15 | 0 |
1893 | 1893 | 2020-03-13 | Salt Lake | Utah | 49035 | 4 | 0 |
1584 | 1584 | 2020-03-12 | Salt Lake | Utah | 49035 | 4 | 0 |
1337 | 1337 | 2020-03-11 | Salt Lake | Utah | 49035 | 2 | 0 |
1140 | 1140 | 2020-03-10 | Salt Lake | Utah | 49035 | 1 | 0 |
979 | 979 | 2020-03-09 | Salt Lake | Utah | 49035 | 1 | 0 |
849 | 849 | 2020-03-08 | Salt Lake | Utah | 49035 | 1 | 0 |
737 | 737 | 2020-03-07 | Salt Lake | Utah | 49035 | 1 | 0 |
645 | 645 | 2020-03-06 | Salt Lake | Utah | 49035 | 1 | 0 |
575 | 575 | 2020-03-05 | Salt Lake | Utah | 49035 | 1 | 0 |
526 | 526 | 2020-03-04 | Salt Lake | Utah | 49035 | 1 | 0 |
488 | 488 | 2020-03-03 | Salt Lake | Utah | 49035 | 1 | 0 |
453 | 453 | 2020-03-02 | Salt Lake | Utah | 49035 | 1 | 0 |
421 | 421 | 2020-03-01 | Salt Lake | Utah | 49035 | 1 | 0 |
394 | 394 | 2020-02-29 | Salt Lake | Utah | 49035 | 1 | 0 |
372 | 372 | 2020-02-28 | Salt Lake | Utah | 49035 | 1 | 0 |
351 | 351 | 2020-02-27 | Salt Lake | Utah | 49035 | 1 | 0 |
331 | 331 | 2020-02-26 | Salt Lake | Utah | 49035 | 1 | 0 |
311 | 311 | 2020-02-25 | Salt Lake | Utah | 49035 | 1 | 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);