ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Coke", deaths = 10 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
971778 | 971778 | 2021-01-27 | Coke | Texas | 48081 | 431 | 10 |
968533 | 968533 | 2021-01-26 | Coke | Texas | 48081 | 429 | 10 |
965289 | 965289 | 2021-01-25 | Coke | Texas | 48081 | 417 | 10 |
962044 | 962044 | 2021-01-24 | Coke | Texas | 48081 | 437 | 10 |
958799 | 958799 | 2021-01-23 | Coke | Texas | 48081 | 437 | 10 |
955553 | 955553 | 2021-01-22 | Coke | Texas | 48081 | 438 | 10 |
952308 | 952308 | 2021-01-21 | Coke | Texas | 48081 | 437 | 10 |
949063 | 949063 | 2021-01-20 | Coke | Texas | 48081 | 435 | 10 |
945817 | 945817 | 2021-01-19 | Coke | Texas | 48081 | 430 | 10 |
942570 | 942570 | 2021-01-18 | Coke | Texas | 48081 | 426 | 10 |
939325 | 939325 | 2021-01-17 | Coke | Texas | 48081 | 426 | 10 |
936080 | 936080 | 2021-01-16 | Coke | Texas | 48081 | 424 | 10 |
932835 | 932835 | 2021-01-15 | Coke | Texas | 48081 | 425 | 10 |
929590 | 929590 | 2021-01-14 | Coke | Texas | 48081 | 419 | 10 |
926345 | 926345 | 2021-01-13 | Coke | Texas | 48081 | 418 | 10 |
923099 | 923099 | 2021-01-12 | Coke | Texas | 48081 | 415 | 10 |
919854 | 919854 | 2021-01-11 | Coke | Texas | 48081 | 415 | 10 |
916609 | 916609 | 2021-01-10 | Coke | Texas | 48081 | 413 | 10 |
913364 | 913364 | 2021-01-09 | Coke | Texas | 48081 | 412 | 10 |
910119 | 910119 | 2021-01-08 | Coke | Texas | 48081 | 412 | 10 |
906874 | 906874 | 2021-01-07 | Coke | Texas | 48081 | 411 | 10 |
903628 | 903628 | 2021-01-06 | Coke | Texas | 48081 | 408 | 10 |
900383 | 900383 | 2021-01-05 | Coke | Texas | 48081 | 396 | 10 |
897138 | 897138 | 2021-01-04 | Coke | Texas | 48081 | 396 | 10 |
893892 | 893892 | 2021-01-03 | Coke | Texas | 48081 | 396 | 10 |
890646 | 890646 | 2021-01-02 | Coke | Texas | 48081 | 393 | 10 |
887399 | 887399 | 2021-01-01 | Coke | Texas | 48081 | 393 | 10 |
884154 | 884154 | 2020-12-31 | Coke | Texas | 48081 | 391 | 10 |
880909 | 880909 | 2020-12-30 | Coke | Texas | 48081 | 387 | 10 |
877664 | 877664 | 2020-12-29 | Coke | Texas | 48081 | 381 | 10 |
874419 | 874419 | 2020-12-28 | Coke | Texas | 48081 | 376 | 10 |
871174 | 871174 | 2020-12-27 | Coke | Texas | 48081 | 376 | 10 |
867929 | 867929 | 2020-12-26 | Coke | Texas | 48081 | 376 | 10 |
864684 | 864684 | 2020-12-25 | Coke | Texas | 48081 | 369 | 10 |
861439 | 861439 | 2020-12-24 | Coke | Texas | 48081 | 369 | 10 |
858194 | 858194 | 2020-12-23 | Coke | Texas | 48081 | 368 | 10 |
854949 | 854949 | 2020-12-22 | Coke | Texas | 48081 | 365 | 10 |
851704 | 851704 | 2020-12-21 | Coke | Texas | 48081 | 354 | 10 |
848459 | 848459 | 2020-12-20 | Coke | Texas | 48081 | 353 | 10 |
845214 | 845214 | 2020-12-19 | Coke | Texas | 48081 | 353 | 10 |
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);