ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8005 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534669 | 534669 | 2020-09-15 | Arapahoe | Colorado | 8005 | 8748 | 370 |
531434 | 531434 | 2020-09-14 | Arapahoe | Colorado | 8005 | 8692 | 370 |
528197 | 528197 | 2020-09-13 | Arapahoe | Colorado | 8005 | 8656 | 370 |
524961 | 524961 | 2020-09-12 | Arapahoe | Colorado | 8005 | 8624 | 370 |
521725 | 521725 | 2020-09-11 | Arapahoe | Colorado | 8005 | 8575 | 370 |
518488 | 518488 | 2020-09-10 | Arapahoe | Colorado | 8005 | 8549 | 370 |
515253 | 515253 | 2020-09-09 | Arapahoe | Colorado | 8005 | 8496 | 370 |
512020 | 512020 | 2020-09-08 | Arapahoe | Colorado | 8005 | 8468 | 370 |
508787 | 508787 | 2020-09-07 | Arapahoe | Colorado | 8005 | 8450 | 370 |
505555 | 505555 | 2020-09-06 | Arapahoe | Colorado | 8005 | 8436 | 370 |
502321 | 502321 | 2020-09-05 | Arapahoe | Colorado | 8005 | 8419 | 369 |
499087 | 499087 | 2020-09-04 | Arapahoe | Colorado | 8005 | 8381 | 369 |
495854 | 495854 | 2020-09-03 | Arapahoe | Colorado | 8005 | 8346 | 370 |
492620 | 492620 | 2020-09-02 | Arapahoe | Colorado | 8005 | 8320 | 370 |
489387 | 489387 | 2020-09-01 | Arapahoe | Colorado | 8005 | 8277 | 369 |
486154 | 486154 | 2020-08-31 | Arapahoe | Colorado | 8005 | 8237 | 368 |
482919 | 482919 | 2020-08-30 | Arapahoe | Colorado | 8005 | 8195 | 367 |
479685 | 479685 | 2020-08-29 | Arapahoe | Colorado | 8005 | 8170 | 367 |
476452 | 476452 | 2020-08-28 | Arapahoe | Colorado | 8005 | 8170 | 367 |
473219 | 473219 | 2020-08-27 | Arapahoe | Colorado | 8005 | 8114 | 367 |
469987 | 469987 | 2020-08-26 | Arapahoe | Colorado | 8005 | 8071 | 367 |
466758 | 466758 | 2020-08-25 | Arapahoe | Colorado | 8005 | 8051 | 367 |
463529 | 463529 | 2020-08-24 | Arapahoe | Colorado | 8005 | 7990 | 366 |
460300 | 460300 | 2020-08-23 | Arapahoe | Colorado | 8005 | 7957 | 366 |
457073 | 457073 | 2020-08-22 | Arapahoe | Colorado | 8005 | 7791 | 364 |
453845 | 453845 | 2020-08-21 | Arapahoe | Colorado | 8005 | 7760 | 364 |
450617 | 450617 | 2020-08-20 | Arapahoe | Colorado | 8005 | 7706 | 364 |
447389 | 447389 | 2020-08-19 | Arapahoe | Colorado | 8005 | 7669 | 364 |
444162 | 444162 | 2020-08-18 | Arapahoe | Colorado | 8005 | 7646 | 364 |
440936 | 440936 | 2020-08-17 | Arapahoe | Colorado | 8005 | 7610 | 364 |
437710 | 437710 | 2020-08-16 | Arapahoe | Colorado | 8005 | 7594 | 364 |
434484 | 434484 | 2020-08-15 | Arapahoe | Colorado | 8005 | 7547 | 364 |
431259 | 431259 | 2020-08-14 | Arapahoe | Colorado | 8005 | 7497 | 363 |
428031 | 428031 | 2020-08-13 | Arapahoe | Colorado | 8005 | 7461 | 363 |
424807 | 424807 | 2020-08-12 | Arapahoe | Colorado | 8005 | 7405 | 363 |
421586 | 421586 | 2020-08-11 | Arapahoe | Colorado | 8005 | 7377 | 362 |
418365 | 418365 | 2020-08-10 | Arapahoe | Colorado | 8005 | 7340 | 364 |
415144 | 415144 | 2020-08-09 | Arapahoe | Colorado | 8005 | 7311 | 364 |
411924 | 411924 | 2020-08-08 | Arapahoe | Colorado | 8005 | 7286 | 364 |
408705 | 408705 | 2020-08-07 | Arapahoe | Colorado | 8005 | 7234 | 364 |
405485 | 405485 | 2020-08-06 | Arapahoe | Colorado | 8005 | 7194 | 363 |
402267 | 402267 | 2020-08-05 | Arapahoe | Colorado | 8005 | 7156 | 364 |
399051 | 399051 | 2020-08-04 | Arapahoe | Colorado | 8005 | 7093 | 364 |
395835 | 395835 | 2020-08-03 | Arapahoe | Colorado | 8005 | 7023 | 363 |
392619 | 392619 | 2020-08-02 | Arapahoe | Colorado | 8005 | 7004 | 363 |
389402 | 389402 | 2020-08-01 | Arapahoe | Colorado | 8005 | 6932 | 363 |
386185 | 386185 | 2020-07-31 | Arapahoe | Colorado | 8005 | 6877 | 362 |
382967 | 382967 | 2020-07-30 | Arapahoe | Colorado | 8005 | 6798 | 362 |
379750 | 379750 | 2020-07-29 | Arapahoe | Colorado | 8005 | 6749 | 362 |
376533 | 376533 | 2020-07-28 | Arapahoe | Colorado | 8005 | 6691 | 362 |
373319 | 373319 | 2020-07-27 | Arapahoe | Colorado | 8005 | 6570 | 360 |
370107 | 370107 | 2020-07-26 | Arapahoe | Colorado | 8005 | 6541 | 360 |
366897 | 366897 | 2020-07-25 | Arapahoe | Colorado | 8005 | 6470 | 360 |
363690 | 363690 | 2020-07-24 | Arapahoe | Colorado | 8005 | 6373 | 360 |
360483 | 360483 | 2020-07-23 | Arapahoe | Colorado | 8005 | 6276 | 360 |
357278 | 357278 | 2020-07-22 | Arapahoe | Colorado | 8005 | 6197 | 352 |
354075 | 354075 | 2020-07-21 | Arapahoe | Colorado | 8005 | 6140 | 352 |
350873 | 350873 | 2020-07-20 | Arapahoe | Colorado | 8005 | 6075 | 352 |
347672 | 347672 | 2020-07-19 | Arapahoe | Colorado | 8005 | 6032 | 351 |
344472 | 344472 | 2020-07-18 | Arapahoe | Colorado | 8005 | 5990 | 351 |
341273 | 341273 | 2020-07-17 | Arapahoe | Colorado | 8005 | 5934 | 351 |
338077 | 338077 | 2020-07-16 | Arapahoe | Colorado | 8005 | 5854 | 351 |
334882 | 334882 | 2020-07-15 | Arapahoe | Colorado | 8005 | 5789 | 352 |
331689 | 331689 | 2020-07-14 | Arapahoe | Colorado | 8005 | 5734 | 352 |
328503 | 328503 | 2020-07-13 | Arapahoe | Colorado | 8005 | 5682 | 349 |
325317 | 325317 | 2020-07-12 | Arapahoe | Colorado | 8005 | 5647 | 349 |
322136 | 322136 | 2020-07-11 | Arapahoe | Colorado | 8005 | 5627 | 349 |
318957 | 318957 | 2020-07-10 | Arapahoe | Colorado | 8005 | 5583 | 349 |
315784 | 315784 | 2020-07-09 | Arapahoe | Colorado | 8005 | 5510 | 349 |
312609 | 312609 | 2020-07-08 | Arapahoe | Colorado | 8005 | 5459 | 347 |
309439 | 309439 | 2020-07-07 | Arapahoe | Colorado | 8005 | 5421 | 346 |
306271 | 306271 | 2020-07-06 | Arapahoe | Colorado | 8005 | 5369 | 346 |
303107 | 303107 | 2020-07-05 | Arapahoe | Colorado | 8005 | 5354 | 345 |
299943 | 299943 | 2020-07-04 | Arapahoe | Colorado | 8005 | 5329 | 345 |
296781 | 296781 | 2020-07-03 | Arapahoe | Colorado | 8005 | 5300 | 345 |
293625 | 293625 | 2020-07-02 | Arapahoe | Colorado | 8005 | 5267 | 345 |
290471 | 290471 | 2020-07-01 | Arapahoe | Colorado | 8005 | 5234 | 344 |
287320 | 287320 | 2020-06-30 | Arapahoe | Colorado | 8005 | 5202 | 344 |
284174 | 284174 | 2020-06-29 | Arapahoe | Colorado | 8005 | 5172 | 343 |
281028 | 281028 | 2020-06-28 | Arapahoe | Colorado | 8005 | 5157 | 342 |
277881 | 277881 | 2020-06-27 | Arapahoe | Colorado | 8005 | 5127 | 342 |
274733 | 274733 | 2020-06-26 | Arapahoe | Colorado | 8005 | 5100 | 342 |
271593 | 271593 | 2020-06-25 | Arapahoe | Colorado | 8005 | 5066 | 342 |
268458 | 268458 | 2020-06-24 | Arapahoe | Colorado | 8005 | 5022 | 342 |
265328 | 265328 | 2020-06-23 | Arapahoe | Colorado | 8005 | 4993 | 342 |
262200 | 262200 | 2020-06-22 | Arapahoe | Colorado | 8005 | 4975 | 339 |
259073 | 259073 | 2020-06-21 | Arapahoe | Colorado | 8005 | 4941 | 339 |
255946 | 255946 | 2020-06-20 | Arapahoe | Colorado | 8005 | 4921 | 339 |
252827 | 252827 | 2020-06-19 | Arapahoe | Colorado | 8005 | 4905 | 339 |
249712 | 249712 | 2020-06-18 | Arapahoe | Colorado | 8005 | 4885 | 340 |
246600 | 246600 | 2020-06-17 | Arapahoe | Colorado | 8005 | 4861 | 339 |
243487 | 243487 | 2020-06-16 | Arapahoe | Colorado | 8005 | 4826 | 338 |
240376 | 240376 | 2020-06-15 | Arapahoe | Colorado | 8005 | 4818 | 335 |
237268 | 237268 | 2020-06-14 | Arapahoe | Colorado | 8005 | 4803 | 335 |
234161 | 234161 | 2020-06-13 | Arapahoe | Colorado | 8005 | 4788 | 335 |
231055 | 231055 | 2020-06-12 | Arapahoe | Colorado | 8005 | 4754 | 335 |
227952 | 227952 | 2020-06-11 | Arapahoe | Colorado | 8005 | 4723 | 334 |
224850 | 224850 | 2020-06-10 | Arapahoe | Colorado | 8005 | 4709 | 331 |
221755 | 221755 | 2020-06-09 | Arapahoe | Colorado | 8005 | 4687 | 329 |
218660 | 218660 | 2020-06-08 | Arapahoe | Colorado | 8005 | 4663 | 326 |
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);