ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Union" and fips = 5139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534602 | 534602 | 2020-09-15 | Union | Arkansas | 5139 | 816 | 31 |
531367 | 531367 | 2020-09-14 | Union | Arkansas | 5139 | 801 | 25 |
528130 | 528130 | 2020-09-13 | Union | Arkansas | 5139 | 796 | 25 |
524894 | 524894 | 2020-09-12 | Union | Arkansas | 5139 | 785 | 25 |
521658 | 521658 | 2020-09-11 | Union | Arkansas | 5139 | 770 | 25 |
518421 | 518421 | 2020-09-10 | Union | Arkansas | 5139 | 755 | 25 |
515186 | 515186 | 2020-09-09 | Union | Arkansas | 5139 | 748 | 25 |
511953 | 511953 | 2020-09-08 | Union | Arkansas | 5139 | 740 | 22 |
508720 | 508720 | 2020-09-07 | Union | Arkansas | 5139 | 731 | 22 |
505488 | 505488 | 2020-09-06 | Union | Arkansas | 5139 | 725 | 22 |
502254 | 502254 | 2020-09-05 | Union | Arkansas | 5139 | 724 | 21 |
499020 | 499020 | 2020-09-04 | Union | Arkansas | 5139 | 721 | 21 |
495787 | 495787 | 2020-09-03 | Union | Arkansas | 5139 | 707 | 21 |
492553 | 492553 | 2020-09-02 | Union | Arkansas | 5139 | 698 | 20 |
489320 | 489320 | 2020-09-01 | Union | Arkansas | 5139 | 692 | 20 |
486087 | 486087 | 2020-08-31 | Union | Arkansas | 5139 | 691 | 20 |
482852 | 482852 | 2020-08-30 | Union | Arkansas | 5139 | 690 | 19 |
479618 | 479618 | 2020-08-29 | Union | Arkansas | 5139 | 689 | 20 |
476385 | 476385 | 2020-08-28 | Union | Arkansas | 5139 | 683 | 20 |
473152 | 473152 | 2020-08-27 | Union | Arkansas | 5139 | 670 | 20 |
469920 | 469920 | 2020-08-26 | Union | Arkansas | 5139 | 653 | 20 |
466691 | 466691 | 2020-08-25 | Union | Arkansas | 5139 | 650 | 21 |
463462 | 463462 | 2020-08-24 | Union | Arkansas | 5139 | 634 | 21 |
460233 | 460233 | 2020-08-23 | Union | Arkansas | 5139 | 627 | 21 |
457006 | 457006 | 2020-08-22 | Union | Arkansas | 5139 | 624 | 21 |
453778 | 453778 | 2020-08-21 | Union | Arkansas | 5139 | 612 | 21 |
450550 | 450550 | 2020-08-20 | Union | Arkansas | 5139 | 597 | 21 |
447322 | 447322 | 2020-08-19 | Union | Arkansas | 5139 | 589 | 21 |
444095 | 444095 | 2020-08-18 | Union | Arkansas | 5139 | 578 | 21 |
440869 | 440869 | 2020-08-17 | Union | Arkansas | 5139 | 561 | 20 |
437643 | 437643 | 2020-08-16 | Union | Arkansas | 5139 | 556 | 20 |
434417 | 434417 | 2020-08-15 | Union | Arkansas | 5139 | 553 | 20 |
431192 | 431192 | 2020-08-14 | Union | Arkansas | 5139 | 539 | 20 |
427964 | 427964 | 2020-08-13 | Union | Arkansas | 5139 | 532 | 19 |
424740 | 424740 | 2020-08-12 | Union | Arkansas | 5139 | 523 | 19 |
421519 | 421519 | 2020-08-11 | Union | Arkansas | 5139 | 508 | 18 |
418298 | 418298 | 2020-08-10 | Union | Arkansas | 5139 | 504 | 18 |
415077 | 415077 | 2020-08-09 | Union | Arkansas | 5139 | 499 | 17 |
411857 | 411857 | 2020-08-08 | Union | Arkansas | 5139 | 478 | 17 |
408638 | 408638 | 2020-08-07 | Union | Arkansas | 5139 | 472 | 17 |
405418 | 405418 | 2020-08-06 | Union | Arkansas | 5139 | 464 | 17 |
402200 | 402200 | 2020-08-05 | Union | Arkansas | 5139 | 458 | 17 |
398984 | 398984 | 2020-08-04 | Union | Arkansas | 5139 | 452 | 17 |
395768 | 395768 | 2020-08-03 | Union | Arkansas | 5139 | 435 | 16 |
392552 | 392552 | 2020-08-02 | Union | Arkansas | 5139 | 433 | 16 |
389335 | 389335 | 2020-08-01 | Union | Arkansas | 5139 | 430 | 16 |
386118 | 386118 | 2020-07-31 | Union | Arkansas | 5139 | 428 | 16 |
382900 | 382900 | 2020-07-30 | Union | Arkansas | 5139 | 396 | 16 |
379683 | 379683 | 2020-07-29 | Union | Arkansas | 5139 | 379 | 16 |
376467 | 376467 | 2020-07-28 | Union | Arkansas | 5139 | 376 | 15 |
373253 | 373253 | 2020-07-27 | Union | Arkansas | 5139 | 373 | 15 |
370041 | 370041 | 2020-07-26 | Union | Arkansas | 5139 | 369 | 15 |
366831 | 366831 | 2020-07-25 | Union | Arkansas | 5139 | 361 | 15 |
363624 | 363624 | 2020-07-24 | Union | Arkansas | 5139 | 350 | 15 |
360417 | 360417 | 2020-07-23 | Union | Arkansas | 5139 | 345 | 15 |
357212 | 357212 | 2020-07-22 | Union | Arkansas | 5139 | 335 | 14 |
354009 | 354009 | 2020-07-21 | Union | Arkansas | 5139 | 333 | 14 |
350807 | 350807 | 2020-07-20 | Union | Arkansas | 5139 | 313 | 14 |
347606 | 347606 | 2020-07-19 | Union | Arkansas | 5139 | 306 | 14 |
344406 | 344406 | 2020-07-18 | Union | Arkansas | 5139 | 305 | 14 |
341207 | 341207 | 2020-07-17 | Union | Arkansas | 5139 | 292 | 14 |
338011 | 338011 | 2020-07-16 | Union | Arkansas | 5139 | 287 | 14 |
334816 | 334816 | 2020-07-15 | Union | Arkansas | 5139 | 284 | 14 |
331623 | 331623 | 2020-07-14 | Union | Arkansas | 5139 | 282 | 14 |
328437 | 328437 | 2020-07-13 | Union | Arkansas | 5139 | 275 | 14 |
325251 | 325251 | 2020-07-12 | Union | Arkansas | 5139 | 274 | 14 |
322070 | 322070 | 2020-07-11 | Union | Arkansas | 5139 | 273 | 14 |
318891 | 318891 | 2020-07-10 | Union | Arkansas | 5139 | 267 | 13 |
315718 | 315718 | 2020-07-09 | Union | Arkansas | 5139 | 266 | 13 |
312543 | 312543 | 2020-07-08 | Union | Arkansas | 5139 | 264 | 13 |
309373 | 309373 | 2020-07-07 | Union | Arkansas | 5139 | 256 | 13 |
306205 | 306205 | 2020-07-06 | Union | Arkansas | 5139 | 253 | 13 |
303041 | 303041 | 2020-07-05 | Union | Arkansas | 5139 | 252 | 13 |
299877 | 299877 | 2020-07-04 | Union | Arkansas | 5139 | 252 | 13 |
296715 | 296715 | 2020-07-03 | Union | Arkansas | 5139 | 252 | 13 |
293559 | 293559 | 2020-07-02 | Union | Arkansas | 5139 | 250 | 13 |
290405 | 290405 | 2020-07-01 | Union | Arkansas | 5139 | 249 | 13 |
287254 | 287254 | 2020-06-30 | Union | Arkansas | 5139 | 248 | 13 |
284108 | 284108 | 2020-06-29 | Union | Arkansas | 5139 | 247 | 13 |
280962 | 280962 | 2020-06-28 | Union | Arkansas | 5139 | 245 | 13 |
277815 | 277815 | 2020-06-27 | Union | Arkansas | 5139 | 245 | 13 |
274667 | 274667 | 2020-06-26 | Union | Arkansas | 5139 | 243 | 13 |
271527 | 271527 | 2020-06-25 | Union | Arkansas | 5139 | 237 | 13 |
268392 | 268392 | 2020-06-24 | Union | Arkansas | 5139 | 232 | 13 |
265262 | 265262 | 2020-06-23 | Union | Arkansas | 5139 | 232 | 13 |
262134 | 262134 | 2020-06-22 | Union | Arkansas | 5139 | 227 | 13 |
259007 | 259007 | 2020-06-21 | Union | Arkansas | 5139 | 224 | 13 |
255880 | 255880 | 2020-06-20 | Union | Arkansas | 5139 | 223 | 13 |
252761 | 252761 | 2020-06-19 | Union | Arkansas | 5139 | 220 | 13 |
249646 | 249646 | 2020-06-18 | Union | Arkansas | 5139 | 218 | 13 |
246534 | 246534 | 2020-06-17 | Union | Arkansas | 5139 | 213 | 11 |
243421 | 243421 | 2020-06-16 | Union | Arkansas | 5139 | 209 | 11 |
240310 | 240310 | 2020-06-15 | Union | Arkansas | 5139 | 208 | 11 |
237202 | 237202 | 2020-06-14 | Union | Arkansas | 5139 | 203 | 11 |
234095 | 234095 | 2020-06-13 | Union | Arkansas | 5139 | 202 | 11 |
230989 | 230989 | 2020-06-12 | Union | Arkansas | 5139 | 199 | 11 |
227886 | 227886 | 2020-06-11 | Union | Arkansas | 5139 | 194 | 11 |
224784 | 224784 | 2020-06-10 | Union | Arkansas | 5139 | 190 | 11 |
221689 | 221689 | 2020-06-09 | Union | Arkansas | 5139 | 190 | 11 |
218594 | 218594 | 2020-06-08 | Union | Arkansas | 5139 | 188 | 11 |
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);