ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 157 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384408 | 2384408 | 2022-04-07 | Unknown | North Dakota | 157 | 47 | |
1357499 | 1357499 | 2021-05-26 | Oliver | North Dakota | 38065 | 157 | 3 |
1354253 | 1354253 | 2021-05-25 | Oliver | North Dakota | 38065 | 157 | 3 |
1351007 | 1351007 | 2021-05-24 | Oliver | North Dakota | 38065 | 157 | 3 |
1347761 | 1347761 | 2021-05-23 | Oliver | North Dakota | 38065 | 157 | 3 |
1344513 | 1344513 | 2021-05-22 | Oliver | North Dakota | 38065 | 157 | 3 |
1341265 | 1341265 | 2021-05-21 | Oliver | North Dakota | 38065 | 157 | 3 |
1338017 | 1338017 | 2021-05-20 | Oliver | North Dakota | 38065 | 157 | 3 |
1334770 | 1334770 | 2021-05-19 | Oliver | North Dakota | 38065 | 157 | 3 |
1331523 | 1331523 | 2021-05-18 | Oliver | North Dakota | 38065 | 157 | 3 |
1328276 | 1328276 | 2021-05-17 | Oliver | North Dakota | 38065 | 157 | 3 |
1325030 | 1325030 | 2021-05-16 | Oliver | North Dakota | 38065 | 157 | 3 |
1321784 | 1321784 | 2021-05-15 | Oliver | North Dakota | 38065 | 157 | 3 |
1318538 | 1318538 | 2021-05-14 | Oliver | North Dakota | 38065 | 157 | 3 |
1315290 | 1315290 | 2021-05-13 | Oliver | North Dakota | 38065 | 157 | 3 |
1312044 | 1312044 | 2021-05-12 | Oliver | North Dakota | 38065 | 157 | 3 |
1308797 | 1308797 | 2021-05-11 | Oliver | North Dakota | 38065 | 157 | 3 |
1305551 | 1305551 | 2021-05-10 | Oliver | North Dakota | 38065 | 157 | 3 |
1302305 | 1302305 | 2021-05-09 | Oliver | North Dakota | 38065 | 157 | 3 |
1299057 | 1299057 | 2021-05-08 | Oliver | North Dakota | 38065 | 157 | 3 |
1295811 | 1295811 | 2021-05-07 | Oliver | North Dakota | 38065 | 157 | 3 |
1292565 | 1292565 | 2021-05-06 | Oliver | North Dakota | 38065 | 157 | 3 |
1289319 | 1289319 | 2021-05-05 | Oliver | North Dakota | 38065 | 157 | 3 |
1286073 | 1286073 | 2021-05-04 | Oliver | North Dakota | 38065 | 157 | 3 |
1282827 | 1282827 | 2021-05-03 | Oliver | North Dakota | 38065 | 157 | 3 |
1279580 | 1279580 | 2021-05-02 | Oliver | North Dakota | 38065 | 157 | 3 |
1065257 | 1065257 | 2021-02-25 | Divide | North Dakota | 38023 | 157 | 2 |
1062013 | 1062013 | 2021-02-24 | Divide | North Dakota | 38023 | 157 | 2 |
851091 | 851091 | 2020-12-21 | Steele | North Dakota | 38091 | 157 | 1 |
847846 | 847846 | 2020-12-20 | Steele | North Dakota | 38091 | 157 | 1 |
795889 | 795889 | 2020-12-04 | Grant | North Dakota | 38037 | 157 | 6 |
792644 | 792644 | 2020-12-03 | Grant | North Dakota | 38037 | 157 | 6 |
789399 | 789399 | 2020-12-02 | Grant | North Dakota | 38037 | 157 | 6 |
760175 | 760175 | 2020-11-23 | Adams | North Dakota | 38001 | 157 | 0 |
756929 | 756929 | 2020-11-22 | Adams | North Dakota | 38001 | 157 | 0 |
740718 | 740718 | 2020-11-17 | Kidder | North Dakota | 38043 | 157 | 5 |
730999 | 730999 | 2020-11-14 | Renville | North Dakota | 38075 | 157 | 2 |
714765 | 714765 | 2020-11-09 | Hettinger | North Dakota | 38041 | 157 | 3 |
711506 | 711506 | 2020-11-08 | Bowman | North Dakota | 38011 | 157 | 3 |
708262 | 708262 | 2020-11-07 | Bowman | North Dakota | 38011 | 157 | 3 |
695318 | 695318 | 2020-11-03 | Pierce | North Dakota | 38069 | 157 | 2 |
662881 | 662881 | 2020-10-24 | Nelson | North Dakota | 38063 | 157 | 3 |
636921 | 636921 | 2020-10-16 | Pembina | North Dakota | 38067 | 157 | 0 |
517004 | 517004 | 2020-09-09 | Barnes | North Dakota | 38003 | 157 | 0 |
513769 | 513769 | 2020-09-08 | Barnes | North Dakota | 38003 | 157 | 0 |
510585 | 510585 | 2020-09-07 | Walsh | North Dakota | 38099 | 157 | 1 |
429777 | 429777 | 2020-08-13 | Benson | North Dakota | 38005 | 157 | 2 |
352653 | 352653 | 2020-07-20 | Williams | North Dakota | 38105 | 157 | 1 |
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);