ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

781 rows where county = "Bryan" and fips = 13029 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 13029 · 781 ✖

county 1

  • Bryan · 781 ✖
Link rowid date ▲ county state fips cases deaths
2499980 2499980 2022-05-13 Bryan Georgia 13029 9218 91
2496722 2496722 2022-05-12 Bryan Georgia 13029 9218 91
2493464 2493464 2022-05-11 Bryan Georgia 13029 9218 91
2490206 2490206 2022-05-10 Bryan Georgia 13029 9198 91
2486949 2486949 2022-05-09 Bryan Georgia 13029 9198 91
2483691 2483691 2022-05-08 Bryan Georgia 13029 9198 91
2480433 2480433 2022-05-07 Bryan Georgia 13029 9198 91
2477175 2477175 2022-05-06 Bryan Georgia 13029 9198 91
2473917 2473917 2022-05-05 Bryan Georgia 13029 9198 91
2470660 2470660 2022-05-04 Bryan Georgia 13029 9198 91
2467404 2467404 2022-05-03 Bryan Georgia 13029 9162 91
2464149 2464149 2022-05-02 Bryan Georgia 13029 9162 91
2460893 2460893 2022-05-01 Bryan Georgia 13029 9162 91
2457637 2457637 2022-04-30 Bryan Georgia 13029 9162 91
2454381 2454381 2022-04-29 Bryan Georgia 13029 9162 91
2451125 2451125 2022-04-28 Bryan Georgia 13029 9162 91
2447869 2447869 2022-04-27 Bryan Georgia 13029 9162 91
2444613 2444613 2022-04-26 Bryan Georgia 13029 9144 91
2441357 2441357 2022-04-25 Bryan Georgia 13029 9144 91
2438101 2438101 2022-04-24 Bryan Georgia 13029 9144 91
2434845 2434845 2022-04-23 Bryan Georgia 13029 9144 91
2431589 2431589 2022-04-22 Bryan Georgia 13029 9144 91
2428333 2428333 2022-04-21 Bryan Georgia 13029 9144 91
2425077 2425077 2022-04-20 Bryan Georgia 13029 9144 91
2421821 2421821 2022-04-19 Bryan Georgia 13029 9131 91
2418565 2418565 2022-04-18 Bryan Georgia 13029 9131 91
2415309 2415309 2022-04-17 Bryan Georgia 13029 9131 91
2412053 2412053 2022-04-16 Bryan Georgia 13029 9131 91
2408797 2408797 2022-04-15 Bryan Georgia 13029 9131 91
2405541 2405541 2022-04-14 Bryan Georgia 13029 9125 91
2402286 2402286 2022-04-13 Bryan Georgia 13029 9128 91
2399031 2399031 2022-04-12 Bryan Georgia 13029 9125 91
2395776 2395776 2022-04-11 Bryan Georgia 13029 9123 91
2392520 2392520 2022-04-10 Bryan Georgia 13029 9114 90
2389264 2389264 2022-04-09 Bryan Georgia 13029 9114 90
2386009 2386009 2022-04-08 Bryan Georgia 13029 9114 90
2382754 2382754 2022-04-07 Bryan Georgia 13029 9112 90
2379499 2379499 2022-04-06 Bryan Georgia 13029 9111 90
2376245 2376245 2022-04-05 Bryan Georgia 13029 9109 90
2372993 2372993 2022-04-04 Bryan Georgia 13029 9104 90
2369740 2369740 2022-04-03 Bryan Georgia 13029 9110 90
2366487 2366487 2022-04-02 Bryan Georgia 13029 9110 90
2363234 2363234 2022-04-01 Bryan Georgia 13029 9110 90
2359980 2359980 2022-03-31 Bryan Georgia 13029 9106 90
2356726 2356726 2022-03-30 Bryan Georgia 13029 9107 90
2353473 2353473 2022-03-29 Bryan Georgia 13029 9105 90
2350221 2350221 2022-03-28 Bryan Georgia 13029 9099 90
2346968 2346968 2022-03-27 Bryan Georgia 13029 9091 90
2343715 2343715 2022-03-26 Bryan Georgia 13029 9091 90
2340462 2340462 2022-03-25 Bryan Georgia 13029 9091 90
2337209 2337209 2022-03-24 Bryan Georgia 13029 9090 89
2333955 2333955 2022-03-23 Bryan Georgia 13029 9088 89
2330701 2330701 2022-03-22 Bryan Georgia 13029 9084 89
2327449 2327449 2022-03-21 Bryan Georgia 13029 9086 89
2324196 2324196 2022-03-20 Bryan Georgia 13029 9080 89
2320942 2320942 2022-03-19 Bryan Georgia 13029 9080 89
2317688 2317688 2022-03-18 Bryan Georgia 13029 9080 89
2314435 2314435 2022-03-17 Bryan Georgia 13029 9082 89
2311182 2311182 2022-03-16 Bryan Georgia 13029 9076 89
2307929 2307929 2022-03-15 Bryan Georgia 13029 9045 88
2304678 2304678 2022-03-14 Bryan Georgia 13029 9008 88
2301426 2301426 2022-03-13 Bryan Georgia 13029 8994 88
2298174 2298174 2022-03-12 Bryan Georgia 13029 8994 88
2294922 2294922 2022-03-11 Bryan Georgia 13029 8994 88
2291670 2291670 2022-03-10 Bryan Georgia 13029 8983 87
2288418 2288418 2022-03-09 Bryan Georgia 13029 8965 86
2285167 2285167 2022-03-08 Bryan Georgia 13029 8949 85
2281915 2281915 2022-03-07 Bryan Georgia 13029 8941 85
2278662 2278662 2022-03-06 Bryan Georgia 13029 8925 85
2275409 2275409 2022-03-05 Bryan Georgia 13029 8925 85
2272156 2272156 2022-03-04 Bryan Georgia 13029 8925 85
2268904 2268904 2022-03-03 Bryan Georgia 13029 8917 85
2265651 2265651 2022-03-02 Bryan Georgia 13029 8915 85
2262400 2262400 2022-03-01 Bryan Georgia 13029 8914 85
2259149 2259149 2022-02-28 Bryan Georgia 13029 8910 84
2255898 2255898 2022-02-27 Bryan Georgia 13029 8906 83
2252647 2252647 2022-02-26 Bryan Georgia 13029 8906 83
2249396 2249396 2022-02-25 Bryan Georgia 13029 8906 83
2246145 2246145 2022-02-24 Bryan Georgia 13029 8904 82
2242894 2242894 2022-02-23 Bryan Georgia 13029 8900 82
2239643 2239643 2022-02-22 Bryan Georgia 13029 8894 82
2236392 2236392 2022-02-21 Bryan Georgia 13029 8888 81
2233141 2233141 2022-02-20 Bryan Georgia 13029 8875 81
2229890 2229890 2022-02-19 Bryan Georgia 13029 8875 81
2226639 2226639 2022-02-18 Bryan Georgia 13029 8875 81
2223388 2223388 2022-02-17 Bryan Georgia 13029 8864 81
2220137 2220137 2022-02-16 Bryan Georgia 13029 8850 81
2216886 2216886 2022-02-15 Bryan Georgia 13029 8834 81
2213635 2213635 2022-02-14 Bryan Georgia 13029 8825 81
2210383 2210383 2022-02-13 Bryan Georgia 13029 8807 81
2207130 2207130 2022-02-12 Bryan Georgia 13029 8807 81
2203877 2203877 2022-02-11 Bryan Georgia 13029 8807 81
2200624 2200624 2022-02-10 Bryan Georgia 13029 8797 81
2197370 2197370 2022-02-09 Bryan Georgia 13029 8768 80
2194116 2194116 2022-02-08 Bryan Georgia 13029 8739 80
2190862 2190862 2022-02-07 Bryan Georgia 13029 8720 80
2187609 2187609 2022-02-06 Bryan Georgia 13029 8667 80
2184356 2184356 2022-02-05 Bryan Georgia 13029 8667 80
2181104 2181104 2022-02-04 Bryan Georgia 13029 8667 80
2177853 2177853 2022-02-03 Bryan Georgia 13029 8622 80

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);