ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 8013 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534673 | 534673 | 2020-09-15 | Boulder | Colorado | 8013 | 2989 | 79 |
531438 | 531438 | 2020-09-14 | Boulder | Colorado | 8013 | 2877 | 79 |
528201 | 528201 | 2020-09-13 | Boulder | Colorado | 8013 | 2794 | 79 |
524965 | 524965 | 2020-09-12 | Boulder | Colorado | 8013 | 2759 | 79 |
521729 | 521729 | 2020-09-11 | Boulder | Colorado | 8013 | 2671 | 79 |
518492 | 518492 | 2020-09-10 | Boulder | Colorado | 8013 | 2621 | 79 |
515257 | 515257 | 2020-09-09 | Boulder | Colorado | 8013 | 2574 | 79 |
512024 | 512024 | 2020-09-08 | Boulder | Colorado | 8013 | 2502 | 79 |
508791 | 508791 | 2020-09-07 | Boulder | Colorado | 8013 | 2482 | 79 |
505559 | 505559 | 2020-09-06 | Boulder | Colorado | 8013 | 2478 | 79 |
502325 | 502325 | 2020-09-05 | Boulder | Colorado | 8013 | 2413 | 79 |
499091 | 499091 | 2020-09-04 | Boulder | Colorado | 8013 | 2399 | 79 |
495858 | 495858 | 2020-09-03 | Boulder | Colorado | 8013 | 2361 | 79 |
492624 | 492624 | 2020-09-02 | Boulder | Colorado | 8013 | 2344 | 79 |
489391 | 489391 | 2020-09-01 | Boulder | Colorado | 8013 | 2324 | 79 |
486158 | 486158 | 2020-08-31 | Boulder | Colorado | 8013 | 2316 | 79 |
482923 | 482923 | 2020-08-30 | Boulder | Colorado | 8013 | 2295 | 79 |
479689 | 479689 | 2020-08-29 | Boulder | Colorado | 8013 | 2289 | 79 |
476456 | 476456 | 2020-08-28 | Boulder | Colorado | 8013 | 2283 | 79 |
473223 | 473223 | 2020-08-27 | Boulder | Colorado | 8013 | 2271 | 79 |
469991 | 469991 | 2020-08-26 | Boulder | Colorado | 8013 | 2256 | 79 |
466762 | 466762 | 2020-08-25 | Boulder | Colorado | 8013 | 2250 | 79 |
463533 | 463533 | 2020-08-24 | Boulder | Colorado | 8013 | 2239 | 79 |
460304 | 460304 | 2020-08-23 | Boulder | Colorado | 8013 | 2225 | 79 |
457077 | 457077 | 2020-08-22 | Boulder | Colorado | 8013 | 2215 | 79 |
453849 | 453849 | 2020-08-21 | Boulder | Colorado | 8013 | 2201 | 79 |
450621 | 450621 | 2020-08-20 | Boulder | Colorado | 8013 | 2186 | 78 |
447393 | 447393 | 2020-08-19 | Boulder | Colorado | 8013 | 2177 | 78 |
444166 | 444166 | 2020-08-18 | Boulder | Colorado | 8013 | 2153 | 78 |
440940 | 440940 | 2020-08-17 | Boulder | Colorado | 8013 | 2141 | 77 |
437714 | 437714 | 2020-08-16 | Boulder | Colorado | 8013 | 2146 | 77 |
434488 | 434488 | 2020-08-15 | Boulder | Colorado | 8013 | 2141 | 77 |
431263 | 431263 | 2020-08-14 | Boulder | Colorado | 8013 | 2137 | 76 |
428035 | 428035 | 2020-08-13 | Boulder | Colorado | 8013 | 2130 | 76 |
424811 | 424811 | 2020-08-12 | Boulder | Colorado | 8013 | 2120 | 76 |
421590 | 421590 | 2020-08-11 | Boulder | Colorado | 8013 | 2105 | 76 |
418369 | 418369 | 2020-08-10 | Boulder | Colorado | 8013 | 2086 | 74 |
415148 | 415148 | 2020-08-09 | Boulder | Colorado | 8013 | 2070 | 74 |
411928 | 411928 | 2020-08-08 | Boulder | Colorado | 8013 | 2054 | 74 |
408709 | 408709 | 2020-08-07 | Boulder | Colorado | 8013 | 2049 | 75 |
405489 | 405489 | 2020-08-06 | Boulder | Colorado | 8013 | 2031 | 75 |
402271 | 402271 | 2020-08-05 | Boulder | Colorado | 8013 | 2015 | 75 |
399055 | 399055 | 2020-08-04 | Boulder | Colorado | 8013 | 1969 | 75 |
395839 | 395839 | 2020-08-03 | Boulder | Colorado | 8013 | 1962 | 75 |
392623 | 392623 | 2020-08-02 | Boulder | Colorado | 8013 | 1938 | 75 |
389406 | 389406 | 2020-08-01 | Boulder | Colorado | 8013 | 1905 | 75 |
386189 | 386189 | 2020-07-31 | Boulder | Colorado | 8013 | 1890 | 75 |
382971 | 382971 | 2020-07-30 | Boulder | Colorado | 8013 | 1864 | 75 |
379754 | 379754 | 2020-07-29 | Boulder | Colorado | 8013 | 1839 | 75 |
376537 | 376537 | 2020-07-28 | Boulder | Colorado | 8013 | 1825 | 74 |
373323 | 373323 | 2020-07-27 | Boulder | Colorado | 8013 | 1802 | 74 |
370111 | 370111 | 2020-07-26 | Boulder | Colorado | 8013 | 1787 | 74 |
366901 | 366901 | 2020-07-25 | Boulder | Colorado | 8013 | 1775 | 74 |
363694 | 363694 | 2020-07-24 | Boulder | Colorado | 8013 | 1757 | 74 |
360487 | 360487 | 2020-07-23 | Boulder | Colorado | 8013 | 1716 | 74 |
357282 | 357282 | 2020-07-22 | Boulder | Colorado | 8013 | 1702 | 74 |
354079 | 354079 | 2020-07-21 | Boulder | Colorado | 8013 | 1682 | 74 |
350877 | 350877 | 2020-07-20 | Boulder | Colorado | 8013 | 1669 | 74 |
347676 | 347676 | 2020-07-19 | Boulder | Colorado | 8013 | 1653 | 74 |
344476 | 344476 | 2020-07-18 | Boulder | Colorado | 8013 | 1643 | 74 |
341277 | 341277 | 2020-07-17 | Boulder | Colorado | 8013 | 1638 | 74 |
338081 | 338081 | 2020-07-16 | Boulder | Colorado | 8013 | 1618 | 74 |
334886 | 334886 | 2020-07-15 | Boulder | Colorado | 8013 | 1595 | 74 |
331693 | 331693 | 2020-07-14 | Boulder | Colorado | 8013 | 1572 | 74 |
328507 | 328507 | 2020-07-13 | Boulder | Colorado | 8013 | 1542 | 73 |
325321 | 325321 | 2020-07-12 | Boulder | Colorado | 8013 | 1527 | 73 |
322140 | 322140 | 2020-07-11 | Boulder | Colorado | 8013 | 1522 | 73 |
318961 | 318961 | 2020-07-10 | Boulder | Colorado | 8013 | 1503 | 73 |
315788 | 315788 | 2020-07-09 | Boulder | Colorado | 8013 | 1492 | 72 |
312613 | 312613 | 2020-07-08 | Boulder | Colorado | 8013 | 1479 | 73 |
309443 | 309443 | 2020-07-07 | Boulder | Colorado | 8013 | 1463 | 73 |
306275 | 306275 | 2020-07-06 | Boulder | Colorado | 8013 | 1453 | 72 |
303111 | 303111 | 2020-07-05 | Boulder | Colorado | 8013 | 1436 | 72 |
299947 | 299947 | 2020-07-04 | Boulder | Colorado | 8013 | 1432 | 72 |
296785 | 296785 | 2020-07-03 | Boulder | Colorado | 8013 | 1424 | 72 |
293629 | 293629 | 2020-07-02 | Boulder | Colorado | 8013 | 1414 | 72 |
290475 | 290475 | 2020-07-01 | Boulder | Colorado | 8013 | 1401 | 72 |
287324 | 287324 | 2020-06-30 | Boulder | Colorado | 8013 | 1384 | 72 |
284178 | 284178 | 2020-06-29 | Boulder | Colorado | 8013 | 1367 | 71 |
281032 | 281032 | 2020-06-28 | Boulder | Colorado | 8013 | 1360 | 71 |
277885 | 277885 | 2020-06-27 | Boulder | Colorado | 8013 | 1347 | 71 |
274737 | 274737 | 2020-06-26 | Boulder | Colorado | 8013 | 1336 | 71 |
271597 | 271597 | 2020-06-25 | Boulder | Colorado | 8013 | 1321 | 71 |
268462 | 268462 | 2020-06-24 | Boulder | Colorado | 8013 | 1305 | 71 |
265332 | 265332 | 2020-06-23 | Boulder | Colorado | 8013 | 1282 | 71 |
262204 | 262204 | 2020-06-22 | Boulder | Colorado | 8013 | 1259 | 71 |
259077 | 259077 | 2020-06-21 | Boulder | Colorado | 8013 | 1243 | 71 |
255950 | 255950 | 2020-06-20 | Boulder | Colorado | 8013 | 1228 | 71 |
252831 | 252831 | 2020-06-19 | Boulder | Colorado | 8013 | 1211 | 71 |
249716 | 249716 | 2020-06-18 | Boulder | Colorado | 8013 | 1173 | 70 |
246604 | 246604 | 2020-06-17 | Boulder | Colorado | 8013 | 1137 | 70 |
243491 | 243491 | 2020-06-16 | Boulder | Colorado | 8013 | 1100 | 70 |
240380 | 240380 | 2020-06-15 | Boulder | Colorado | 8013 | 1088 | 70 |
237272 | 237272 | 2020-06-14 | Boulder | Colorado | 8013 | 1070 | 70 |
234165 | 234165 | 2020-06-13 | Boulder | Colorado | 8013 | 1065 | 69 |
231059 | 231059 | 2020-06-12 | Boulder | Colorado | 8013 | 1049 | 68 |
227956 | 227956 | 2020-06-11 | Boulder | Colorado | 8013 | 1040 | 68 |
224854 | 224854 | 2020-06-10 | Boulder | Colorado | 8013 | 1031 | 67 |
221759 | 221759 | 2020-06-09 | Boulder | Colorado | 8013 | 1027 | 67 |
218664 | 218664 | 2020-06-08 | Boulder | Colorado | 8013 | 1022 | 67 |
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);