participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
940 rows where station_code = "UK00C1" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5572621 | 5572621 | 20241121025019_nmQbI | UK00C1 | 2024-11-22T14:18:39.773Z | 2024-11-22T14:19:22.363Z |
5572464 | 5572464 | 20241121022318_zwZJy | UK00C1 | 2024-11-22T14:18:27.844Z | 2024-11-22T14:19:22.332Z |
5572308 | 5572308 | 20241121020829_3yFZm | UK00C1 | 2024-11-22T14:18:14.771Z | 2024-11-22T14:19:22.302Z |
5572163 | 5572163 | 20241121014240_MuSJG | UK00C1 | 2024-11-22T14:18:02.289Z | 2024-11-22T14:19:22.271Z |
5571980 | 5571980 | 20241121011616_nH53Z | UK00C1 | 2024-11-22T14:17:50.592Z | 2024-11-22T14:19:22.235Z |
5571952 | 5571952 | 20241121011002_iB4MB | UK00C1 | 2024-11-22T14:17:48.944Z | 2024-11-22T14:19:22.230Z |
5571936 | 5571936 | 20241121010900_xpbwQ | UK00C1 | 2024-11-22T14:17:47.857Z | 2024-11-22T14:19:22.226Z |
5571877 | 5571877 | 20241121005944_675bG | UK00C1 | 2024-11-22T14:17:44.281Z | 2024-11-22T14:19:22.213Z |
5571556 | 5571556 | 20241121000603_Q4WR8 | UK00C1 | 2024-11-22T14:17:16.624Z | 2024-11-22T14:19:22.147Z |
5571414 | 5571414 | 20241120234015_QA76F | UK00C1 | 2024-11-22T14:17:03.253Z | 2024-11-22T14:19:22.119Z |
5571385 | 5571385 | 20241120233514_mpndf | UK00C1 | 2024-11-22T14:16:59.832Z | 2024-11-22T14:19:22.114Z |
5571340 | 5571340 | 20241120232450_7Fbu8 | UK00C1 | 2024-11-22T14:16:51.874Z | 2024-11-22T14:19:22.104Z |
5570091 | 5570091 | 20241120184000_u3pKc | UK00C1 | 2024-11-22T14:14:50.424Z | 2024-11-22T14:19:21.859Z |
5569864 | 5569864 | 20241120175028_wVzoV | UK00C1 | 2024-11-22T14:14:28.696Z | 2024-11-22T14:19:21.820Z |
5561985 | 5561985 | 20241119224031_2Cfjb | UK00C1 | 2024-11-21T14:14:17.943Z | 2024-11-22T14:20:50.894Z |
5538262 | 5538262 | 20241113025605_X0M11 | UK00C1 | 2024-11-14T14:13:10.384Z | 2024-11-21T14:26:22.836Z |
5538076 | 5538076 | 20241113020637_lFoUa | UK00C1 | 2024-11-14T14:12:49.515Z | 2024-11-21T14:26:20.326Z |
5538033 | 5538033 | 20241113015739_Vum20 | UK00C1 | 2024-11-14T14:12:45.132Z | 2024-11-21T14:26:19.438Z |
5537995 | 5537995 | 20241113015012_Qd6KF | UK00C1 | 2024-11-14T14:12:41.969Z | 2024-11-21T14:26:18.356Z |
5537935 | 5537935 | 20241113013741_gEVC4 | UK00C1 | 2024-11-14T14:12:38.675Z | 2024-11-21T14:26:17.370Z |
5532200 | 5532200 | 20241112045157_suJov | UK00C1 | 2024-11-13T14:16:26.831Z | 2024-11-20T14:26:20.873Z |
5531744 | 5531744 | 20241112040554_3P1R1 | UK00C1 | 2024-11-13T14:15:53.353Z | 2024-11-20T14:26:13.762Z |
5531722 | 5531722 | 20241112040444_tO6j9 | UK00C1 | 2024-11-13T14:15:52.300Z | 2024-11-20T14:26:13.670Z |
5531685 | 5531685 | 20241112040002_LgjzV | UK00C1 | 2024-11-13T14:15:50.552Z | 2024-11-20T14:26:13.433Z |
5531485 | 5531485 | 20241112034250_dh6hj | UK00C1 | 2024-11-13T14:15:42.071Z | 2024-11-20T14:26:11.794Z |
5531255 | 5531255 | 20241112032556_pDsI2 | UK00C1 | 2024-11-13T14:15:31.703Z | 2024-11-20T14:26:09.543Z |
5531040 | 5531040 | 20241112030802_n5bl3 | UK00C1 | 2024-11-13T14:15:05.876Z | 2024-11-20T14:26:06.585Z |
5530215 | 5530215 | 20241112015638_erhNb | UK00C1 | 2024-11-13T14:14:01.796Z | 2024-11-20T14:25:55.435Z |
5530206 | 5530206 | 20241112015624_bQ2kV | UK00C1 | 2024-11-13T14:14:01.612Z | 2024-11-20T14:25:55.419Z |
5529983 | 5529983 | 20241112013231_2fAAn | UK00C1 | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5410246 | 5410246 | 20241027050234_4umfj | UK00C1 | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5409808 | 5409808 | 20241027043623_HzM20 | UK00C1 | 2024-10-29T12:17:41.211Z | 2024-11-04T14:29:02.668Z |
5409583 | 5409583 | 20241027042713_LUPXj | UK00C1 | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.964Z |
5407105 | 5407105 | 20241027022230_r3dcA | UK00C1 | 2024-10-29T12:15:12.389Z | 2024-11-04T14:28:56.846Z |
5402495 | 5402495 | 20241026194509_lP9VO | UK00C1 | 2024-10-29T12:07:24.321Z | 2024-11-04T14:28:44.920Z |
5401962 | 5401962 | 20241026181210_XZPqg | UK00C1 | 2024-10-29T12:05:54.979Z | 2024-11-04T14:28:41.121Z |
5385041 | 5385041 | 20241024214028_C8CMn | UK00C1 | 2024-10-27T12:18:16.687Z | 2024-11-02T12:28:28.980Z |
5384949 | 5384949 | 20241024212057_UR2Q4 | UK00C1 | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.778Z |
5384926 | 5384926 | 20241024211616_W44bK | UK00C1 | 2024-10-27T12:17:58.886Z | 2024-11-02T12:28:28.703Z |
5383975 | 5383975 | 20241024192006_p1jo6 | UK00C1 | 2024-10-27T12:16:35.551Z | 2024-11-02T12:28:26.611Z |
5383447 | 5383447 | 20241024182122_ayR0A | UK00C1 | 2024-10-27T12:15:28.001Z | 2024-11-02T12:28:25.311Z |
5375987 | 5375987 | 20241024033708_wBh61 | UK00C1 | 2024-10-26T12:21:45.693Z | 2024-11-01T12:27:01.305Z |
5375057 | 5375057 | 20241024025511_ta7Eb | UK00C1 | 2024-10-26T12:21:10.874Z | 2024-11-01T12:27:00.131Z |
5374909 | 5374909 | 20241024024853_lWliO | UK00C1 | 2024-10-26T12:21:05.626Z | 2024-11-01T12:27:00.033Z |
5374805 | 5374805 | 20241024024446_2Xtlg | UK00C1 | 2024-10-26T12:21:02.386Z | 2024-11-01T12:26:59.829Z |
5374725 | 5374725 | 20241024024125_UT62c | UK00C1 | 2024-10-26T12:20:59.916Z | 2024-11-01T12:26:59.554Z |
5364636 | 5364636 | 20241023224437_1XVjR | UK00C1 | 2024-10-25T12:17:27.391Z | 2024-11-01T12:26:55.261Z |
5364311 | 5364311 | 20241023222008_HWaSf | UK00C1 | 2024-10-25T12:17:16.238Z | 2024-11-01T12:26:54.665Z |
5363059 | 5363059 | 20241023202230_3ZsRV | UK00C1 | 2024-10-25T12:15:26.383Z | 2024-11-01T12:26:52.803Z |
5354413 | 5354413 | 20241023022538_Quqcr | UK00C1 | 2024-10-24T12:20:32.158Z | 2024-10-31T12:30:05.743Z |
5354330 | 5354330 | 20241023022028_YrI92 | UK00C1 | 2024-10-24T12:20:28.290Z | 2024-10-31T12:30:05.645Z |
5354109 | 5354109 | 20241023020423_MQfXS | UK00C1 | 2024-10-24T12:20:15.739Z | 2024-10-31T12:30:05.363Z |
5353646 | 5353646 | 20241023013738_PwCOo | UK00C1 | 2024-10-24T12:19:50.209Z | 2024-10-31T12:30:04.602Z |
5352957 | 5352957 | 20241023005801_32Eg7 | UK00C1 | 2024-10-24T12:19:27.732Z | 2024-10-31T12:30:03.577Z |
5352874 | 5352874 | 20241023005358_JjYrL | UK00C1 | 2024-10-24T12:19:20.443Z | 2024-10-31T12:30:03.448Z |
5352164 | 5352164 | 20241023001557_0yRqR | UK00C1 | 2024-10-24T12:18:27.808Z | 2024-10-31T12:30:02.258Z |
5351414 | 5351414 | 20241022232626_FvPt5 | UK00C1 | 2024-10-24T12:17:30.614Z | 2024-10-31T12:30:00.313Z |
5351330 | 5351330 | 20241022231716_bwxF0 | UK00C1 | 2024-10-24T12:17:26.838Z | 2024-10-31T12:30:00.206Z |
5350955 | 5350955 | 20241022224416_BN5Tk | UK00C1 | 2024-10-24T12:16:54.948Z | 2024-10-31T12:29:59.141Z |
5350805 | 5350805 | 20241022222942_PwnI1 | UK00C1 | 2024-10-24T12:16:34.114Z | 2024-10-31T12:29:58.804Z |
5350245 | 5350245 | 20241022212932_gEOeE | UK00C1 | 2024-10-24T12:15:31.122Z | 2024-10-31T12:29:57.614Z |
5349588 | 5349588 | 20241022201530_gmvUS | UK00C1 | 2024-10-24T12:14:05.607Z | 2024-10-31T12:29:55.876Z |
5349491 | 5349491 | 20241022200435_yD3WU | UK00C1 | 2024-10-24T12:13:47.511Z | 2024-10-31T12:29:55.610Z |
5349306 | 5349306 | 20241022194114_ZWtmh | UK00C1 | 2024-10-24T12:13:26.458Z | 2024-10-31T12:29:55.023Z |
5349137 | 5349137 | 20241022192734_h22oK | UK00C1 | 2024-10-24T12:13:12.185Z | 2024-10-31T12:29:54.626Z |
5348401 | 5348401 | 20241022181438_oi2vj | UK00C1 | 2024-10-24T12:11:20.924Z | 2024-10-31T12:29:52.375Z |
5338372 | 5338372 | 20241021192259_h9d3d | UK00C1 | 2024-10-23T12:10:50.697Z | 2024-10-30T12:26:42.192Z |
5321630 | 5321630 | 20241018052705_rBSAC | UK00C1 | 2024-10-19T12:07:56.947Z | 2024-10-26T12:27:57.074Z |
5321365 | 5321365 | 20241018044101_2V2Sp | UK00C1 | 2024-10-19T12:07:15.320Z | 2024-10-26T12:27:56.564Z |
5321286 | 5321286 | 20241018042151_lkQ4G | UK00C1 | 2024-10-19T12:07:08.518Z | 2024-10-26T12:27:56.439Z |
5321173 | 5321173 | 20241018035843_HQK68 | UK00C1 | 2024-10-19T12:06:58.643Z | 2024-10-26T12:27:56.262Z |
5319653 | 5319653 | 20241017192037_Eu6Rv | UK00C1 | 2024-10-19T12:03:28.974Z | 2024-10-26T12:27:52.800Z |
5319629 | 5319629 | 20241017190136_nwGLC | UK00C1 | 2024-10-19T12:03:26.117Z | 2024-10-26T12:27:52.716Z |
5304305 | 5304305 | 20241013043426_ZhV8s | UK00C1 | 2024-10-14T12:17:47.576Z | 2024-10-21T12:24:24.715Z |
5291868 | 5291868 | 20241011220849_WQvtM | UK00C1 | 2024-10-13T12:15:22.459Z | 2024-10-20T12:24:37.128Z |
5291728 | 5291728 | 20241011214951_oWicD | UK00C1 | 2024-10-13T12:15:05.568Z | 2024-10-20T12:24:35.458Z |
5291682 | 5291682 | 20241011214156_ob3uA | UK00C1 | 2024-10-13T12:14:59.092Z | 2024-10-20T12:24:34.787Z |
5291663 | 5291663 | 20241011214025_2S0xZ | UK00C1 | 2024-10-13T12:14:57.310Z | 2024-10-20T12:24:34.423Z |
5282527 | 5282527 | 20241010220900_ENxIN | UK00C1 | 2024-10-12T12:15:41.619Z | 2024-10-19T12:27:44.551Z |
5282437 | 5282437 | 20241010214818_oJNBA | UK00C1 | 2024-10-12T12:15:32.980Z | 2024-10-19T12:27:43.781Z |
5282106 | 5282106 | 20241010201515_XHQRs | UK00C1 | 2024-10-12T12:15:12.190Z | 2024-10-19T12:27:40.887Z |
5276803 | 5276803 | 20241011050943_mnkjW | UK00C1 | 2024-10-12T12:01:43.469Z | 2024-10-20T12:23:14.013Z |
5276668 | 5276668 | 20241011045509_6zehK | UK00C1 | 2024-10-12T12:01:28.749Z | 2024-10-20T12:23:12.609Z |
5247781 | 5247781 | 20241007031745_TnM6y | UK00C1 | 2024-10-08T12:00:39.318Z | 2024-10-16T12:20:56.935Z |
5247728 | 5247728 | 20241007031243_L2FUU | UK00C1 | 2024-10-08T12:00:32.365Z | 2024-10-16T12:20:56.547Z |
5239341 | 5239341 | 20241005035131_1Gb3D | UK00C1 | 2024-10-07T12:06:17.544Z | 2024-10-14T12:24:19.060Z |
5239185 | 5239185 | 20241005033640_mGjoD | UK00C1 | 2024-10-07T12:06:04.554Z | 2024-10-14T12:24:18.627Z |
5227818 | 5227818 | 20241004014837_BCTt2 | UK00C1 | 2024-10-05T12:21:40.408Z | 2024-10-12T12:25:13.040Z |
5227074 | 5227074 | 20241004010026_2S3nH | UK00C1 | 2024-10-05T12:21:12.059Z | 2024-10-12T12:25:12.416Z |
5226332 | 5226332 | 20241004000633_1VoD5 | UK00C1 | 2024-10-05T12:20:37.668Z | 2024-10-12T12:25:11.606Z |
5225852 | 5225852 | 20241003232243_EQb6r | UK00C1 | 2024-10-05T12:20:13.578Z | 2024-10-12T12:25:10.934Z |
5225747 | 5225747 | 20241003231547_CnopA | UK00C1 | 2024-10-05T12:20:07.142Z | 2024-10-12T12:25:10.722Z |
5225582 | 5225582 | 20241003225713_sit27 | UK00C1 | 2024-10-05T12:19:55.924Z | 2024-10-12T12:25:10.432Z |
5223665 | 5223665 | 20241003191649_pRAwL | UK00C1 | 2024-10-05T12:17:24.258Z | 2024-10-12T12:25:06.888Z |
5223532 | 5223532 | 20241003185700_LNKYJ | UK00C1 | 2024-10-05T12:17:12.984Z | 2024-10-12T12:25:06.427Z |
5218615 | 5218615 | 20241004035459_2U8jg | UK00C1 | 2024-10-05T12:04:47.953Z | 2024-10-13T12:26:08.761Z |
5218500 | 5218500 | 20241004034459_TSqFY | UK00C1 | 2024-10-05T12:04:29.714Z | 2024-10-13T12:26:08.657Z |
5218409 | 5218409 | 20241004033712_3tjIa | UK00C1 | 2024-10-05T12:04:17.373Z | 2024-10-13T12:26:08.457Z |
5216848 | 5216848 | 20241003013056_QKvwO | UK00C1 | 2024-10-04T12:13:51.234Z | 2024-10-11T12:23:37.823Z |
5216760 | 5216760 | 20241003012301_jgE3G | UK00C1 | 2024-10-04T12:13:46.359Z | 2024-10-11T12:23:37.749Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);