ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 410 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2124159 | 2124159 | 2022-01-17 | Golden Valley | North Dakota | 38033 | 410 | 4 |
2101403 | 2101403 | 2022-01-10 | Kidder | North Dakota | 38043 | 410 | 13 |
2098152 | 2098152 | 2022-01-09 | Kidder | North Dakota | 38043 | 410 | 13 |
2094900 | 2094900 | 2022-01-08 | Kidder | North Dakota | 38043 | 410 | 13 |
2091648 | 2091648 | 2022-01-07 | Kidder | North Dakota | 38043 | 410 | 13 |
1942119 | 1942119 | 2021-11-22 | Griggs | North Dakota | 38039 | 410 | 2 |
1938869 | 1938869 | 2021-11-21 | Griggs | North Dakota | 38039 | 410 | 2 |
1935619 | 1935619 | 2021-11-20 | Griggs | North Dakota | 38039 | 410 | 2 |
1896639 | 1896639 | 2021-11-08 | Renville | North Dakota | 38075 | 410 | 14 |
1730919 | 1730919 | 2021-09-18 | McIntosh | North Dakota | 38051 | 410 | 7 |
1591217 | 1591217 | 2021-08-06 | Bowman | North Dakota | 38011 | 410 | 5 |
1234104 | 1234104 | 2021-04-18 | Emmons | North Dakota | 38029 | 410 | 13 |
1230856 | 1230856 | 2021-04-17 | Emmons | North Dakota | 38029 | 410 | 13 |
1227608 | 1227608 | 2021-04-16 | Emmons | North Dakota | 38029 | 410 | 13 |
1224360 | 1224360 | 2021-04-15 | Emmons | North Dakota | 38029 | 410 | 13 |
1169148 | 1169148 | 2021-03-29 | Emmons | North Dakota | 38029 | 410 | 13 |
941964 | 941964 | 2021-01-18 | Wells | North Dakota | 38103 | 410 | 8 |
938719 | 938719 | 2021-01-17 | Wells | North Dakota | 38103 | 410 | 8 |
935474 | 935474 | 2021-01-16 | Wells | North Dakota | 38103 | 410 | 8 |
932229 | 932229 | 2021-01-15 | Wells | North Dakota | 38103 | 410 | 8 |
928941 | 928941 | 2021-01-14 | Cavalier | North Dakota | 38019 | 410 | 4 |
925696 | 925696 | 2021-01-13 | Cavalier | North Dakota | 38019 | 410 | 4 |
922450 | 922450 | 2021-01-12 | Cavalier | North Dakota | 38019 | 410 | 4 |
919205 | 919205 | 2021-01-11 | Cavalier | North Dakota | 38019 | 410 | 4 |
915960 | 915960 | 2021-01-10 | Cavalier | North Dakota | 38019 | 410 | 4 |
912715 | 912715 | 2021-01-09 | Cavalier | North Dakota | 38019 | 410 | 4 |
912746 | 912746 | 2021-01-09 | Sargent | North Dakota | 38081 | 410 | 5 |
909470 | 909470 | 2021-01-08 | Cavalier | North Dakota | 38019 | 410 | 4 |
909501 | 909501 | 2021-01-08 | Sargent | North Dakota | 38081 | 410 | 5 |
906225 | 906225 | 2021-01-07 | Cavalier | North Dakota | 38019 | 410 | 4 |
906256 | 906256 | 2021-01-07 | Sargent | North Dakota | 38081 | 410 | 5 |
890019 | 890019 | 2021-01-02 | Nelson | North Dakota | 38063 | 410 | 11 |
886772 | 886772 | 2021-01-01 | Nelson | North Dakota | 38063 | 410 | 11 |
750451 | 750451 | 2020-11-20 | Foster | North Dakota | 38031 | 410 | 2 |
688799 | 688799 | 2020-11-01 | Barnes | North Dakota | 38003 | 410 | 1 |
623913 | 623913 | 2020-10-12 | Benson | North Dakota | 38005 | 410 | 8 |
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);