Skip to content

Instantly share code, notes, and snippets.

@DGaffney

DGaffney/gist:1066078

Created July 5, 2011 22:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save DGaffney/1066078 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save DGaffney/1066078 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
select count(distinct(screen_name)),geo_enabled from users where dataset_id in (200, 201, 202, 203, 204, 205) and twitter_id in (7524932, 8162322, 14274087, 14511951, 15077974, 15894020, 15914634, 16498195, 16529856, 17760781, 17784861, 18200615, 18460864, 18668136, 19035842, 19063141, 20400794, 20555999, 20579679, 21578875, 21587844, 21941984, 22120359, 22205904, 22218117, 22321520, 23376201, 23377569, 23479882, 23908773, 24287708, 24530900, 24966018, 25124859, 25366515, 25626174, 25738421, 25811689, 25822507, 25834094, 26008219, 26150677, 26171023, 26230418, 26273516, 26555800, 26602766, 26728695, 27335898, 27524029, 27570569, 27679698, 27765255, 27921386, 27937482, 27945993, 28369480, 28444084, 29077208, 29150921, 29178221, 29196038, 29209759, 29315398, 29546820, 29620526, 29743099, 29763551, 29881297, 29913428, 29939295, 30027454, 30035057, 30104425, 30431783, 30504450, 31133497, 31156433, 31349514, 31394603, 31513326, 31551422, 32134122, 32381290, 32699839, 32840980, 33050022, 33058177, 33170318, 33290648, 33460666, 33821248, 33933259, 33952624, 33959647, 34035744, 34273717, 34359976, 34519582, 34600726, 34776164, 34926221, 35051663, 35082581, 35298247, 35364154, 35634992, 35804894, 35818124, 36132688, 36154388, 36319931, 36984909, 37114439, 37221360, 37547362, 37635320, 37871311, 38107660, 38188715, 38692740, 38841937, 38921766, 39293838, 39419914, 39512794, 39633898, 39692424, 39796727, 40057701, 40293326, 40396536, 40452237, 40484610, 40515967, 40561401, 40635372, 40704959, 41078169, 41091859, 41467325, 41785345, 41834091, 41879678, 42062582, 42400291, 42412168, 42420785, 42423900, 42546015, 42583589, 42603585, 43035003, 43095145, 43285474, 43306002, 43505871, 43515448, 43580917, 43657421, 43855723, 44112500, 44316741, 44330585, 44728980, 44743363, 45050644, 45334336, 45446985, 45567186, 45924949, 46302810, 46575760, 46601108, 46676260, 46839192, 47246752, 47281473, 47287641, 47367192, 47416015, 47416565, 47425396, 47754811, 47778938, 47822135, 47951749, 48109922, 48220571, 48322065, 48445279, 48563415, 48744846, 49140332, 49173194, 49315476, 49411494, 49616273, 49639038, 50222794, 50228468, 51011747, 51016087, 51273193, 51395689, 51437756, 51625723, 51667785, 52029161, 52049325, 52051298, 52286493, 52707116, 52726939, 52868861, 53039161, 53068820, 53145231, 53292155, 53490336, 53640957, 54032509, 54177102, 54522808, 54675839, 55009361, 55199472, 55217861, 56295019, 56403668, 56790443, 57037433, 57101308, 57406732, 57527713, 57581488, 57732899, 57776971, 57869243, 58114906, 58207315, 58264660, 58397789, 58442547, 59345737, 59424564, 59451916, 59678856, 59929257, 59962473, 60179079, 60316434, 61044040, 61211130, 61250319, 61567598, 61875599, 62404274, 62511830, 62545301, 62748298, 63009240, 63170610, 63202894, 63222576, 63672806, 64374269, 64473644, 64530583, 64858923, 64982734, 65294513, 65596740, 65927990, 65939444, 66125770, 66263980, 67219994, 67422413, 68702688, 68815720, 69416519, 69844239, 70391581, 70600593, 70685646, 70694654, 70925312, 70995905, 71505889, 71868160, 71939486, 72070558, 72594450, 73812228, 74103164, 74188242, 74544605, 74614600, 75327890, 75346250, 75513985, 75561626, 75697488, 75759187, 75954609, 76046936, 76405315, 76682484, 76783580, 77160000, 77496938, 78055602, 78165995, 78397385, 78480657, 78614223, 78804437, 78953657, 78990577, 79151308, 79425237, 79915434, 80332853, 80519994, 80619175, 80719349, 81155513, 81394089, 81790402, 81813264, 81915249, 82129056, 82195137, 82412365, 82431156, 82629132, 83309820, 83563561, 83724971, 83820559, 84752079, 84920261, 85013835, 85794521, 86236801, 86258478, 87448623, 87851402, 87875058, 88474862, 88516202, 88703609, 89052670, 89323061, 89422473, 90302694, 90438121, 91285632, 92481327, 92596697, 93045300, 94004743, 94853157, 95026138, 95163490, 95674284, 95788434, 96092531, 96408946, 96418153, 96899214, 97188553, 97192539, 97306588, 97335159, 97580157, 97733039, 98306533, 98393631, 98589105, 99000510, 99013674, 99301062, 99469811, 99961239, 100368401, 100726974, 100777027, 100974869, 101591941, 101615725, 101623639, 102110251, 102481767, 102616995, 102639559, 103558465, 103604536, 104549544, 104808213, 105097745, 105308580, 105995089, 106945322, 108183905, 108592630, 109462565, 110371201, 110421716, 110603018, 110701909, 111219244, 111219702, 111377307, 111780148, 111856910, 111960794, 112745396, 112771528, 112896710, 112915932, 113170469, 113371424, 113445263, 114211651, 114442551, 114534816, 114799122, 114937574, 115442828, 115463474, 115561720, 116726232, 116884081, 117667331, 118136866, 118370589, 118579342, 118654218, 118792487, 119103152, 119395435, 121030886, 121047559, 121135219, 121371852, 121527048, 122005053, 122060722, 122269580, 122325100, 122591459, 122668734, 123138949, 123586241, 123928147, 124968522, 125281188, 125822809, 126478320, 127003602, 127999122, 128042190, 128308837, 128454279, 128616566, 129123426, 130167743, 130923849, 131006830, 131192086, 131279295, 131318819, 131631395, 131860467, 131870970, 132931489, 133169569, 133665785, 133995566, 134240162, 134502348, 134577184, 134907271, 136825039, 137489485, 137649980, 137913754, 138400522, 138684894, 139044591, 140546191, 141456116, 141662240, 142224955, 142725372, 143195113, 143447065, 143910123, 144061938, 144496527, 145081016, 145134217, 145189980, 145311766, 145751840, 145882158, 146142332, 146696761, 146700210, 147147140, 147844018, 147938866, 148439696, 149336532, 149344141, 149485961, 150163420, 150489842, 150972531, 151389621, 152022043, 152432423, 152634544, 153073338, 153485928, 153642450, 153952354, 153956746, 154453489, 157735524, 157830990, 158309533, 159138768, 159367563, 159898874, 160827775, 160890311, 160948648, 161686337, 163216536, 163240195, 163335078, 163734870, 163738740, 165718976, 165749122, 166120835, 166270930, 166446064, 166565986, 166916869, 167779886, 167818245, 167896057, 167959329, 168127554, 168672457, 169195245, 169330309, 169725245, 170904788, 170969605, 171736027, 171877999, 172026504, 172102444, 172287294, 175015712, 175332297, 175525941, 176809688, 177837284, 178366064, 178547182, 178815056, 180002166, 180232676, 180493932, 182025512, 182097119, 183316445, 184682582, 187738730, 187908580, 188468190, 189171104, 189246944, 190373866, 190393501, 190925066, 190999744, 191190039, 191783353, 191813915, 192039450, 192184943, 192804313, 195050808, 197147148, 197178640, 200293192, 200533382, 200825099, 201366352, 203565762, 203689090, 205512565, 205796907, 206327504, 206438283, 209511347, 210715645, 210850499, 211169401, 211285430, 211547565, 213757524, 214534214, 214541464, 216180103, 216435022, 216891885, 217197408, 217326862, 217355839, 217956860, 220119286, 221071781, 221369438, 223466091, 224588935, 224786514, 225002063, 225065716, 226590539, 228231998, 229938084, 232269419, 232723009, 232859127, 233839461, 234238719, 234816413, 236054545, 236468313, 237840144, 238263951, 238411720, 239614691, 239830525, 240421736, 240716637, 241172354, 241292216, 241879791, 242320381, 242781191, 242874548, 244194494, 244330833, 245089317) group by geo_enabled;
this returns data of:
+------------------------------+-------------+
| count(distinct(screen_name)) | geo_enabled |
+------------------------------+-------------+
| 664 | 1 |
+------------------------------+-------------+
1 row in set (0.33 sec)
select screen_name,geo_enabled from users where dataset_id in (200, 201, 202, 203, 204, 205) and twitter_id in (7524932, 8162322, 14274087, 14511951, 15077974, 15894020, 15914634, 16498195, 16529856, 17760781, 17784861, 18200615, 18460864, 18668136, 19035842, 19063141, 20400794, 20555999, 20579679, 21578875, 21587844, 21941984, 22120359, 22205904, 22218117, 22321520, 23376201, 23377569, 23479882, 23908773, 24287708, 24530900, 24966018, 25124859, 25366515, 25626174, 25738421, 25811689, 25822507, 25834094, 26008219, 26150677, 26171023, 26230418, 26273516, 26555800, 26602766, 26728695, 27335898, 27524029, 27570569, 27679698, 27765255, 27921386, 27937482, 27945993, 28369480, 28444084, 29077208, 29150921, 29178221, 29196038, 29209759, 29315398, 29546820, 29620526, 29743099, 29763551, 29881297, 29913428, 29939295, 30027454, 30035057, 30104425, 30431783, 30504450, 31133497, 31156433, 31349514, 31394603, 31513326, 31551422, 32134122, 32381290, 32699839, 32840980, 33050022, 33058177, 33170318, 33290648, 33460666, 33821248, 33933259, 33952624, 33959647, 34035744, 34273717, 34359976, 34519582, 34600726, 34776164, 34926221, 35051663, 35082581, 35298247, 35364154, 35634992, 35804894, 35818124, 36132688, 36154388, 36319931, 36984909, 37114439, 37221360, 37547362, 37635320, 37871311, 38107660, 38188715, 38692740, 38841937, 38921766, 39293838, 39419914, 39512794, 39633898, 39692424, 39796727, 40057701, 40293326, 40396536, 40452237, 40484610, 40515967, 40561401, 40635372, 40704959, 41078169, 41091859, 41467325, 41785345, 41834091, 41879678, 42062582, 42400291, 42412168, 42420785, 42423900, 42546015, 42583589, 42603585, 43035003, 43095145, 43285474, 43306002, 43505871, 43515448, 43580917, 43657421, 43855723, 44112500, 44316741, 44330585, 44728980, 44743363, 45050644, 45334336, 45446985, 45567186, 45924949, 46302810, 46575760, 46601108, 46676260, 46839192, 47246752, 47281473, 47287641, 47367192, 47416015, 47416565, 47425396, 47754811, 47778938, 47822135, 47951749, 48109922, 48220571, 48322065, 48445279, 48563415, 48744846, 49140332, 49173194, 49315476, 49411494, 49616273, 49639038, 50222794, 50228468, 51011747, 51016087, 51273193, 51395689, 51437756, 51625723, 51667785, 52029161, 52049325, 52051298, 52286493, 52707116, 52726939, 52868861, 53039161, 53068820, 53145231, 53292155, 53490336, 53640957, 54032509, 54177102, 54522808, 54675839, 55009361, 55199472, 55217861, 56295019, 56403668, 56790443, 57037433, 57101308, 57406732, 57527713, 57581488, 57732899, 57776971, 57869243, 58114906, 58207315, 58264660, 58397789, 58442547, 59345737, 59424564, 59451916, 59678856, 59929257, 59962473, 60179079, 60316434, 61044040, 61211130, 61250319, 61567598, 61875599, 62404274, 62511830, 62545301, 62748298, 63009240, 63170610, 63202894, 63222576, 63672806, 64374269, 64473644, 64530583, 64858923, 64982734, 65294513, 65596740, 65927990, 65939444, 66125770, 66263980, 67219994, 67422413, 68702688, 68815720, 69416519, 69844239, 70391581, 70600593, 70685646, 70694654, 70925312, 70995905, 71505889, 71868160, 71939486, 72070558, 72594450, 73812228, 74103164, 74188242, 74544605, 74614600, 75327890, 75346250, 75513985, 75561626, 75697488, 75759187, 75954609, 76046936, 76405315, 76682484, 76783580, 77160000, 77496938, 78055602, 78165995, 78397385, 78480657, 78614223, 78804437, 78953657, 78990577, 79151308, 79425237, 79915434, 80332853, 80519994, 80619175, 80719349, 81155513, 81394089, 81790402, 81813264, 81915249, 82129056, 82195137, 82412365, 82431156, 82629132, 83309820, 83563561, 83724971, 83820559, 84752079, 84920261, 85013835, 85794521, 86236801, 86258478, 87448623, 87851402, 87875058, 88474862, 88516202, 88703609, 89052670, 89323061, 89422473, 90302694, 90438121, 91285632, 92481327, 92596697, 93045300, 94004743, 94853157, 95026138, 95163490, 95674284, 95788434, 96092531, 96408946, 96418153, 96899214, 97188553, 97192539, 97306588, 97335159, 97580157, 97733039, 98306533, 98393631, 98589105, 99000510, 99013674, 99301062, 99469811, 99961239, 100368401, 100726974, 100777027, 100974869, 101591941, 101615725, 101623639, 102110251, 102481767, 102616995, 102639559, 103558465, 103604536, 104549544, 104808213, 105097745, 105308580, 105995089, 106945322, 108183905, 108592630, 109462565, 110371201, 110421716, 110603018, 110701909, 111219244, 111219702, 111377307, 111780148, 111856910, 111960794, 112745396, 112771528, 112896710, 112915932, 113170469, 113371424, 113445263, 114211651, 114442551, 114534816, 114799122, 114937574, 115442828, 115463474, 115561720, 116726232, 116884081, 117667331, 118136866, 118370589, 118579342, 118654218, 118792487, 119103152, 119395435, 121030886, 121047559, 121135219, 121371852, 121527048, 122005053, 122060722, 122269580, 122325100, 122591459, 122668734, 123138949, 123586241, 123928147, 124968522, 125281188, 125822809, 126478320, 127003602, 127999122, 128042190, 128308837, 128454279, 128616566, 129123426, 130167743, 130923849, 131006830, 131192086, 131279295, 131318819, 131631395, 131860467, 131870970, 132931489, 133169569, 133665785, 133995566, 134240162, 134502348, 134577184, 134907271, 136825039, 137489485, 137649980, 137913754, 138400522, 138684894, 139044591, 140546191, 141456116, 141662240, 142224955, 142725372, 143195113, 143447065, 143910123, 144061938, 144496527, 145081016, 145134217, 145189980, 145311766, 145751840, 145882158, 146142332, 146696761, 146700210, 147147140, 147844018, 147938866, 148439696, 149336532, 149344141, 149485961, 150163420, 150489842, 150972531, 151389621, 152022043, 152432423, 152634544, 153073338, 153485928, 153642450, 153952354, 153956746, 154453489, 157735524, 157830990, 158309533, 159138768, 159367563, 159898874, 160827775, 160890311, 160948648, 161686337, 163216536, 163240195, 163335078, 163734870, 163738740, 165718976, 165749122, 166120835, 166270930, 166446064, 166565986, 166916869, 167779886, 167818245, 167896057, 167959329, 168127554, 168672457, 169195245, 169330309, 169725245, 170904788, 170969605, 171736027, 171877999, 172026504, 172102444, 172287294, 175015712, 175332297, 175525941, 176809688, 177837284, 178366064, 178547182, 178815056, 180002166, 180232676, 180493932, 182025512, 182097119, 183316445, 184682582, 187738730, 187908580, 188468190, 189171104, 189246944, 190373866, 190393501, 190925066, 190999744, 191190039, 191783353, 191813915, 192039450, 192184943, 192804313, 195050808, 197147148, 197178640, 200293192, 200533382, 200825099, 201366352, 203565762, 203689090, 205512565, 205796907, 206327504, 206438283, 209511347, 210715645, 210850499, 211169401, 211285430, 211547565, 213757524, 214534214, 214541464, 216180103, 216435022, 216891885, 217197408, 217326862, 217355839, 217956860, 220119286, 221071781, 221369438, 223466091, 224588935, 224786514, 225002063, 225065716, 226590539, 228231998, 229938084, 232269419, 232723009, 232859127, 233839461, 234238719, 234816413, 236054545, 236468313, 237840144, 238263951, 238411720, 239614691, 239830525, 240421736, 240716637, 241172354, 241292216, 241879791, 242320381, 242781191, 242874548, 244194494, 244330833, 245089317) group by geo_enabled;
------------------+-------------+
| screen_name | geo_enabled |
+-----------------+-------------+
| diplocourier | 0 |
| diplocourier | 0 |
| diplocourier | 0 |
| diplocourier | 0 |
| diplocourier | 0 |
| diplocourier | 0 |
| equinempsia | 0 |
| equinempsia | 0 |
| equinempsia | 0 |
| equinempsia | 0 |
| equinempsia | 0 |
| equinempsia | 0 |
| ozbekfunda | 0 |
| ozbekfunda | 0 |
| ozbekfunda | 0 |
| ozbekfunda | 0 |
| ozbekfunda | 0 |
| ozbekfunda | 0 |
| CPSWIRE | 0 |
| CPSWIRE | 0 |
| CPSWIRE | 0 |
| CPSWIRE | 0 |
| CPSWIRE | 0 |
| CPSWIRE | 0 |
| RetweetSMS | 1 |
| RetweetSMS | 1 |
| RetweetSMS | 1 |
| RetweetSMS | 1 |
| RetweetSMS | 1 |
| RetweetSMS | 1 |
| Media_Posts | 0 |
| Media_Posts | 0 |
| Media_Posts | 0 |
| Media_Posts | 0 |
| Media_Posts | 0 |
| Media_Posts | 0 |
| CACHEnews | 0 |
| CACHEnews | 0 |
| CACHEnews | 0 |
| CACHEnews | 0 |
| CACHEnews | 0 |
| CACHEnews | 0 |
| KremenaKrumova | 0 |
| KremenaKrumova | 0 |
| KremenaKrumova | 0 |
| KremenaKrumova | 0 |
| KremenaKrumova | 0 |
| KremenaKrumova | 0 |
| RosieeePosieeee | 0 |
| RosieeePosieeee | 0 |
| RosieeePosieeee | 0 |
| RosieeePosieeee | 0 |
| RosieeePosieeee | 0 |
| RosieeePosieeee | 0 |
| DavideCiotola | 1 |
| DavideCiotola | 1 |
| DavideCiotola | 1 |
| DavideCiotola | 1 |
| DavideCiotola | 1 |
| DavideCiotola | 1 |
+-----------------+-------------+
3978 rows in set (0.07 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment