ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 79 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
478137 | 478137 | 2020-08-28 | Gates | North Carolina | 37073 | 79 | 2 |
445819 | 445819 | 2020-08-18 | Camden | North Carolina | 37029 | 79 | 2 |
407174 | 407174 | 2020-08-06 | Jones | North Carolina | 37103 | 79 | 3 |
407183 | 407183 | 2020-08-06 | Mitchell | North Carolina | 37121 | 79 | 2 |
403955 | 403955 | 2020-08-05 | Jones | North Carolina | 37103 | 79 | 3 |
403964 | 403964 | 2020-08-05 | Mitchell | North Carolina | 37121 | 79 | 2 |
400746 | 400746 | 2020-08-04 | Mitchell | North Carolina | 37121 | 79 | 2 |
387826 | 387826 | 2020-07-31 | Avery | North Carolina | 37011 | 79 | 0 |
304786 | 304786 | 2020-07-05 | Polk | North Carolina | 37149 | 79 | 4 |
276331 | 276331 | 2020-06-26 | Alexander | North Carolina | 37003 | 79 | 0 |
276373 | 276373 | 2020-06-26 | Haywood | North Carolina | 37087 | 79 | 0 |
242022 | 242022 | 2020-06-15 | Person | North Carolina | 37145 | 79 | 1 |
238913 | 238913 | 2020-06-14 | Person | North Carolina | 37145 | 79 | 1 |
207961 | 207961 | 2020-06-04 | Stokes | North Carolina | 37169 | 79 | 0 |
198684 | 198684 | 2020-06-01 | Greene | North Carolina | 37079 | 79 | 2 |
189460 | 189460 | 2020-05-29 | Cleveland | North Carolina | 37045 | 79 | 2 |
183350 | 183350 | 2020-05-27 | Davie | North Carolina | 37059 | 79 | 2 |
162107 | 162107 | 2020-05-20 | Onslow | North Carolina | 37133 | 79 | 2 |
132005 | 132005 | 2020-05-10 | Catawba | North Carolina | 37035 | 79 | 1 |
114275 | 114275 | 2020-05-04 | New Hanover | North Carolina | 37129 | 79 | 3 |
111394 | 111394 | 2020-05-03 | New Hanover | North Carolina | 37129 | 79 | 3 |
108521 | 108521 | 2020-05-02 | New Hanover | North Carolina | 37129 | 79 | 3 |
105652 | 105652 | 2020-05-01 | Moore | North Carolina | 37125 | 79 | 3 |
102790 | 102790 | 2020-04-30 | Moore | North Carolina | 37125 | 79 | 3 |
85801 | 85801 | 2020-04-24 | Northampton | North Carolina | 37131 | 79 | 3 |
69071 | 69071 | 2020-04-18 | Iredell | North Carolina | 37097 | 79 | 2 |
29858 | 29858 | 2020-04-03 | Guilford | North Carolina | 37081 | 79 | 3 |
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);