ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 8059 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635159 | 635159 | 2020-10-16 | Jefferson | Colorado | 8059 | 6991 | 298 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
628669 | 628669 | 2020-10-14 | Jefferson | Colorado | 8059 | 6806 | 296 |
625426 | 625426 | 2020-10-13 | Jefferson | Colorado | 8059 | 6754 | 295 |
622183 | 622183 | 2020-10-12 | Jefferson | Colorado | 8059 | 6637 | 265 |
618940 | 618940 | 2020-10-11 | Jefferson | Colorado | 8059 | 6573 | 264 |
615698 | 615698 | 2020-10-10 | Jefferson | Colorado | 8059 | 6492 | 263 |
612457 | 612457 | 2020-10-09 | Jefferson | Colorado | 8059 | 6387 | 262 |
609215 | 609215 | 2020-10-08 | Jefferson | Colorado | 8059 | 6316 | 261 |
605972 | 605972 | 2020-10-07 | Jefferson | Colorado | 8059 | 6222 | 259 |
602730 | 602730 | 2020-10-06 | Jefferson | Colorado | 8059 | 6158 | 257 |
599487 | 599487 | 2020-10-05 | Jefferson | Colorado | 8059 | 6095 | 255 |
596244 | 596244 | 2020-10-04 | Jefferson | Colorado | 8059 | 6059 | 255 |
593002 | 593002 | 2020-10-03 | Jefferson | Colorado | 8059 | 6014 | 254 |
589762 | 589762 | 2020-10-02 | Jefferson | Colorado | 8059 | 5952 | 253 |
586521 | 586521 | 2020-10-01 | Jefferson | Colorado | 8059 | 5902 | 252 |
583281 | 583281 | 2020-09-30 | Jefferson | Colorado | 8059 | 5845 | 251 |
580042 | 580042 | 2020-09-29 | Jefferson | Colorado | 8059 | 5789 | 252 |
576801 | 576801 | 2020-09-28 | Jefferson | Colorado | 8059 | 5745 | 250 |
573558 | 573558 | 2020-09-27 | Jefferson | Colorado | 8059 | 5716 | 248 |
570316 | 570316 | 2020-09-26 | Jefferson | Colorado | 8059 | 5654 | 248 |
567074 | 567074 | 2020-09-25 | Jefferson | Colorado | 8059 | 5598 | 248 |
563834 | 563834 | 2020-09-24 | Jefferson | Colorado | 8059 | 5551 | 248 |
560595 | 560595 | 2020-09-23 | Jefferson | Colorado | 8059 | 5500 | 248 |
557359 | 557359 | 2020-09-22 | Jefferson | Colorado | 8059 | 5470 | 247 |
554122 | 554122 | 2020-09-21 | Jefferson | Colorado | 8059 | 5399 | 247 |
550883 | 550883 | 2020-09-20 | Jefferson | Colorado | 8059 | 5364 | 247 |
547644 | 547644 | 2020-09-19 | Jefferson | Colorado | 8059 | 5317 | 247 |
544406 | 544406 | 2020-09-18 | Jefferson | Colorado | 8059 | 5267 | 247 |
541170 | 541170 | 2020-09-17 | Jefferson | Colorado | 8059 | 5232 | 247 |
537933 | 537933 | 2020-09-16 | Jefferson | Colorado | 8059 | 5194 | 247 |
534697 | 534697 | 2020-09-15 | Jefferson | Colorado | 8059 | 5160 | 246 |
531462 | 531462 | 2020-09-14 | Jefferson | Colorado | 8059 | 5146 | 245 |
528225 | 528225 | 2020-09-13 | Jefferson | Colorado | 8059 | 5117 | 245 |
524989 | 524989 | 2020-09-12 | Jefferson | Colorado | 8059 | 5086 | 245 |
521753 | 521753 | 2020-09-11 | Jefferson | Colorado | 8059 | 5052 | 244 |
518516 | 518516 | 2020-09-10 | Jefferson | Colorado | 8059 | 5019 | 244 |
515281 | 515281 | 2020-09-09 | Jefferson | Colorado | 8059 | 4992 | 242 |
512048 | 512048 | 2020-09-08 | Jefferson | Colorado | 8059 | 4984 | 242 |
508815 | 508815 | 2020-09-07 | Jefferson | Colorado | 8059 | 4971 | 242 |
505583 | 505583 | 2020-09-06 | Jefferson | Colorado | 8059 | 4958 | 243 |
502349 | 502349 | 2020-09-05 | Jefferson | Colorado | 8059 | 4941 | 243 |
499115 | 499115 | 2020-09-04 | Jefferson | Colorado | 8059 | 4911 | 241 |
495882 | 495882 | 2020-09-03 | Jefferson | Colorado | 8059 | 4878 | 238 |
492648 | 492648 | 2020-09-02 | Jefferson | Colorado | 8059 | 4862 | 238 |
489415 | 489415 | 2020-09-01 | Jefferson | Colorado | 8059 | 4834 | 237 |
486182 | 486182 | 2020-08-31 | Jefferson | Colorado | 8059 | 4792 | 237 |
482947 | 482947 | 2020-08-30 | Jefferson | Colorado | 8059 | 4777 | 237 |
479713 | 479713 | 2020-08-29 | Jefferson | Colorado | 8059 | 4766 | 237 |
476480 | 476480 | 2020-08-28 | Jefferson | Colorado | 8059 | 4732 | 236 |
473247 | 473247 | 2020-08-27 | Jefferson | Colorado | 8059 | 4694 | 236 |
470015 | 470015 | 2020-08-26 | Jefferson | Colorado | 8059 | 4670 | 236 |
466786 | 466786 | 2020-08-25 | Jefferson | Colorado | 8059 | 4645 | 235 |
463557 | 463557 | 2020-08-24 | Jefferson | Colorado | 8059 | 4605 | 235 |
460328 | 460328 | 2020-08-23 | Jefferson | Colorado | 8059 | 4587 | 235 |
457101 | 457101 | 2020-08-22 | Jefferson | Colorado | 8059 | 4562 | 235 |
453873 | 453873 | 2020-08-21 | Jefferson | Colorado | 8059 | 4540 | 234 |
450645 | 450645 | 2020-08-20 | Jefferson | Colorado | 8059 | 4501 | 234 |
447417 | 447417 | 2020-08-19 | Jefferson | Colorado | 8059 | 4475 | 234 |
444190 | 444190 | 2020-08-18 | Jefferson | Colorado | 8059 | 4453 | 235 |
440964 | 440964 | 2020-08-17 | Jefferson | Colorado | 8059 | 4429 | 235 |
437738 | 437738 | 2020-08-16 | Jefferson | Colorado | 8059 | 4414 | 235 |
434512 | 434512 | 2020-08-15 | Jefferson | Colorado | 8059 | 4377 | 235 |
431287 | 431287 | 2020-08-14 | Jefferson | Colorado | 8059 | 4362 | 234 |
428059 | 428059 | 2020-08-13 | Jefferson | Colorado | 8059 | 4334 | 233 |
424835 | 424835 | 2020-08-12 | Jefferson | Colorado | 8059 | 4289 | 233 |
421614 | 421614 | 2020-08-11 | Jefferson | Colorado | 8059 | 4258 | 233 |
418393 | 418393 | 2020-08-10 | Jefferson | Colorado | 8059 | 4210 | 228 |
415172 | 415172 | 2020-08-09 | Jefferson | Colorado | 8059 | 4177 | 228 |
411952 | 411952 | 2020-08-08 | Jefferson | Colorado | 8059 | 4160 | 228 |
408733 | 408733 | 2020-08-07 | Jefferson | Colorado | 8059 | 4124 | 228 |
405513 | 405513 | 2020-08-06 | Jefferson | Colorado | 8059 | 4086 | 227 |
402295 | 402295 | 2020-08-05 | Jefferson | Colorado | 8059 | 4051 | 227 |
399079 | 399079 | 2020-08-04 | Jefferson | Colorado | 8059 | 3994 | 227 |
395863 | 395863 | 2020-08-03 | Jefferson | Colorado | 8059 | 3971 | 227 |
392647 | 392647 | 2020-08-02 | Jefferson | Colorado | 8059 | 3950 | 227 |
389430 | 389430 | 2020-08-01 | Jefferson | Colorado | 8059 | 3915 | 227 |
386213 | 386213 | 2020-07-31 | Jefferson | Colorado | 8059 | 3874 | 227 |
382995 | 382995 | 2020-07-30 | Jefferson | Colorado | 8059 | 3821 | 226 |
379778 | 379778 | 2020-07-29 | Jefferson | Colorado | 8059 | 3782 | 225 |
376561 | 376561 | 2020-07-28 | Jefferson | Colorado | 8059 | 3739 | 224 |
373347 | 373347 | 2020-07-27 | Jefferson | Colorado | 8059 | 3676 | 223 |
370135 | 370135 | 2020-07-26 | Jefferson | Colorado | 8059 | 3654 | 221 |
366925 | 366925 | 2020-07-25 | Jefferson | Colorado | 8059 | 3622 | 221 |
363718 | 363718 | 2020-07-24 | Jefferson | Colorado | 8059 | 3527 | 220 |
360511 | 360511 | 2020-07-23 | Jefferson | Colorado | 8059 | 3462 | 220 |
357306 | 357306 | 2020-07-22 | Jefferson | Colorado | 8059 | 3395 | 219 |
354103 | 354103 | 2020-07-21 | Jefferson | Colorado | 8059 | 3348 | 218 |
350901 | 350901 | 2020-07-20 | Jefferson | Colorado | 8059 | 3306 | 218 |
347700 | 347700 | 2020-07-19 | Jefferson | Colorado | 8059 | 3282 | 218 |
344500 | 344500 | 2020-07-18 | Jefferson | Colorado | 8059 | 3252 | 218 |
341301 | 341301 | 2020-07-17 | Jefferson | Colorado | 8059 | 3221 | 218 |
338104 | 338104 | 2020-07-16 | Jefferson | Colorado | 8059 | 3174 | 217 |
334909 | 334909 | 2020-07-15 | Jefferson | Colorado | 8059 | 3118 | 217 |
331716 | 331716 | 2020-07-14 | Jefferson | Colorado | 8059 | 3089 | 217 |
328530 | 328530 | 2020-07-13 | Jefferson | Colorado | 8059 | 3055 | 216 |
325344 | 325344 | 2020-07-12 | Jefferson | Colorado | 8059 | 3026 | 215 |
322163 | 322163 | 2020-07-11 | Jefferson | Colorado | 8059 | 3007 | 215 |
318984 | 318984 | 2020-07-10 | Jefferson | Colorado | 8059 | 2970 | 215 |
315811 | 315811 | 2020-07-09 | Jefferson | Colorado | 8059 | 2922 | 214 |
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);