ContentStats

1,680,549 rows

View and edit SQL

id stats
000008AA-6591-4DFA-A999-9C54CD994E15 {"num_newlines": 58, "num_whitespace_lines": 13, "num_comment_lines": 5, "min_line_length": 13, "max_line_length": 76, "avg_line_length": 39.98275862068966}
000016A2-0C62-4FED-B7DC-A6E9367EBFE2 {}
000016A8-D7F5-4857-B053-1C358CD57EA5 {"num_newlines": 327, "num_whitespace_lines": 45, "num_comment_lines": 4, "min_line_length": 3, "max_line_length": 88, "avg_line_length": 38.027522935779814}
00002705-70B4-41DC-BB53-6FB504C22A22 {"num_newlines": 111, "num_whitespace_lines": 16, "num_comment_lines": 17, "min_line_length": 1, "max_line_length": 77, "avg_line_length": 37.11711711711712}
00002E3A-05BB-4F92-A57E-A2B0B282F141 {"num_newlines": 218, "num_whitespace_lines": 19, "num_comment_lines": 16, "min_line_length": 1, "max_line_length": 703, "avg_line_length": 46.518348623853214}
00003429-65FC-4FF9-A972-6E58FFB4F7FD {"num_newlines": 179, "num_whitespace_lines": 33, "num_comment_lines": 17, "min_line_length": 1, "max_line_length": 89, "avg_line_length": 30.910614525139664}
00003FB8-933F-4493-BCDF-714B21091F8C {"num_newlines": 22, "num_whitespace_lines": 8, "num_comment_lines": 0, "min_line_length": 5, "max_line_length": 103, "avg_line_length": 20.681818181818183}
00004673-A9F0-4569-84EE-FFF3EFB59EC2 {"num_newlines": 24, "num_whitespace_lines": 6, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 83, "avg_line_length": 24.083333333333332}
00005B9E-C053-4D99-917F-CAA3DAC46DDB {"num_newlines": 81, "num_whitespace_lines": 15, "num_comment_lines": 14, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 34.54320987654321}
000061ED-4376-4EA4-9234-B63C46FE0506 {"num_newlines": 126, "num_whitespace_lines": 28, "num_comment_lines": 6, "min_line_length": 3, "max_line_length": 70, "avg_line_length": 24.166666666666668}
00007519-9A65-4C76-BB13-8FD10AA731A1 {"num_newlines": 29, "num_whitespace_lines": 10, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 97, "avg_line_length": 24.551724137931036}
0000798B-1BB9-4E32-ADE3-F46BC237141F {"num_newlines": 63, "num_whitespace_lines": 15, "num_comment_lines": 3, "min_line_length": 3, "max_line_length": 106, "avg_line_length": 30.77777777777778}
0000B2B4-F6F4-44E6-B06D-5D8748B87716 {"num_newlines": 369, "num_whitespace_lines": 59, "num_comment_lines": 46, "min_line_length": 1, "max_line_length": 78, "avg_line_length": 35.43631436314363}
0000BA54-3E88-4159-9F7C-F7CEB750298C {"num_newlines": 135, "num_whitespace_lines": 14, "num_comment_lines": 15, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 39.86666666666667}
0000BB91-1819-4B1E-A8E9-5F66F0407319 {"num_newlines": 62, "num_whitespace_lines": 14, "num_comment_lines": 8, "min_line_length": 10, "max_line_length": 114, "avg_line_length": 35.274193548387096}
0000BBD2-E8F3-4467-BE34-2FE93336FFF6 {"num_newlines": 3114, "num_whitespace_lines": 596, "num_comment_lines": 272, "min_line_length": 1, "max_line_length": 211, "avg_line_length": 37.653179190751445}
0000C864-68F1-4F80-A542-0367C363330F {"num_newlines": 97, "num_whitespace_lines": 15, "num_comment_lines": 17, "min_line_length": 4, "max_line_length": 113, "avg_line_length": 39.88659793814433}
0000CA61-801E-43DC-B069-8CE47C0E6B67 {"num_newlines": 182, "num_whitespace_lines": 34, "num_comment_lines": 19, "min_line_length": 1, "max_line_length": 106, "avg_line_length": 34.142857142857146}
0000DA53-339B-44B3-8D6F-B1EFFEC41262 {"num_newlines": 203, "num_whitespace_lines": 42, "num_comment_lines": 5, "min_line_length": 13, "max_line_length": 78, "avg_line_length": 31.428571428571427}
0000E288-B82F-4361-8345-C452141241AA {"num_newlines": 285, "num_whitespace_lines": 47, "num_comment_lines": 40, "min_line_length": 2, "max_line_length": 167, "avg_line_length": 47.90526315789474}
0000E43B-DBF0-451B-8FF4-42E85EC234FA {"num_newlines": 213, "num_whitespace_lines": 30, "num_comment_lines": 17, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 38.59154929577465}
0000F2FF-BDF4-49F2-B3F6-4EF6EBDCF71B {"num_newlines": 77, "num_whitespace_lines": 12, "num_comment_lines": 0, "min_line_length": 1, "max_line_length": 108, "avg_line_length": 26.83116883116883}
0000F3D0-FD21-4517-A355-8BF4DC225907 {"num_newlines": 217, "num_whitespace_lines": 23, "num_comment_lines": 19, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 39.723502304147466}
00012587-288C-480C-8CEF-6FF0DFDE8EF8 {"num_newlines": 169, "num_whitespace_lines": 31, "num_comment_lines": 34, "min_line_length": 1, "max_line_length": 134, "avg_line_length": 33.50887573964497}
00012927-DC28-431A-A83F-CD47EC77350D {"num_newlines": 36, "num_whitespace_lines": 10, "num_comment_lines": 0, "min_line_length": 1, "max_line_length": 77, "avg_line_length": 22.444444444444443}
000132CD-C87C-4031-A677-717649067D84 {}
000149D1-F5C2-4D70-97B7-D8205890376B {"num_newlines": 114, "num_whitespace_lines": 25, "num_comment_lines": 4, "min_line_length": 1, "max_line_length": 180, "avg_line_length": 36.12280701754386}
000154D1-E373-4A12-A0DA-134B68A7B514 {"num_newlines": 652, "num_whitespace_lines": 100, "num_comment_lines": 27, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 41.216257668711656}
000173BD-06E7-46C6-8918-EE2CB06D9308 {"num_newlines": 116, "num_whitespace_lines": 12, "num_comment_lines": 2, "min_line_length": 3, "max_line_length": 78, "avg_line_length": 35.189655172413794}
0001744A-557D-4984-B349-50BA104A89AD {"num_newlines": 66, "num_whitespace_lines": 15, "num_comment_lines": 5, "min_line_length": 2, "max_line_length": 87, "avg_line_length": 33.40909090909091}
0001A31A-EEC4-4FDC-A018-3EDBB0341D0D {"num_newlines": 440, "num_whitespace_lines": 62, "num_comment_lines": 18, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 39.35}
0001A7EA-E53C-4B3E-95CD-1E69C6B585D9 {"num_newlines": 65, "num_whitespace_lines": 14, "num_comment_lines": 14, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 35.56923076923077}
0001B39A-031F-411C-809A-C6C5D4DDDFE2 {"num_newlines": 236, "num_whitespace_lines": 23, "num_comment_lines": 34, "min_line_length": 1, "max_line_length": 88, "avg_line_length": 46.639830508474574}
0001B994-D8AA-4DF6-94AB-6F6BF074CFEC {"num_newlines": 31, "num_whitespace_lines": 12, "num_comment_lines": 3, "min_line_length": 2, "max_line_length": 152, "avg_line_length": 29.838709677419356}
0001BC15-99A5-4953-A58F-ADB6DA85E7BF {"num_newlines": 40, "num_whitespace_lines": 8, "num_comment_lines": 6, "min_line_length": 4, "max_line_length": 77, "avg_line_length": 31.775}
0001CE88-1FEE-494A-8297-A841F09EDC6A {"num_newlines": 53, "num_whitespace_lines": 12, "num_comment_lines": 15, "min_line_length": 1, "max_line_length": 95, "avg_line_length": 27.849056603773583}
0001D3F1-D939-4092-856E-5D135C03DF42 {"num_newlines": 34, "num_whitespace_lines": 5, "num_comment_lines": 0, "min_line_length": 10, "max_line_length": 62, "avg_line_length": 23.58823529411765}
0001D69B-8D12-4732-AD3B-6FA5BD321386 {"num_newlines": 85, "num_whitespace_lines": 16, "num_comment_lines": 15, "min_line_length": 3, "max_line_length": 79, "avg_line_length": 28.858823529411765}
0001D709-C959-47D0-ACFD-54C23CE94C03 {"num_newlines": 142, "num_whitespace_lines": 14, "num_comment_lines": 9, "min_line_length": 5, "max_line_length": 182, "avg_line_length": 72.28169014084507}
0001DC3B-5ED6-404E-B6D3-25E2F616C642 {"num_newlines": 38, "num_whitespace_lines": 7, "num_comment_lines": 1, "min_line_length": 3, "max_line_length": 114, "avg_line_length": 36.10526315789474}
0001DD0D-E8EF-498A-8E93-658A6C62F9F9 {"num_newlines": 97, "num_whitespace_lines": 13, "num_comment_lines": 2, "min_line_length": 8, "max_line_length": 94, "avg_line_length": 28.329896907216494}
0001F30C-02F2-423B-9A14-A2BD3479C967 {"num_newlines": 82, "num_whitespace_lines": 15, "num_comment_lines": 8, "min_line_length": 8, "max_line_length": 86, "avg_line_length": 24.926829268292682}
000214A9-0EE8-4B82-AB49-9CEE0DDFC299 {"num_newlines": 31, "num_whitespace_lines": 6, "num_comment_lines": 16, "min_line_length": 1, "max_line_length": 115, "avg_line_length": 41.064516129032256}
0002188B-795D-468A-9B34-3C24AB34D285 {"num_newlines": 853, "num_whitespace_lines": 183, "num_comment_lines": 32, "min_line_length": 13, "max_line_length": 79, "avg_line_length": 37.64947245017585}
00021DFF-5A68-4C69-A765-B4CCF3CA7BB7 {}
00022ADC-A039-4D6D-8404-E6656B9C0661 {"num_newlines": 90, "num_whitespace_lines": 13, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 89, "avg_line_length": 33.644444444444446}
00023468-F887-416A-BBDF-07CE79049FC6 {"num_newlines": 176, "num_whitespace_lines": 22, "num_comment_lines": 28, "min_line_length": 3, "max_line_length": 114, "avg_line_length": 47.72159090909091}
00023B23-83C6-4DE0-B534-778A06544F58 {"num_newlines": 313, "num_whitespace_lines": 79, "num_comment_lines": 24, "min_line_length": 2, "max_line_length": 111, "avg_line_length": 31.14696485623003}
00023DF1-FE7D-4A61-B95D-5704F5D20DB7 {"num_newlines": 73, "num_whitespace_lines": 15, "num_comment_lines": 0, "min_line_length": 8, "max_line_length": 90, "avg_line_length": 41.19178082191781}
00024A9F-770E-4D67-9C16-3FD7413BAB61 {"num_newlines": 76, "num_whitespace_lines": 17, "num_comment_lines": 0, "min_line_length": 11, "max_line_length": 78, "avg_line_length": 34.96052631578947}
00026B31-946B-4F57-B8A4-D095319127E3 {"num_newlines": 995, "num_whitespace_lines": 154, "num_comment_lines": 49, "min_line_length": 7, "max_line_length": 86, "avg_line_length": 32.78391959798995}
00026D02-0FF4-4C3E-9348-4B7A03C7E6A7 {"num_newlines": 181, "num_whitespace_lines": 49, "num_comment_lines": 21, "min_line_length": 3, "max_line_length": 105, "avg_line_length": 35.08839779005525}
000272CC-B0A9-437D-B8FC-C934C24F5FAB {"num_newlines": 348, "num_whitespace_lines": 59, "num_comment_lines": 3, "min_line_length": 3, "max_line_length": 79, "avg_line_length": 34.58620689655172}
000272D5-1A5A-414C-910D-F35C5F261A49 {"num_newlines": 190, "num_whitespace_lines": 46, "num_comment_lines": 1, "min_line_length": 7, "max_line_length": 113, "avg_line_length": 34.43684210526316}
00028511-EA31-438F-9BAE-E50A7BCB9B04 {"num_newlines": 92, "num_whitespace_lines": 23, "num_comment_lines": 13, "min_line_length": 1, "max_line_length": 75, "avg_line_length": 31.01086956521739}
0002862E-6808-477F-9A71-661F5945C7CE {"num_newlines": 44, "num_whitespace_lines": 10, "num_comment_lines": 0, "min_line_length": 1, "max_line_length": 67, "avg_line_length": 22.204545454545453}
00028ADE-30A1-4A40-B8F7-8945C55FA4F7 {"num_newlines": 903, "num_whitespace_lines": 143, "num_comment_lines": 62, "min_line_length": 13, "max_line_length": 79, "avg_line_length": 36.78626799557032}
000296BB-F262-4B97-9CFB-2F38F3C3F7C7 {}
0002A8A1-324E-419A-8355-94280AE17273 {"num_newlines": 93, "num_whitespace_lines": 20, "num_comment_lines": 1, "min_line_length": 3, "max_line_length": 112, "avg_line_length": 38.236559139784944}
0002B156-99F6-44A5-AA05-5C88FD71E5D6 {"num_newlines": 54, "num_whitespace_lines": 10, "num_comment_lines": 1, "min_line_length": 4, "max_line_length": 143, "avg_line_length": 35.24074074074074}
0002BA05-6C48-4F17-A9DC-8C47D5A83DAC {"num_newlines": 15, "num_whitespace_lines": 3, "num_comment_lines": 3, "min_line_length": 4, "max_line_length": 53, "avg_line_length": 27.866666666666667}
0002BD8F-D1C1-4102-A46F-17351A9F3AB0 {"num_newlines": 154, "num_whitespace_lines": 9, "num_comment_lines": 3, "min_line_length": 5, "max_line_length": 212, "avg_line_length": 80.14935064935065}
0002C2F0-5C0B-4D51-A2B0-8179CBCF136C {"num_newlines": 715, "num_whitespace_lines": 102, "num_comment_lines": 17, "min_line_length": 1, "max_line_length": 79, "avg_line_length": 26.22797202797203}
0002CBAA-B514-4F6F-B61E-E2FE0878C616 {"num_newlines": 16, "num_whitespace_lines": 3, "num_comment_lines": 1, "min_line_length": 7, "max_line_length": 69, "avg_line_length": 28.0625}
0002D37A-7DAF-4C1A-BF6E-1AADCC326EFE {"num_newlines": 174, "num_whitespace_lines": 35, "num_comment_lines": 25, "min_line_length": 1, "max_line_length": 88, "avg_line_length": 32.71264367816092}
0003023D-2D65-4FF4-BC56-A2BDAE11417D {"num_newlines": 256, "num_whitespace_lines": 54, "num_comment_lines": 5, "min_line_length": 5, "max_line_length": 80, "avg_line_length": 27.15234375}
00031E61-BE9D-46AB-95D9-240673B3797C {"num_newlines": 74, "num_whitespace_lines": 13, "num_comment_lines": 3, "min_line_length": 13, "max_line_length": 90, "avg_line_length": 31.35135135135135}
00032162-A5E4-4696-BE7F-1ECA6F10DD5C {"num_newlines": 171, "num_whitespace_lines": 42, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 145, "avg_line_length": 48.41520467836257}
00032FF2-47C6-472B-8CCF-8AA9C63355B3 {"num_newlines": 174, "num_whitespace_lines": 19, "num_comment_lines": 12, "min_line_length": 3, "max_line_length": 88, "avg_line_length": 31.95402298850575}
00033553-FCEB-4883-90EB-A98618EB56C1 {"num_newlines": 70, "num_whitespace_lines": 15, "num_comment_lines": 2, "min_line_length": 9, "max_line_length": 79, "avg_line_length": 31.742857142857144}
0003371A-8CB2-4C5B-BE63-FDBEA65A5B8F {"num_newlines": 57, "num_whitespace_lines": 14, "num_comment_lines": 4, "min_line_length": 3, "max_line_length": 96, "avg_line_length": 33.50877192982456}
000338B2-3373-4427-B754-6AC8754F6E24 {"num_newlines": 3, "num_whitespace_lines": 1, "num_comment_lines": 0, "min_line_length": 28, "max_line_length": 31, "avg_line_length": 19.333333333333332}
00033B6E-B5DB-4A78-B01E-E73B36A38EBF {"num_newlines": 112, "num_whitespace_lines": 25, "num_comment_lines": 20, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 33.660714285714285}
00033ECB-CE8B-4579-A45D-E104C6231CE2 {"num_newlines": 92, "num_whitespace_lines": 15, "num_comment_lines": 21, "min_line_length": 1, "max_line_length": 116, "avg_line_length": 37.57608695652174}
0003556E-6270-4CA0-A32E-81BFD1E5AA53 {"num_newlines": 88, "num_whitespace_lines": 16, "num_comment_lines": 11, "min_line_length": 3, "max_line_length": 79, "avg_line_length": 30.306818181818183}
00035C8E-3D2E-415B-B748-387D1C86D7C6 {}
000368C5-50FE-4052-AF65-04AD54A940FE {"num_newlines": 323, "num_whitespace_lines": 51, "num_comment_lines": 22, "min_line_length": 1, "max_line_length": 111, "avg_line_length": 40.4922600619195}
00037457-D5F3-47B3-8F1E-D4BCC3AAC912 {"num_newlines": 195, "num_whitespace_lines": 59, "num_comment_lines": 1, "min_line_length": 14, "max_line_length": 78, "avg_line_length": 25.05128205128205}
00039829-0E7E-4A4A-8871-026D86381947 {"num_newlines": 144, "num_whitespace_lines": 54, "num_comment_lines": 11, "min_line_length": 3, "max_line_length": 73, "avg_line_length": 31.055555555555557}
000398BA-6381-4DF9-AF6D-E74414DAE691 {}
00039949-CE6D-43AE-BE3E-95615DF266B6 {"num_newlines": 108, "num_whitespace_lines": 9, "num_comment_lines": 10, "min_line_length": 1, "max_line_length": 143, "avg_line_length": 47.99074074074074}
00039EEA-2DFA-45F9-A325-FEEA5610EB7A {"num_newlines": 274, "num_whitespace_lines": 46, "num_comment_lines": 20, "min_line_length": 1, "max_line_length": 87, "avg_line_length": 33.222627737226276}
0003A021-F477-4970-BE6A-03DEAB92B3C7 {"num_newlines": 63, "num_whitespace_lines": 14, "num_comment_lines": 15, "min_line_length": 1, "max_line_length": 74, "avg_line_length": 34.65079365079365}
0003A287-42C6-49B2-9AEE-99459FBA9DDE {"num_newlines": 288, "num_whitespace_lines": 55, "num_comment_lines": 6, "min_line_length": 3, "max_line_length": 102, "avg_line_length": 33.59027777777778}
0003B557-8A58-411B-8939-1BC6A6B304CD {"num_newlines": 79, "num_whitespace_lines": 18, "num_comment_lines": 1, "min_line_length": 3, "max_line_length": 97, "avg_line_length": 38.924050632911396}
0003C654-D63A-4100-BD7C-55853F262AC3 {"num_newlines": 282, "num_whitespace_lines": 24, "num_comment_lines": 35, "min_line_length": 3, "max_line_length": 4046, "avg_line_length": 46.709219858156025}
0003CC0B-5E03-43A3-9B28-2CC386E1AEA0 {"num_newlines": 197, "num_whitespace_lines": 35, "num_comment_lines": 15, "min_line_length": 7, "max_line_length": 78, "avg_line_length": 37.72081218274111}
0003E722-7574-495E-A066-CC0020C08F84 {"num_newlines": 2841, "num_whitespace_lines": 545, "num_comment_lines": 214, "min_line_length": 6, "max_line_length": 85, "avg_line_length": 38.33579725448786}
0003E948-D091-4603-8945-120E891C5B90 {"num_newlines": 147, "num_whitespace_lines": 17, "num_comment_lines": 29, "min_line_length": 11, "max_line_length": 112, "avg_line_length": 52.625850340136054}
0003EBC7-DAC3-49B9-BC99-0A03208B0931 {"num_newlines": 101, "num_whitespace_lines": 22, "num_comment_lines": 0, "min_line_length": 11, "max_line_length": 80, "avg_line_length": 32.42574257425743}
0003FCAC-6C97-4F7C-ADFC-28233377327D {"num_newlines": 143, "num_whitespace_lines": 26, "num_comment_lines": 39, "min_line_length": 1, "max_line_length": 80, "avg_line_length": 40.16083916083916}
0004037D-9C5C-4131-AC66-4FEACDA9673C {"num_newlines": 79, "num_whitespace_lines": 17, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 103, "avg_line_length": 45.075949367088604}
0004139F-C7B6-43BC-B9D4-69F296ABDD81 {"num_newlines": 89, "num_whitespace_lines": 23, "num_comment_lines": 0, "min_line_length": 3, "max_line_length": 77, "avg_line_length": 28.224719101123597}
000423F2-C3B5-4615-BC54-7F22C652617D {"num_newlines": 29, "num_whitespace_lines": 7, "num_comment_lines": 7, "min_line_length": 8, "max_line_length": 66, "avg_line_length": 13.586206896551724}
00042DC3-E692-4D92-8416-616A189A5442 {"num_newlines": 109, "num_whitespace_lines": 25, "num_comment_lines": 0, "min_line_length": 7, "max_line_length": 90, "avg_line_length": 22.513761467889907}
00044055-A3BB-4A85-B026-E15168609AE2 {"num_newlines": 211, "num_whitespace_lines": 41, "num_comment_lines": 15, "min_line_length": 1, "max_line_length": 79, "avg_line_length": 42.654028436018955}
000448E2-081B-472F-A261-606D166451C1 {"num_newlines": 1007, "num_whitespace_lines": 146, "num_comment_lines": 39, "min_line_length": 1, "max_line_length": 140, "avg_line_length": 39.62363455809334}
00044D88-D5AD-4C78-B353-279F8F7F9BF9 {"num_newlines": 2088, "num_whitespace_lines": 301, "num_comment_lines": 102, "min_line_length": 1, "max_line_length": 79, "avg_line_length": 35.27394636015325}
00045171-448C-497A-B0CC-281878F8C0A3 {"num_newlines": 171, "num_whitespace_lines": 38, "num_comment_lines": 2, "min_line_length": 1, "max_line_length": 82, "avg_line_length": 28.280701754385966}
00045646-CCCD-448A-93CC-FA17C5CF41FB {"num_newlines": 537, "num_whitespace_lines": 102, "num_comment_lines": 41, "min_line_length": 1, "max_line_length": 97, "avg_line_length": 34.3389199255121}

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE ContentStats (
   id TEXT,
   stats BLOB,

   PRIMARY KEY (id)
   FOREIGN KEY(id) REFERENCES File(id)
)
Powered by Datasette · Query took 1674.796ms