_analyze_tables_
350 rows sorted by least_common descending
This data as json, CSV (advanced)
Suggested facets: num_blank
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common ▲ |
---|---|---|---|---|---|---|---|---|
labels_pull_requests,labels_id | labels_pull_requests | labels_id | 163 | 0 | 0 | 26 | [[1970143153, 92], [993377884, 11], [993222446, 6], [727708734, 6], [2374328705, 5], [1405404904, 5], [1379448359, 5], [754269786, 5], [750789605, 4], [754730474, 3]] | [[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2459412274, 1], [3645705798, 1], [3799780031, 1], [4251477726, 1], [4860121561, 1]] |
issues,milestone | issues | milestone | 2892 | 2293 | 0 | 33 | [["None", 2293], [3268330, 110], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [7571612, 24], [8658075, 23], [4305096, 22], [2949431, 21]] | [[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [7867486, 6], [3439337, 7], [5225818, 7], [6079500, 7]] |
repos,size | repos | size | 1329 | 0 | 0 | 700 | [[8, 36], [0, 36], [3, 33], [9, 28], [11, 27], [4, 25], [7, 23], [5, 23], [10, 22], [17, 17]] | [[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, 1], [3264862, 1], [3875967, 1], [5200284, 1], [5204108, 1]] |
dependents,dependent | dependents | dependent | 1658 | 0 | 0 | 1328 | [[138329050, 2], [112050382, 2], [107914493, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [24275324, 2], [18156953, 2], [5832996, 2]] | [[663556926, 1], [663586533, 1], [664178911, 1], [664727381, 1], [664733539, 1], [664753575, 1], [664756551, 1], [664757179, 1], [665383572, 1], [665620099, 1]] |
issue_comments_fts_idx,pgno | issue_comments_fts_idx | pgno | 943 | 0 | 0 | 288 | [[24, 6], [22, 6], [20, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [2, 6]] | [[626, 1], [628, 1], [630, 1], [632, 1], [636, 1], [638, 1], [640, 1], [642, 1], [644, 1], [646, 1]] |
issues,user | issues | user | 2892 | 0 | 0 | 401 | [[9599, 1991], [49699333, 70], [536941, 32], [45057, 26], [27856297, 22], [25778, 22], [82988, 18], [192568, 16], [7908073, 14], [3243482, 14]] | [[57859326, 1], [69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1], [130708713, 1]] |
pull_requests,milestone | pull_requests | milestone | 560 | 527 | 0 | 14 | [["None", 527], [6026070, 6], [8711695, 3], [6346396, 3], [5512395, 3], [5471110, 3], [3268330, 3], [7558727, 2], [5971510, 2], [4471010, 2]] | [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510, 2], [7558727, 2], [8355157, 2], [6346396, 3], [8711695, 3]] |
issue_comments,user | issue_comments | user | 9947 | 0 | 0 | 367 | [[9599, 8456], [22429695, 204], [536941, 79], [25778, 70], [45057, 39], [82988, 35], [3243482, 26], [193185, 24], [95570, 24], [192568, 22]] | [[49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [80409402, 1], [89400147, 1], [95520595, 1], [102771161, 1]] |
repos,network_count | repos | network_count | 1329 | 0 | 0 | 69 | [[0, 1017], [1, 108], [2, 33], [48, 31], [3, 17], [5, 12], [4, 12], [11, 11], [6, 10], [7, 6]] | [[439, 1], [443, 1], [446, 1], [449, 1], [452, 1], [460, 1], [461, 1], [487, 1], [511, 1], [518, 1]] |
pull_requests,user | pull_requests | user | 560 | 0 | 0 | 179 | [[9599, 195], [49699333, 70], [27856297, 21], [45057, 19], [536941, 8], [25778, 8], [3243482, 7], [2657547, 6], [26161409, 5], [49260, 4]] | [[37962604, 1], [39452697, 1], [56323389, 1], [72577720, 1], [87192257, 1], [91880982, 1], [99098079, 1], [102635518, 1], [111973926, 1], [130708713, 1]] |
repos,stargazers_count | repos | stargazers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,watchers_count | repos | watchers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,watchers | repos | watchers | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
issues,comments | issues | comments | 2892 | 0 | 0 | 44 | [[1, 721], [0, 546], [2, 456], [3, 328], [4, 205], [5, 122], [6, 99], [7, 74], [8, 53], [9, 51]] | [[31, 1], [33, 1], [34, 1], [36, 1], [40, 1], [42, 1], [47, 1], [49, 1], [51, 1], [54, 1]] |
repos,open_issues_count | repos | open_issues_count | 1329 | 0 | 0 | 34 | [[0, 983], [1, 122], [2, 48], [3, 39], [4, 38], [5, 19], [7, 11], [6, 11], [8, 7], [11, 6]] | [[30, 1], [34, 1], [36, 1], [38, 1], [43, 1], [46, 1], [77, 1], [83, 1], [138, 1], [528, 1]] |
repos,open_issues | repos | open_issues | 1329 | 0 | 0 | 34 | [[0, 983], [1, 122], [2, 48], [3, 39], [4, 38], [5, 19], [7, 11], [6, 11], [8, 7], [11, 6]] | [[30, 1], [34, 1], [36, 1], [38, 1], [43, 1], [46, 1], [77, 1], [83, 1], [138, 1], [528, 1]] |
steps,job | steps | job | 262 | 0 | 0 | 54 | [[27508, 13], [27488, 12], [27466, 11], [27499, 8], [27507, 7], [27493, 7], [27497, 6], [27460, 5], [27459, 5], [27458, 5]] | [[27489, 1], [27503, 1], [26772, 2], [27494, 2], [27495, 2], [27500, 2], [27501, 2], [27469, 3], [27485, 3], [27490, 4]] |
issues_fts_idx,pgno | issues_fts_idx | pgno | 412 | 0 | 0 | 155 | [[20, 3], [18, 3], [16, 3], [14, 3], [12, 3], [10, 3], [8, 3], [6, 3], [4, 3], [2, 3]] | [[268, 1], [274, 1], [278, 1], [306, 1], [308, 1], [310, 1], [298, 2], [300, 2], [302, 2], [304, 2]] |
steps,repo | steps | repo | 262 | 0 | 0 | 12 | [[107914493, 72], [140912432, 41], [207052882, 29], [206156866, 18], [303218369, 15], [248903544, 15], [197882382, 15], [197431109, 15], [611552758, 13], [205429375, 12]] | [[256834907, 5], [205429375, 12], [213286752, 12], [611552758, 13], [197431109, 15], [197882382, 15], [248903544, 15], [303218369, 15], [206156866, 18], [207052882, 29]] |
jobs,repo | jobs | repo | 54 | 0 | 0 | 12 | [[107914493, 16], [140912432, 7], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [213286752, 3], [205429375, 3], [197882382, 3], [197431109, 3]] | [[256834907, 1], [197431109, 3], [197882382, 3], [205429375, 3], [213286752, 3], [248903544, 3], [303218369, 3], [611552758, 3], [206156866, 4], [207052882, 5]] |
workflows,repo | workflows | repo | 41 | 0 | 0 | 12 | [[107914493, 13], [140912432, 6], [207052882, 4], [206156866, 3], [303218369, 2], [248903544, 2], [213286752, 2], [205429375, 2], [197882382, 2], [197431109, 2]] | [[256834907, 1], [197431109, 2], [197882382, 2], [205429375, 2], [213286752, 2], [248903544, 2], [303218369, 2], [611552758, 2], [206156866, 3], [207052882, 4]] |
_analyze_tables_,total_rows | _analyze_tables_ | total_rows | 350 | 0 | 0 | 37 | [[1329, 61], [1, 43], [2892, 27], [560, 27], [34, 19], [344, 18], [9947, 15], [10621, 13], [3784, 12], [103, 11]] | [[25, 2], [47, 2], [50, 2], [126, 2], [163, 2], [420, 2], [688, 2], [3206, 2], [1877, 3], [11236, 3]] |
repos,forks_count | repos | forks_count | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
repos,forks | repos | forks | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
contributors,user_id | contributors | user_id | 131 | 0 | 0 | 108 | [[9599, 16], [41546558, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2], [2182, 1]] | [[22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
contributors,contributions | contributors | contributions | 131 | 0 | 0 | 23 | [[1, 92], [2, 11], [3, 5], [5, 3], [6, 2], [13, 1], [11, 1], [10, 1], [9, 1], [4, 1]] | [[21, 1], [30, 1], [34, 1], [40, 1], [49, 1], [61, 1], [128, 1], [165, 1], [828, 1], [2011, 1]] |
tags,repo | tags | repo | 368 | 0 | 0 | 15 | [[107914493, 134], [140912432, 119], [206156866, 29], [207052882, 23], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]] | [[209590345, 1], [611552758, 1], [206649770, 2], [206202864, 3], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9]] |
releases,repo | releases | repo | 344 | 0 | 0 | 14 | [[107914493, 126], [140912432, 108], [206156866, 28], [207052882, 22], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]] | [[209590345, 1], [611552758, 1], [206202864, 2], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9], [197431109, 20]] |
commits,repo | commits | repo | 3784 | 0 | 0 | 16 | [[107914493, 2314], [140912432, 901], [207052882, 176], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 36], [197882382, 30], [213286752, 22], [303218369, 19]] | [[209590345, 1], [206649770, 6], [611552758, 9], [206202864, 10], [214746582, 13], [248903544, 13], [303218369, 19], [213286752, 22], [197882382, 30], [205429375, 36]] |
issues,number | issues | number | 2892 | 0 | 0 | 2009 | [[2, 16], [1, 16], [6, 14], [5, 14], [4, 14], [3, 14], [8, 13], [7, 13], [10, 12], [9, 12]] | [[2095, 1], [2096, 1], [2097, 1], [2098, 1], [2099, 1], [2100, 1], [2101, 1], [2102, 1], [2103, 1], [2104, 1]] |
pull_requests,number | pull_requests | number | 560 | 0 | 0 | 517 | [[8, 4], [5, 4], [67, 3], [65, 3], [15, 3], [6, 3], [9, 2], [7, 2], [4, 2], [1, 2]] | [[2075, 1], [2076, 1], [2077, 1], [2080, 1], [2082, 1], [2083, 1], [2096, 1], [2098, 1], [2099, 1], [2100, 1]] |
jobs,workflow | jobs | workflow | 54 | 0 | 0 | 41 | [[20702, 4], [20695, 2], [20693, 2], [20691, 2], [20689, 2], [20687, 2], [20684, 2], [20681, 2], [20678, 2], [20676, 2]] | [[20705, 1], [20706, 1], [20707, 1], [20708, 1], [20709, 1], [20710, 1], [20711, 1], [20713, 1], [20714, 1], [20715, 1]] |
stars,repo | stars | repo | 11236 | 0 | 0 | 16 | [[107914493, 8162], [140912432, 1255], [206156866, 402], [207052882, 324], [197431109, 176], [197882382, 169], [256834907, 163], [611552758, 125], [214746582, 119], [213286752, 94]] | [[206202864, 6], [209590345, 20], [303218369, 35], [248903544, 44], [205429375, 55], [206649770, 87], [213286752, 94], [214746582, 119], [611552758, 125], [256834907, 163]] |
issues,repo | issues | repo | 2892 | 0 | 0 | 16 | [[107914493, 1994], [140912432, 565], [207052882, 79], [206156866, 72], [256834907, 37], [197431109, 36], [197882382, 24], [303218369, 15], [205429375, 15], [611552758, 13]] | [[206202864, 2], [209590345, 2], [248903544, 6], [214746582, 8], [206649770, 12], [213286752, 12], [611552758, 13], [205429375, 15], [303218369, 15], [197882382, 24]] |
issues_labels,labels_id | issues_labels | labels_id | 3206 | 0 | 0 | 103 | [[727708732, 263], [729585263, 232], [993377884, 209], [750789605, 197], [727708734, 186], [754269786, 176], [947261894, 138], [1970143153, 96], [2374328705, 91], [1379448359, 88]] | [[2051881526, 1], [2245226086, 1], [2418058309, 1], [2459412274, 1], [3609901844, 1], [3750508178, 1], [3867322234, 1], [4795091971, 1], [5243620954, 1], [5243620957, 1]] |
pull_requests,repo | pull_requests | repo | 560 | 0 | 0 | 14 | [[107914493, 400], [140912432, 102], [206156866, 13], [207052882, 11], [197882382, 7], [214746582, 6], [256834907, 5], [303218369, 4], [206649770, 4], [205429375, 3]] | [[197431109, 1], [213286752, 1], [611552758, 1], [248903544, 2], [205429375, 3], [206649770, 4], [303218369, 4], [256834907, 5], [214746582, 6], [197882382, 7]] |
contributors,repo_id | contributors | repo_id | 131 | 0 | 0 | 16 | [[107914493, 73], [140912432, 30], [207052882, 5], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [213286752, 2], [197431109, 1]] | [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [248903544, 1], [611552758, 1], [213286752, 2], [256834907, 2], [303218369, 2]] |
milestones,number | milestones | number | 34 | 0 | 0 | 27 | [[1, 4], [7, 2], [6, 2], [5, 2], [3, 2], [11, 1], [10, 1], [8, 1], [4, 1], [2, 1]] | [[19, 1], [20, 1], [21, 1], [22, 1], [23, 1], [24, 1], [25, 1], [26, 1], [27, 1], [28, 1]] |
_analyze_tables_,num_distinct | _analyze_tables_ | num_distinct | 350 | 0 | 0 | 126 | [[1, 71], [2, 25], [16, 13], [3, 12], [34, 9], [560, 7], [6, 7], [1329, 6], [344, 6], [0, 6]] | [[1877, 1], [2009, 1], [2033, 1], [2084, 1], [2782, 1], [2890, 1], [3656, 1], [3781, 1], [9675, 1], [11232, 1]] |
issues_labels,issues_id | issues_labels | issues_id | 3206 | 0 | 0 | 2033 | [[775666296, 7], [647103735, 6], [323658641, 6], [1122557010, 5], [726094754, 5], [725184645, 5], [652961907, 5], [582526961, 5], [573755726, 5], [317714268, 4]] | [[1784794489, 1], [1786243905, 1], [1795051447, 1], [1795187493, 1], [1795219865, 1], [1796830110, 1], [1798901709, 1], [1801394744, 1], [1808116827, 1], [1808215339, 1]] |
issue_comments,issue | issue_comments | issue | 9947 | 0 | 0 | 2346 | [[627794879, 54], [849978964, 51], [1551694938, 49], [1450363982, 48], [973139047, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40]] | [[1718576761, 1], [1718612569, 1], [1720096994, 1], [1733198948, 1], [1740026046, 1], [1777548699, 1], [1784794489, 1], [1785360409, 1], [1786258502, 1], [1803264272, 1]] |
commits,author | commits | author | 3784 | 8 | 0 | 107 | [[9599, 3540], [49699333, 48], [45057, 20], [27856297, 17], ["None", 8], [21148, 7], [198537, 6], [25778, 6], [3243482, 5], [2657547, 5]] | [[16001974, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
milestones,closed_issues | milestones | closed_issues | 34 | 0 | 0 | 24 | [[11, 3], [8, 3], [7, 3], [21, 2], [15, 2], [4, 2], [3, 2], [2, 1], [1, 1], [0, 1]] | [[16, 1], [19, 1], [22, 1], [23, 1], [24, 1], [25, 1], [39, 1], [49, 1], [53, 1], [58, 1]] |
repos,subscribers_count | repos | subscribers_count | 1329 | 0 | 0 | 20 | [[1, 897], [0, 178], [2, 122], [3, 51], [4, 24], [6, 13], [5, 13], [7, 8], [8, 4], [9, 3]] | [[14, 1], [20, 1], [23, 1], [56, 1], [94, 1], [102, 1], [154, 1], [10, 3], [11, 3], [12, 3]] |
labels_pull_requests,pull_requests_id | labels_pull_requests | pull_requests_id | 163 | 0 | 0 | 146 | [[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2], [513106026, 2], [511005542, 2], [481616704, 2], [431478724, 2], [296735320, 2]] | [[1327188997, 1], [1333843584, 1], [1350861558, 1], [1358254580, 1], [1358282799, 1], [1358321208, 1], [1359311359, 1], [1392480869, 1], [1427574243, 1], [1429431050, 1]] |
stars,user | stars | user | 11236 | 0 | 0 | 9675 | [[100658940, 10], [366688, 10], [178424, 10], [41546558, 9], [948118, 9], [7476523, 8], [161718, 8], [128885, 8], [46511, 8], [14772, 8]] | [[132673404, 1], [134146004, 1], [134528840, 1], [134682577, 1], [135533341, 1], [136005892, 1], [137419843, 1], [137427584, 1], [139175847, 1], [139538131, 1]] |
steps,seq | steps | seq | 262 | 0 | 0 | 13 | [[1, 54], [2, 52], [3, 47], [4, 45], [5, 35], [6, 7], [7, 6], [8, 4], [10, 3], [9, 3]] | [[13, 1], [12, 2], [9, 3], [10, 3], [11, 3], [8, 4], [7, 6], [6, 7], [5, 35], [4, 45]] |
repos,owner | repos | owner | 1329 | 0 | 0 | 805 | [[9599, 193], [25778, 17], [53015001, 14], [44060760, 13], [15178711, 13], [28694175, 12], [1223, 12], [39538958, 9], [5802411, 9], [193185, 7]] | [[127496762, 1], [127565535, 1], [128680267, 1], [128963156, 1], [129124879, 1], [131779294, 1], [131845973, 1], [132527556, 1], [133026375, 1], [139249755, 1]] |
_analyze_tables_,num_null | _analyze_tables_ | num_null | 350 | 0 | 0 | 53 | [[0, 279], [1, 5], [1275, 4], [1120, 4], [560, 2], [431, 2], [14, 2], [13, 2], [10, 2], [8, 2]] | [[1108, 1], [1214, 1], [1229, 1], [1244, 1], [1266, 1], [1278, 1], [1290, 1], [2293, 1], [2872, 1], [9947, 1]] |
repos,organization | repos | organization | 1329 | 1108 | 0 | 127 | [["None", 1108], [53015001, 14], [44060760, 13], [38107867, 7], [84364688, 6], [42605656, 6], [11290934, 6], [116695412, 5], [89875467, 5], [80003822, 4]] | [[110405140, 1], [114021082, 1], [116570464, 1], [116850614, 1], [117817022, 1], [120766041, 1], [123046521, 1], [128680267, 1], [132527556, 1], [139249755, 1]] |
repos,description | repos | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
repos_fts,description | repos_fts | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
releases,reactions | releases | reactions | 344 | 316 | 0 | 28 | [["None", 316], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/57629048/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51940513/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51387349/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/47507174/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/45182156/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44292523/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44155601/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/101136455/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/twitter-to-sqlite/releases/500036...", 1]] | [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/103740013/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/109839649/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44511190/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44904928/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/47636109/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/48389722/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/53350811/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/59656694/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/65833874/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/75560168/reac...", 1]] |
issues,reactions | issues | reactions | 2892 | 2 | 0 | 2890 | [["None", 2], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/5/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/4/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/3/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/2/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/13/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/12/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/11/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/10/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/1/re...", 1]] | [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/90/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/91/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/92/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/93/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/94/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/95/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/96/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/97/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/98/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/99/reactions\", ...", 1]] |
issue_comments,reactions | issue_comments | reactions | 9947 | 0 | 0 | 21 | [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 9604], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 199], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 37], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 36], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 18], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 13], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 8], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 7], ["{\"total_count\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3]] | [["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 1, \"he...", 1], ["{\"total_count\": 15, \"+1\": 7, \"-1\": 0, \"laugh\": 1, \"hooray\": 1, \"confused\": 0, \"h...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 3, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 5, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 2, \"confused\": 0, \"he...", 2], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2]] |
workflows,on | workflows | on | 41 | 0 | 0 | 16 | [["{\"release\": {\"types\": [\"created\"]}}", 11], ["[\"push\"]", 8], ["[\"push\", \"pull_request\"]", 6], ["{\"workflow_dispatch\": null}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"pull_request_target\": {\"types\": [\"opened\"]}}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1]] | [["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"master\", \"main\"]}}", 1], ["{\"push\": {\"branches\": [\"master\"]}, \"pull_request\": {\"branches\": [\"master\"]}}", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"], \"paths\": [\"README.md\"...", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\"...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"branch\": {\"description\": \"Branch to deploy\", ...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"version_tag\": {\"description\": \"Tag to build a...", 1]] |
steps,with | steps | with | 262 | 173 | 0 | 23 | [["None", 173], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-pip-${{ hashFiles('**/setup.py...", 23], ["{\"python-version\": \"${{ matrix.python-version }}\"}", 17], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-publish-pip-${{ hashFiles('**/...", 9], ["{\"python-version\": \"3.9\"}", 7], ["{\"python-version\": 3.9}", 4], ["{\"python-version\": \"3.11\"}", 4], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 4], ["{\"version\": \"318.0.0\", \"service_account_email\": \"${{ secrets.GCP_SA_EMAIL }}\", \"...", 3], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 2]] | [["{\"path\": \"github.db\"}", 1], ["{\"path\": \"~/.cache/ms-playwright/\", \"key\": \"${{ runner.os }}-browsers\"}", 1], ["{\"path\": \"~/.npm\", \"key\": \"${{ runner.OS }}-npm-${{ hashFiles('**/package-lock.j...", 1], ["{\"project-slug\": \"datasette\"}", 1], ["{\"project-slug\": \"sqlite-utils\"}", 1], ["{\"python-version\": \"3.10\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.11\", \"cache\": \"pip\", \"cache-dependency-path\": \"pyproject.t...", 1], ["{\"python-version\": \"3.8\"}", 1], ["{\"target-branch\": \"main\", \"force\": false}", 1], ["{\"target-branch\": \"master\", \"force\": false}", 1]] |
repos,parent | repos | parent | 1329 | 1201 | 0 | 76 | [["None", 1201], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 29], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]] | [["{\"id\": 426357499, \"node_id\": \"R_kgDOGWmy-w\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 466635830, \"node_id\": \"R_kgDOG9BMNg\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 485162981, \"node_id\": \"R_kgDOHOr_5Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1], ["{\"id\": 583468610, \"node_id\": \"R_kgDOIscGQg\", \"name\": \"cloud-data-quality\", \"full...", 1]] |
repos,template_repository | repos | template_repository | 1329 | 1278 | 0 | 34 | [["None", 1278], ["{\"id\": 566008212, \"node_id\": \"R_kgDOIbyZlA\", \"name\": \"warehouse-etl\", \"full_name...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 3], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 424823623, \"node_id\": \"R_kgDOGVJLRw\", \"name\": \"glam-workbench-template\", ...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2]] | [["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 401177473, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDExNzc0NzM=\", \"name\": \"click-...", 1], ["{\"id\": 404397410, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDQzOTc0MTA=\", \"name\": \"python...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 515375569, \"node_id\": \"R_kgDOHrgB0Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 521799111, \"node_id\": \"R_kgDOHxoFxw\", \"name\": \"redbean-template\", \"full_n...", 1], ["{\"id\": 614348767, \"node_id\": \"R_kgDOJJ433w\", \"name\": \"ci-full-template\", \"full_n...", 1]] |
repos,source | repos | source | 1329 | 1201 | 0 | 74 | [["None", 1201], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 31], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]] | [["{\"id\": 399308604, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ=\", \"name\": \"datase...", 1], ["{\"id\": 403239260, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDMyMzkyNjA=\", \"name\": \"pulse-...", 1], ["{\"id\": 409650041, \"node_id\": \"R_kgDOGGrDeQ\", \"name\": \"LOSH-krawler\", \"full_name\"...", 1], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1]] |
users,login | users | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users,name | users | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,login | users_fts | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,name | users_fts | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
issue_comments,body | issue_comments | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
issue_comments_fts,body | issue_comments_fts | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
repos,name | repos | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
repos_fts,name | repos_fts | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
commits,message | commits | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
commits_fts,message | commits_fts | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
issues,title | issues | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
issues_fts,title | issues_fts | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
_analyze_tables_,column | _analyze_tables_ | column | 350 | 0 | 0 | 153 | [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] | [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]] |
issues,body | issues | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]] |
issues_fts,body | issues_fts | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]] |
pull_requests,title | pull_requests | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests_fts,title | pull_requests_fts | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests,body | pull_requests | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
pull_requests_fts,body | pull_requests_fts | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
issues,pull_request | issues | pull_request | 2892 | 2332 | 0 | 560 | [["None", 2332], ["dogsheep/dogsheep.github.io/pulls/3", 1], ["dogsheep/dogsheep.github.io/pulls/1", 1], ["dogsheep/dogsheep-photos/pulls/37", 1], ["dogsheep/dogsheep-photos/pulls/36", 1], ["dogsheep/dogsheep-photos/pulls/31", 1], ["dogsheep/dogsheep-photos/pulls/30", 1], ["dogsheep/dogsheep-photos/pulls/29", 1], ["dogsheep/dogsheep-beta/pulls/35", 1], ["dogsheep/apple-notes-to-sqlite/pulls/13", 1]] | [["simonw/sqlite-utils/pulls/60", 1], ["simonw/sqlite-utils/pulls/64", 1], ["simonw/sqlite-utils/pulls/65", 1], ["simonw/sqlite-utils/pulls/67", 1], ["simonw/sqlite-utils/pulls/72", 1], ["simonw/sqlite-utils/pulls/75", 1], ["simonw/sqlite-utils/pulls/78", 1], ["simonw/sqlite-utils/pulls/80", 1], ["simonw/sqlite-utils/pulls/9", 1], ["simonw/sqlite-utils/pulls/96", 1]] |
labels,name | labels | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
labels_fts,name | labels_fts | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
steps,run | steps | run | 262 | 143 | 0 | 58 | [["None", 143], ["pytest\n", 19], ["pip install -e '.[test]'\n", 15], ["python setup.py sdist bdist_wheel\ntwine upload dist/*\n", 9], ["pip install setuptools wheel twine\n", 9], ["pip install '.[test]'\n", 4], ["pytest -v\n", 3], ["npx markdown-toc README.md -i", 2], ["git diff\ngit config --global user.email \"readme-bot@example.com\"\ngit config --gl...", 2], ["cd docs\nDISABLE_SPHINX_INLINE_TABS=1 sphinx-build -b xml . _build\nsphinx-to-sqli...", 2]] | [["pip install sqlean.py sqlite-dump", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n# And the test that exceeds a ...", 1], ["python -m pip install --upgrade pip\npip install -e .[test]\n", 1], ["python -m pip install --upgrade pip\npip install sqlite-utils>=3.1\nsqlite-utils -...", 1], ["python -m pip install --upgrade pip\npython -m pip install -e .[test]\npython -m p...", 1], ["python -m pip install -e .[docs]\npython -m pip install sphinx-to-sqlite==0.1a1\n", 1], ["python tests/fixtures.py fixtures.db fixtures.json plugins --extra-db-filename e...", 1], ["sleep 60 # Give PyPI time to make the new release available\ndocker login -u $DOC...", 1], ["sqlite-utils github.db \"select full_name from repos where owner = 53015001 union...", 1]] |
repos,homepage | repos | homepage | 1329 | 799 | 300 | 177 | [["None", 799], ["", 300], ["https://covid19dashboards.com", 18], ["https://datasette.io", 8], ["https://lawsql.com", 5], ["http://datasette.readthedocs.io/", 5], ["https://til.simonwillison.net/", 4], ["https://junior.guru", 4], ["https://lawdata.xyz", 3], ["https://docs.datasette.io", 3]] | [["https://www.tacosdedatos.com/", 1], ["https://www.youtube.com/watch?v=lhM357qSGXA", 1], ["https://yumyum-tau.vercel.app/", 1], ["https://zctaimpacts.abrie.dev", 1], ["links-mads-hartmann-com.vercel.app", 1], ["my-database-project-git-main.testberg.vercel.app", 1], ["pocket-data-datasette-kasperzutterman.vercel.app", 1], ["scratch-gamma.vercel.app", 1], ["unabandaql-ng-git-master.jazzido.vercel.app", 1], ["vumc-resident-map.vercel.app", 1]] |
releases,body | releases | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
releases_fts,body | releases_fts | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
emojis,url | emojis | url | 1877 | 0 | 0 | 1834 | [["https://github.githubassets.com/images/icons/emoji/unicode/1f4a9.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f44a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f34a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f42c.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f41d.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3ee.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3c3.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f314.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ec-1f1e7.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ea-1f1fa.png?v8", 2]] | [["https://github.githubassets.com/images/icons/emoji/unicode/2b06.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b07.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1b.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1c.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b50.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b55.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3030.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/303d.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3297.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3299.png?v8", 1]] |
users,html_url | users | html_url | 10621 | 0 | 0 | 10620 | [["https://github.com/fineheard", 2], ["https://github.com/0nyr", 1], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]] | [["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zz2115", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]] |
issue_comments,issue_url | issue_comments | issue_url | 9947 | 0 | 0 | 2346 | [["https://api.github.com/repos/simonw/datasette/issues/782", 54], ["https://api.github.com/repos/simonw/datasette/issues/1293", 51], ["https://api.github.com/repos/simonw/datasette/issues/1999", 49], ["https://api.github.com/repos/simonw/datasette/issues/1893", 48], ["https://api.github.com/repos/simonw/datasette/issues/1439", 48], ["https://api.github.com/repos/simonw/datasette/issues/983", 47], ["https://api.github.com/repos/simonw/datasette/issues/1518", 45], ["https://api.github.com/repos/simonw/datasette/issues/1249", 45], ["https://api.github.com/repos/simonw/datasette/issues/272", 42], ["https://api.github.com/repos/simonw/datasette/issues/699", 40]] | [["https://api.github.com/repos/simonw/sqlite-utils/issues/563", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/565", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/58", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/6", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/63", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/68", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/75", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/83", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/85", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/91", 1]] |
licenses,url | licenses | url | 16 | 1 | 0 | 15 | [["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/bsd-3-clause-clear", 1], ["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/bsd-2-clause", 1], ["https://api.github.com/licenses/apache-2.0", 1], ["https://api.github.com/licenses/agpl-3.0", 1], ["None", 1]] | [["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/lgpl-2.1", 1], ["https://api.github.com/licenses/mit", 1], ["https://api.github.com/licenses/mpl-2.0", 1], ["https://api.github.com/licenses/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]] |
pull_requests,merge_commit_sha | pull_requests | merge_commit_sha | 560 | 1 | 0 | 559 | [["None", 1], ["0499f174c063283aa9b589d475a32077aaf7adc5", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]] | [["f8ffac8787e299a62c99ed1ce914cd5ace84ad94", 1], ["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]] |
pull_requests,base | pull_requests | base | 560 | 0 | 0 | 422 | [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0f7192b6154edb576c41b55bd3f2a3f53e5f436a", 4]] | [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]] |
repos,license | repos | license | 1329 | 666 | 0 | 16 | [["None", 666], ["apache-2.0", 310], ["mit", 224], ["bsd-3-clause", 32], ["gpl-3.0", 29], ["other", 27], ["agpl-3.0", 10], ["unlicense", 7], ["wtfpl", 6], ["cc-by-4.0", 6]] | [["eupl-1.2", 1], ["gpl-2.0", 1], ["lgpl-2.1", 1], ["mpl-2.0", 1], ["bsd-2-clause", 2], ["bsd-3-clause-clear", 2], ["cc0-1.0", 4], ["cc-by-4.0", 6], ["wtfpl", 6], ["unlicense", 7]] |
labels,color | labels | color | 103 | 0 | 0 | 71 | [["a2eeef", 13], ["d73a4a", 11], ["0075ca", 8], ["ffffff", 2], ["e4e669", 2], ["008672", 2], ["0EE038", 1], ["083993", 1], ["0366d6", 1], ["006b75", 1]] | [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]] |
workflows,filename | workflows | filename | 41 | 0 | 0 | 17 | [["test.yml", 12], ["publish.yml", 11], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["documentation-links.yml", 2], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.yml", 1], ["deploy-branch-preview.yml", 1], ["codeql-analysis.yml", 1]] | [["deploy-demo.yml", 1], ["deploy-latest.yml", 1], ["mirror-master-and-main.yml", 1], ["prettier.yml", 1], ["push_docker_tag.yml", 1], ["readme-toc.yaml", 1], ["readme-toc.yml", 1], ["test-pyodide.yml", 1], ["tmate-mac.yml", 1], ["tmate.yml", 1]] |
raw_authors,name | raw_authors | name | 114 | 0 | 0 | 110 | [["Thomas Sibley", 2], ["Simon Willison", 2], ["Robert Gieseke", 2], ["Abdussamet Koçak", 2], ["Alex Garcia", 1], ["Adrien Di Pasquale", 1], ["Adam Wolf", 1], ["Adam Simpson", 1], ["Adam Jonas", 1], ["Abdus", 1]] | [["dependabot[bot]", 1], ["fcatus", 1], ["gerrymanoim", 1], ["joelondon", 1], ["louispotok", 1], ["lsb", 1], ["mkorosec", 1], ["rhoboro", 1], ["vincent d warmerdam", 1], ["カシオ 金城 大関", 1]] |
commits,raw_author | commits | raw_author | 3784 | 0 | 0 | 113 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3311], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 48], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["90786fb02407ad60f10210c0592ee711a9a36fae", 6], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]] | [["ddda3e8cc5167e6bdbab6819a1f4e8e2621f4e89", 1], ["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f333c00958a658720cd93e305aac71711b88e52b", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["f98e0e8fe6ee48ca1f752bb408eecbbd294f9ceb", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]] |
_analyze_tables_,table | _analyze_tables_ | table | 350 | 0 | 0 | 73 | [["repos", 57], ["pull_requests", 23], ["issues", 23], ["milestones", 15], ["releases", 14], ["assets", 14], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9]] | [["commits_fts", 1], ["issue_comments_fts", 1], ["licenses_fts", 1], ["repos_fts_config", 2], ["repos_fts_data", 2], ["repos_fts_docsize", 2], ["users_fts", 2], ["users_fts_config", 2], ["users_fts_data", 2], ["users_fts_docsize", 2]] |
issue_comments_fts_docsize,sz | issue_comments_fts_docsize | sz | 9947 | 0 | 0 | 508 | [["b'\\x0f'", 216], ["b'\\x12'", 209], ["b'\\x10'", 203], ["b'\\x0e'", 199], ["b'\\x0c'", 188], ["b'\\r'", 184], ["b'\\x16'", 180], ["b'\\x13'", 176], ["b'\\x15'", 163], ["b'\\x0b'", 162]] | [["b'\\x8a\\x0b'", 1], ["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x92}'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]] |
emojis,image | emojis | image | 1877 | 0 | 0 | 1750 | [["b'Not Found\\n'", 83], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x04\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2]] | [["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00K\\x00\\x00\\x00K\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03 \\x00\\x00\\x01\\xe0\\x01\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03\\xe8\\x00\\x00\\x02X\\x08\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x04\\xb0\\x00\\x00\\x03 \\x08\\x02\\x00\\x...", 1]] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [_analyze_tables_] ( [table] TEXT, [column] TEXT, [total_rows] INTEGER, [num_null] INTEGER, [num_blank] INTEGER, [num_distinct] INTEGER, [most_common] TEXT, [least_common] TEXT, PRIMARY KEY ([table], [column]) );