ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 6037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38262 | 38262 | 2020-04-07 | Los Angeles | California | 6037 | 6910 | 169 |
35773 | 35773 | 2020-04-06 | Los Angeles | California | 6037 | 6360 | 147 |
33328 | 33328 | 2020-04-05 | Los Angeles | California | 6037 | 5940 | 132 |
30922 | 30922 | 2020-04-04 | Los Angeles | California | 6037 | 5277 | 117 |
28564 | 28564 | 2020-04-03 | Los Angeles | California | 6037 | 4566 | 89 |
26265 | 26265 | 2020-04-02 | Los Angeles | California | 6037 | 4045 | 78 |
24036 | 24036 | 2020-04-01 | Los Angeles | California | 6037 | 3518 | 65 |
21878 | 21878 | 2020-03-31 | Los Angeles | California | 6037 | 3011 | 54 |
19804 | 19804 | 2020-03-30 | Los Angeles | California | 6037 | 2474 | 44 |
17827 | 17827 | 2020-03-29 | Los Angeles | California | 6037 | 2136 | 37 |
15938 | 15938 | 2020-03-28 | Los Angeles | California | 6037 | 1804 | 33 |
14156 | 14156 | 2020-03-27 | Los Angeles | California | 6037 | 1465 | 27 |
12490 | 12490 | 2020-03-26 | Los Angeles | California | 6037 | 1216 | 21 |
10945 | 10945 | 2020-03-25 | Los Angeles | California | 6037 | 799 | 13 |
9573 | 9573 | 2020-03-24 | Los Angeles | California | 6037 | 662 | 11 |
8332 | 8332 | 2020-03-23 | Los Angeles | California | 6037 | 536 | 7 |
7189 | 7189 | 2020-03-22 | Los Angeles | California | 6037 | 421 | 5 |
6155 | 6155 | 2020-03-21 | Los Angeles | California | 6037 | 351 | 4 |
5234 | 5234 | 2020-03-20 | Los Angeles | California | 6037 | 292 | 2 |
4459 | 4459 | 2020-03-19 | Los Angeles | California | 6037 | 231 | 2 |
3799 | 3799 | 2020-03-18 | Los Angeles | California | 6037 | 190 | 1 |
3246 | 3246 | 2020-03-17 | Los Angeles | California | 6037 | 144 | 1 |
2765 | 2765 | 2020-03-16 | Los Angeles | California | 6037 | 94 | 1 |
2331 | 2331 | 2020-03-15 | Los Angeles | California | 6037 | 69 | 1 |
1952 | 1952 | 2020-03-14 | Los Angeles | California | 6037 | 53 | 1 |
1635 | 1635 | 2020-03-13 | Los Angeles | California | 6037 | 40 | 1 |
1375 | 1375 | 2020-03-12 | Los Angeles | California | 6037 | 32 | 1 |
1169 | 1169 | 2020-03-11 | Los Angeles | California | 6037 | 28 | 1 |
1003 | 1003 | 2020-03-10 | Los Angeles | California | 6037 | 20 | 0 |
871 | 871 | 2020-03-09 | Los Angeles | California | 6037 | 19 | 0 |
757 | 757 | 2020-03-08 | Los Angeles | California | 6037 | 14 | 0 |
662 | 662 | 2020-03-07 | Los Angeles | California | 6037 | 14 | 0 |
587 | 587 | 2020-03-06 | Los Angeles | California | 6037 | 13 | 0 |
537 | 537 | 2020-03-05 | Los Angeles | California | 6037 | 11 | 0 |
498 | 498 | 2020-03-04 | Los Angeles | California | 6037 | 7 | 0 |
463 | 463 | 2020-03-03 | Los Angeles | California | 6037 | 1 | 0 |
429 | 429 | 2020-03-02 | Los Angeles | California | 6037 | 1 | 0 |
402 | 402 | 2020-03-01 | Los Angeles | California | 6037 | 1 | 0 |
379 | 379 | 2020-02-29 | Los Angeles | California | 6037 | 1 | 0 |
357 | 357 | 2020-02-28 | Los Angeles | California | 6037 | 1 | 0 |
337 | 337 | 2020-02-27 | Los Angeles | California | 6037 | 1 | 0 |
317 | 317 | 2020-02-26 | Los Angeles | California | 6037 | 1 | 0 |
300 | 300 | 2020-02-25 | Los Angeles | California | 6037 | 1 | 0 |
284 | 284 | 2020-02-24 | Los Angeles | California | 6037 | 1 | 0 |
270 | 270 | 2020-02-23 | Los Angeles | California | 6037 | 1 | 0 |
256 | 256 | 2020-02-22 | Los Angeles | California | 6037 | 1 | 0 |
242 | 242 | 2020-02-21 | Los Angeles | California | 6037 | 1 | 0 |
229 | 229 | 2020-02-20 | Los Angeles | California | 6037 | 1 | 0 |
216 | 216 | 2020-02-19 | Los Angeles | California | 6037 | 1 | 0 |
204 | 204 | 2020-02-18 | Los Angeles | California | 6037 | 1 | 0 |
192 | 192 | 2020-02-17 | Los Angeles | California | 6037 | 1 | 0 |
181 | 181 | 2020-02-16 | Los Angeles | California | 6037 | 1 | 0 |
170 | 170 | 2020-02-15 | Los Angeles | California | 6037 | 1 | 0 |
159 | 159 | 2020-02-14 | Los Angeles | California | 6037 | 1 | 0 |
148 | 148 | 2020-02-13 | Los Angeles | California | 6037 | 1 | 0 |
137 | 137 | 2020-02-12 | Los Angeles | California | 6037 | 1 | 0 |
127 | 127 | 2020-02-11 | Los Angeles | California | 6037 | 1 | 0 |
117 | 117 | 2020-02-10 | Los Angeles | California | 6037 | 1 | 0 |
108 | 108 | 2020-02-09 | Los Angeles | California | 6037 | 1 | 0 |
99 | 99 | 2020-02-08 | Los Angeles | California | 6037 | 1 | 0 |
90 | 90 | 2020-02-07 | Los Angeles | California | 6037 | 1 | 0 |
81 | 81 | 2020-02-06 | Los Angeles | California | 6037 | 1 | 0 |
72 | 72 | 2020-02-05 | Los Angeles | California | 6037 | 1 | 0 |
64 | 64 | 2020-02-04 | Los Angeles | California | 6037 | 1 | 0 |
56 | 56 | 2020-02-03 | Los Angeles | California | 6037 | 1 | 0 |
48 | 48 | 2020-02-02 | Los Angeles | California | 6037 | 1 | 0 |
41 | 41 | 2020-02-01 | Los Angeles | California | 6037 | 1 | 0 |
35 | 35 | 2020-01-31 | Los Angeles | California | 6037 | 1 | 0 |
30 | 30 | 2020-01-30 | Los Angeles | California | 6037 | 1 | 0 |
25 | 25 | 2020-01-29 | Los Angeles | California | 6037 | 1 | 0 |
20 | 20 | 2020-01-28 | Los Angeles | California | 6037 | 1 | 0 |
15 | 15 | 2020-01-27 | Los Angeles | California | 6037 | 1 | 0 |
10 | 10 | 2020-01-26 | Los Angeles | California | 6037 | 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);