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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
115550 | 115550 | 2020-05-05 | Los Angeles | California | 6037 | 27815 | 1313 |
118509 | 118509 | 2020-05-06 | Los Angeles | California | 6037 | 28644 | 1367 |
121476 | 121476 | 2020-05-07 | Los Angeles | California | 6037 | 29427 | 1418 |
124456 | 124456 | 2020-05-08 | Los Angeles | California | 6037 | 30296 | 1468 |
127441 | 127441 | 2020-05-09 | Los Angeles | California | 6037 | 31197 | 1512 |
130431 | 130431 | 2020-05-10 | Los Angeles | California | 6037 | 31677 | 1530 |
133421 | 133421 | 2020-05-11 | Los Angeles | California | 6037 | 32258 | 1569 |
136411 | 136411 | 2020-05-12 | Los Angeles | California | 6037 | 33180 | 1613 |
139402 | 139402 | 2020-05-13 | Los Angeles | California | 6037 | 34428 | 1659 |
142398 | 142398 | 2020-05-14 | Los Angeles | California | 6037 | 35329 | 1659 |
145397 | 145397 | 2020-05-15 | Los Angeles | California | 6037 | 36259 | 1755 |
148401 | 148401 | 2020-05-16 | Los Angeles | California | 6037 | 37303 | 1793 |
151410 | 151410 | 2020-05-17 | Los Angeles | California | 6037 | 37974 | 1821 |
154422 | 154422 | 2020-05-18 | Los Angeles | California | 6037 | 38451 | 1839 |
157438 | 157438 | 2020-05-19 | Los Angeles | California | 6037 | 39573 | 1913 |
160464 | 160464 | 2020-05-20 | Los Angeles | California | 6037 | 40857 | 1970 |
163492 | 163492 | 2020-05-21 | Los Angeles | California | 6037 | 42037 | 2016 |
166524 | 166524 | 2020-05-22 | Los Angeles | California | 6037 | 43052 | 2049 |
169561 | 169561 | 2020-05-23 | Los Angeles | California | 6037 | 44055 | 2090 |
172602 | 172602 | 2020-05-24 | Los Angeles | California | 6037 | 44988 | 2104 |
175646 | 175646 | 2020-05-25 | Los Angeles | California | 6037 | 46018 | 2116 |
178690 | 178690 | 2020-05-26 | Los Angeles | California | 6037 | 47822 | 2143 |
181734 | 181734 | 2020-05-27 | Los Angeles | California | 6037 | 48700 | 2195 |
184788 | 184788 | 2020-05-28 | Los Angeles | California | 6037 | 49774 | 2241 |
187844 | 187844 | 2020-05-29 | Los Angeles | California | 6037 | 51562 | 2290 |
190909 | 190909 | 2020-05-30 | Los Angeles | California | 6037 | 53651 | 2338 |
193976 | 193976 | 2020-05-31 | Los Angeles | California | 6037 | 54996 | 2362 |
197046 | 197046 | 2020-06-01 | Los Angeles | California | 6037 | 55968 | 2384 |
200119 | 200119 | 2020-06-02 | Los Angeles | California | 6037 | 57118 | 2443 |
203195 | 203195 | 2020-06-03 | Los Angeles | California | 6037 | 58234 | 2489 |
206275 | 206275 | 2020-06-04 | Los Angeles | California | 6037 | 59650 | 2531 |
209356 | 209356 | 2020-06-05 | Los Angeles | California | 6037 | 61045 | 2565 |
212441 | 212441 | 2020-06-06 | Los Angeles | California | 6037 | 62338 | 2620 |
215528 | 215528 | 2020-06-07 | Los Angeles | California | 6037 | 63844 | 2645 |
218619 | 218619 | 2020-06-08 | Los Angeles | California | 6037 | 64644 | 2655 |
221714 | 221714 | 2020-06-09 | Los Angeles | California | 6037 | 65822 | 2707 |
224809 | 224809 | 2020-06-10 | Los Angeles | California | 6037 | 67064 | 2768 |
227911 | 227911 | 2020-06-11 | Los Angeles | California | 6037 | 68875 | 2813 |
231014 | 231014 | 2020-06-12 | Los Angeles | California | 6037 | 70476 | 2832 |
234120 | 234120 | 2020-06-13 | Los Angeles | California | 6037 | 72023 | 2890 |
237227 | 237227 | 2020-06-14 | Los Angeles | California | 6037 | 73018 | 2907 |
240335 | 240335 | 2020-06-15 | Los Angeles | California | 6037 | 73791 | 2926 |
243446 | 243446 | 2020-06-16 | Los Angeles | California | 6037 | 75084 | 2959 |
246559 | 246559 | 2020-06-17 | Los Angeles | California | 6037 | 77189 | 2991 |
249671 | 249671 | 2020-06-18 | Los Angeles | California | 6037 | 78227 | 3027 |
252786 | 252786 | 2020-06-19 | Los Angeles | California | 6037 | 79609 | 3063 |
255905 | 255905 | 2020-06-20 | Los Angeles | California | 6037 | 81636 | 3110 |
259032 | 259032 | 2020-06-21 | Los Angeles | California | 6037 | 83397 | 3120 |
262159 | 262159 | 2020-06-22 | Los Angeles | California | 6037 | 85942 | 3137 |
265287 | 265287 | 2020-06-23 | Los Angeles | California | 6037 | 88262 | 3171 |
268417 | 268417 | 2020-06-24 | Los Angeles | California | 6037 | 89490 | 3205 |
271552 | 271552 | 2020-06-25 | Los Angeles | California | 6037 | 91467 | 3246 |
274692 | 274692 | 2020-06-26 | Los Angeles | California | 6037 | 93232 | 3267 |
277840 | 277840 | 2020-06-27 | Los Angeles | California | 6037 | 95371 | 3285 |
280987 | 280987 | 2020-06-28 | Los Angeles | California | 6037 | 97894 | 3305 |
284133 | 284133 | 2020-06-29 | Los Angeles | California | 6037 | 100772 | 3326 |
287279 | 287279 | 2020-06-30 | Los Angeles | California | 6037 | 103529 | 3369 |
290430 | 290430 | 2020-07-01 | Los Angeles | California | 6037 | 105507 | 3402 |
293584 | 293584 | 2020-07-02 | Los Angeles | California | 6037 | 107667 | 3454 |
296740 | 296740 | 2020-07-03 | Los Angeles | California | 6037 | 110310 | 3454 |
299902 | 299902 | 2020-07-04 | Los Angeles | California | 6037 | 113497 | 3454 |
303066 | 303066 | 2020-07-05 | Los Angeles | California | 6037 | 114993 | 3487 |
306230 | 306230 | 2020-07-06 | Los Angeles | California | 6037 | 116570 | 3534 |
309398 | 309398 | 2020-07-07 | Los Angeles | California | 6037 | 120539 | 3579 |
312568 | 312568 | 2020-07-08 | Los Angeles | California | 6037 | 123004 | 3642 |
315743 | 315743 | 2020-07-09 | Los Angeles | California | 6037 | 124738 | 3689 |
318916 | 318916 | 2020-07-10 | Los Angeles | California | 6037 | 127358 | 3738 |
322095 | 322095 | 2020-07-11 | Los Angeles | California | 6037 | 130242 | 3793 |
325276 | 325276 | 2020-07-12 | Los Angeles | California | 6037 | 133549 | 3809 |
328462 | 328462 | 2020-07-13 | Los Angeles | California | 6037 | 136129 | 3822 |
331648 | 331648 | 2020-07-14 | Los Angeles | California | 6037 | 140307 | 3894 |
334841 | 334841 | 2020-07-15 | Los Angeles | California | 6037 | 143009 | 3936 |
338036 | 338036 | 2020-07-16 | Los Angeles | California | 6037 | 147468 | 3988 |
341232 | 341232 | 2020-07-17 | Los Angeles | California | 6037 | 150319 | 4047 |
344431 | 344431 | 2020-07-18 | Los Angeles | California | 6037 | 153041 | 4084 |
347631 | 347631 | 2020-07-19 | Los Angeles | California | 6037 | 155887 | 4095 |
350832 | 350832 | 2020-07-20 | Los Angeles | California | 6037 | 159045 | 4104 |
354034 | 354034 | 2020-07-21 | Los Angeles | California | 6037 | 161673 | 4154 |
357237 | 357237 | 2020-07-22 | Los Angeles | California | 6037 | 164870 | 4213 |
360442 | 360442 | 2020-07-23 | Los Angeles | California | 6037 | 166848 | 4262 |
363649 | 363649 | 2020-07-24 | Los Angeles | California | 6037 | 168757 | 4300 |
366856 | 366856 | 2020-07-25 | Los Angeles | California | 6037 | 172325 | 4351 |
370066 | 370066 | 2020-07-26 | Los Angeles | California | 6037 | 173995 | 4360 |
373278 | 373278 | 2020-07-27 | Los Angeles | California | 6037 | 176028 | 4375 |
376492 | 376492 | 2020-07-28 | Los Angeles | California | 6037 | 178642 | 4426 |
379708 | 379708 | 2020-07-29 | Los Angeles | California | 6037 | 183383 | 4516 |
382925 | 382925 | 2020-07-30 | Los Angeles | California | 6037 | 185872 | 4552 |
386143 | 386143 | 2020-07-31 | Los Angeles | California | 6037 | 188481 | 4621 |
389360 | 389360 | 2020-08-01 | Los Angeles | California | 6037 | 190693 | 4669 |
392577 | 392577 | 2020-08-02 | Los Angeles | California | 6037 | 192167 | 4692 |
395793 | 395793 | 2020-08-03 | Los Angeles | California | 6037 | 193788 | 4701 |
399009 | 399009 | 2020-08-04 | Los Angeles | California | 6037 | 195614 | 4758 |
402225 | 402225 | 2020-08-05 | Los Angeles | California | 6037 | 197912 | 4825 |
405443 | 405443 | 2020-08-06 | Los Angeles | California | 6037 | 201106 | 4869 |
408663 | 408663 | 2020-08-07 | Los Angeles | California | 6037 | 204167 | 4918 |
411882 | 411882 | 2020-08-08 | Los Angeles | California | 6037 | 206761 | 4967 |
415102 | 415102 | 2020-08-09 | Los Angeles | California | 6037 | 208528 | 4977 |
418323 | 418323 | 2020-08-10 | Los Angeles | California | 6037 | 210424 | 4996 |
421544 | 421544 | 2020-08-11 | Los Angeles | California | 6037 | 211808 | 5057 |
424765 | 424765 | 2020-08-12 | Los Angeles | California | 6037 | 214197 | 5109 |
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);