participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,037 rows where station_code = "UK0060" 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 |
---|---|---|---|---|---|
5136028 | 5136028 | 20240918212515_Wi2yd | UK0060 | 2024-09-20T12:01:06.170Z | 2024-09-27T12:19:43.386Z |
5135842 | 5135842 | 20240918200505_f8z0d | UK0060 | 2024-09-20T12:00:39.409Z | 2024-09-27T12:19:42.443Z |
5135315 | 5135315 | 20240915040245_zGMqY | UK0060 | 2024-09-19T12:19:13.340Z | 2024-09-23T12:16:23.947Z |
5133783 | 5133783 | 20240916040518_Xlwwt | UK0060 | 2024-09-19T12:17:07.990Z | 2024-09-24T12:15:51.363Z |
5133511 | 5133511 | 20240916033456_KUEmW | UK0060 | 2024-09-19T12:17:00.267Z | 2024-09-24T12:15:49.879Z |
5129672 | 5129672 | 20240917042148_53vsL | UK0060 | 2024-09-19T12:12:00.538Z | 2024-09-25T12:22:32.365Z |
5129400 | 5129400 | 20240917035457_VPmvh | UK0060 | 2024-09-19T12:11:34.640Z | 2024-09-25T12:22:30.610Z |
5124882 | 5124882 | 20240917223523_WW6Ik | UK0060 | 2024-09-19T12:01:43.998Z | 2024-09-26T12:18:35.612Z |
5117212 | 5117212 | 20240915041252_4Zis3 | UK0060 | 2024-09-18T12:07:35.679Z | 2024-09-23T12:16:24.237Z |
5117162 | 5117162 | 20240915040711_ETWrb | UK0060 | 2024-09-18T12:07:34.310Z | 2024-09-23T12:16:24.113Z |
5116952 | 5116952 | 20240915035119_yDVH0 | UK0060 | 2024-09-18T12:07:26.631Z | 2024-09-23T12:16:23.442Z |
5116713 | 5116713 | 20240915033724_p3md7 | UK0060 | 2024-09-18T12:07:17.601Z | 2024-09-23T12:16:22.560Z |
5116685 | 5116685 | 20240915033650_JsdV6 | UK0060 | 2024-09-18T12:07:16.695Z | 2024-09-23T12:16:22.542Z |
5116646 | 5116646 | 20240915033414_U3Hq6 | UK0060 | 2024-09-18T12:07:14.586Z | 2024-09-23T12:16:22.155Z |
5116528 | 5116528 | 20240915033058_N4Qn0 | UK0060 | 2024-09-18T12:07:08.915Z | 2024-09-23T12:16:21.621Z |
5116449 | 5116449 | 20240915032640_CI2LX | UK0060 | 2024-09-18T12:07:03.972Z | 2024-09-23T12:16:21.414Z |
5115652 | 5115652 | 20240915024711_AbFZ5 | UK0060 | 2024-09-18T12:06:20.400Z | 2024-09-23T12:16:18.431Z |
5115582 | 5115582 | 20240915024448_01C53 | UK0060 | 2024-09-18T12:06:17.979Z | 2024-09-23T12:16:17.496Z |
5115145 | 5115145 | 20240915022210_sU2UB | UK0060 | 2024-09-18T12:06:03.526Z | 2024-09-23T12:16:15.985Z |
5115011 | 5115011 | 20240915021323_HVCtY | UK0060 | 2024-09-18T12:05:50.974Z | 2024-09-23T12:16:15.462Z |
5114998 | 5114998 | 20240915021309_nvDxB | UK0060 | 2024-09-18T12:05:50.408Z | 2024-09-23T12:16:15.454Z |
5114761 | 5114761 | 20240915015743_9K7A3 | UK0060 | 2024-09-18T12:05:33.744Z | 2024-09-23T12:16:14.128Z |
5114508 | 5114508 | 20240915014454_RF4lc | UK0060 | 2024-09-18T12:05:19.969Z | 2024-09-23T12:16:13.550Z |
5114316 | 5114316 | 20240915013637_urfjS | UK0060 | 2024-09-18T12:05:10.561Z | 2024-09-23T12:16:12.895Z |
5114296 | 5114296 | 20240915013500_FRf7e | UK0060 | 2024-09-18T12:05:09.545Z | 2024-09-23T12:16:12.852Z |
5114024 | 5114024 | 20240915012337_AGBJ0 | UK0060 | 2024-09-18T12:04:59.007Z | 2024-09-23T12:16:12.054Z |
5111505 | 5111505 | 20240914204302_3jFoI | UK0060 | 2024-09-18T12:01:59.962Z | 2024-09-23T12:15:57.354Z |
5026077 | 5026077 | 20240905021229_AkZud | UK0060 | 2024-09-11T12:11:52.629Z | 2024-09-13T12:19:56.752Z |
5026060 | 5026060 | 20240905020923_QV3Xx | UK0060 | 2024-09-11T12:11:51.298Z | 2024-09-13T12:19:56.710Z |
5025983 | 5025983 | 20240905015357_7G8Qc | UK0060 | 2024-09-11T12:11:40.222Z | 2024-09-13T12:19:56.481Z |
5025872 | 5025872 | 20240905013240_7mPEf | UK0060 | 2024-09-11T12:11:21.191Z | 2024-09-13T12:19:55.988Z |
5025864 | 5025864 | 20240905013211_0SXuc | UK0060 | 2024-09-11T12:11:20.371Z | 2024-09-13T12:19:55.965Z |
5020514 | 5020514 | 20240905021229_oev8h | UK0060 | 2024-09-10T12:14:37.870Z | 2024-09-10T12:16:55.168Z |
5020495 | 5020495 | 20240905020923_1wPAW | UK0060 | 2024-09-10T12:14:35.264Z | 2024-09-10T12:16:55.164Z |
5020420 | 5020420 | 20240905015357_Th7WG | UK0060 | 2024-09-10T12:14:26.882Z | 2024-09-10T12:16:55.146Z |
5020311 | 5020311 | 20240905013240_Igo1G | UK0060 | 2024-09-10T12:14:18.173Z | 2024-09-10T12:16:55.123Z |
5020303 | 5020303 | 20240905013211_J12zu | UK0060 | 2024-09-10T12:14:17.186Z | 2024-09-10T12:16:55.122Z |
5020008 | 5020008 | 20240905003635_mlF9e | UK0060 | 2024-09-10T12:13:49.468Z | 2024-09-13T12:19:54.802Z |
5019960 | 5019960 | 20240905002707_XECLD | UK0060 | 2024-09-10T12:13:46.008Z | 2024-09-13T12:19:54.636Z |
5019928 | 5019928 | 20240905001937_TwS7H | UK0060 | 2024-09-10T12:13:43.729Z | 2024-09-13T12:19:54.428Z |
5019921 | 5019921 | 20240905001804_g5GkV | UK0060 | 2024-09-10T12:13:43.376Z | 2024-09-13T12:19:54.421Z |
5019881 | 5019881 | 20240905001155_zIUvA | UK0060 | 2024-09-10T12:13:40.000Z | 2024-09-13T12:19:54.200Z |
5019762 | 5019762 | 20240904234654_NhZup | UK0060 | 2024-09-10T12:13:25.269Z | 2024-09-13T12:19:53.718Z |
5018914 | 5018914 | 20240904210257_vP5ga | UK0060 | 2024-09-10T12:11:45.086Z | 2024-09-13T12:19:49.764Z |
5008627 | 5008627 | 20240904000400_11IGC | UK0060 | 2024-09-09T12:06:56.111Z | 2024-09-12T12:19:18.474Z |
5008583 | 5008583 | 20240903235856_YyQe0 | UK0060 | 2024-09-09T12:06:54.318Z | 2024-09-12T12:19:18.221Z |
5008559 | 5008559 | 20240903235340_KZgFT | UK0060 | 2024-09-09T12:06:52.875Z | 2024-09-12T12:19:18.075Z |
5008373 | 5008373 | 20240903233742_mC3d5 | UK0060 | 2024-09-09T12:06:39.382Z | 2024-09-12T12:19:17.343Z |
4981856 | 4981856 | 20240812002743_g3s41 | UK0060 | 2024-09-06T12:14:39.024Z | 2024-09-06T12:14:39.024Z |
4979697 | 4979697 | 20240812000340_BHBlA | UK0060 | 2024-09-06T12:13:22.809Z | 2024-09-06T12:13:22.809Z |
4979537 | 4979537 | 20240812000226_51ifR | UK0060 | 2024-09-06T12:13:18.031Z | 2024-09-06T12:13:18.031Z |
4978855 | 4978855 | 20240811235604_4zoBC | UK0060 | 2024-09-06T12:12:44.262Z | 2024-09-06T12:12:44.262Z |
4978812 | 4978812 | 20240811235541_GfUgi | UK0060 | 2024-09-06T12:12:43.238Z | 2024-09-06T12:12:43.238Z |
4978412 | 4978412 | 20240811235037_y0wCK | UK0060 | 2024-09-06T12:12:33.465Z | 2024-09-06T12:12:33.465Z |
4978362 | 4978362 | 20240811235019_8IXut | UK0060 | 2024-09-06T12:12:32.989Z | 2024-09-06T12:12:32.989Z |
4978202 | 4978202 | 20240811234851_FWXHE | UK0060 | 2024-09-06T12:12:30.961Z | 2024-09-06T12:12:30.961Z |
4977754 | 4977754 | 20240811234434_cy48V | UK0060 | 2024-09-06T12:12:22.983Z | 2024-09-06T12:12:22.983Z |
4977093 | 4977093 | 20240811233607_kn7Mk | UK0060 | 2024-09-06T12:12:03.688Z | 2024-09-06T12:12:03.688Z |
4976754 | 4976754 | 20240811233259_jZnzz | UK0060 | 2024-09-06T12:11:44.829Z | 2024-09-06T12:11:44.829Z |
4976597 | 4976597 | 20240811233206_g3J0v | UK0060 | 2024-09-06T12:11:40.307Z | 2024-09-06T12:11:40.307Z |
4976452 | 4976452 | 20240811233012_FS0Ss | UK0060 | 2024-09-06T12:11:32.794Z | 2024-09-06T12:11:32.794Z |
4975404 | 4975404 | 20240811231753_lqZ3T | UK0060 | 2024-09-05T12:11:48.789Z | 2024-09-06T12:10:41.090Z |
4975349 | 4975349 | 20240811231724_dO232 | UK0060 | 2024-09-05T12:11:45.810Z | 2024-09-06T12:10:40.178Z |
4975183 | 4975183 | 20240811231554_T68Js | UK0060 | 2024-09-05T12:11:41.483Z | 2024-09-06T12:10:38.425Z |
4974460 | 4974460 | 20240811230715_iUUFb | UK0060 | 2024-09-05T12:11:24.725Z | 2024-09-06T12:10:26.759Z |
4974412 | 4974412 | 20240811230647_TCUNZ | UK0060 | 2024-09-05T12:11:24.263Z | 2024-09-06T12:10:26.458Z |
4974337 | 4974337 | 20240811230556_3SSJj | UK0060 | 2024-09-05T12:11:23.318Z | 2024-09-06T12:10:25.672Z |
4973989 | 4973989 | 20240811230219_VoUDC | UK0060 | 2024-09-05T12:11:15.762Z | 2024-09-06T12:10:14.318Z |
4972883 | 4972883 | 20240811225130_Wq2wx | UK0060 | 2024-09-05T12:10:36.591Z | 2024-09-06T12:09:32.378Z |
4972461 | 4972461 | 20240811224622_IpTKP | UK0060 | 2024-09-05T12:10:25.510Z | 2024-09-06T12:09:14.260Z |
4972432 | 4972432 | 20240811224556_L6WBD | UK0060 | 2024-09-05T12:10:24.924Z | 2024-09-06T12:09:13.524Z |
4972376 | 4972376 | 20240811224526_B1NWn | UK0060 | 2024-09-05T12:10:23.746Z | 2024-09-06T12:09:11.704Z |
4972279 | 4972279 | 20240811224439_2FJDA | UK0060 | 2024-09-05T12:10:20.918Z | 2024-09-06T12:09:07.870Z |
4972107 | 4972107 | 20240811224300_Nekxe | UK0060 | 2024-09-05T12:10:17.059Z | 2024-09-06T12:09:04.819Z |
4972084 | 4972084 | 20240811224248_FnmVR | UK0060 | 2024-09-05T12:10:15.981Z | 2024-09-06T12:09:04.609Z |
4971724 | 4971724 | 20240811223859_wCGRj | UK0060 | 2024-09-05T12:09:56.202Z | 2024-09-06T12:08:57.045Z |
4971353 | 4971353 | 20240811223432_HuxF3 | UK0060 | 2024-09-05T12:09:43.357Z | 2024-09-06T12:08:52.499Z |
4970936 | 4970936 | 20240811222948_Xklqe | UK0060 | 2024-09-05T12:09:34.642Z | 2024-09-06T12:08:46.699Z |
4970854 | 4970854 | 20240811222901_wuU3U | UK0060 | 2024-09-05T12:09:33.009Z | 2024-09-06T12:08:45.364Z |
4970182 | 4970182 | 20240811222204_VJPvn | UK0060 | 2024-09-05T12:09:20.797Z | 2024-09-06T12:08:28.666Z |
4969907 | 4969907 | 20240811221825_evPsw | UK0060 | 2024-09-05T12:09:10.498Z | 2024-09-06T12:08:14.249Z |
4968418 | 4968418 | 20240811215826_2J7tH | UK0060 | 2024-09-05T12:08:18.758Z | 2024-09-06T12:07:30.152Z |
4968379 | 4968379 | 20240811215745_dN2iM | UK0060 | 2024-09-05T12:08:15.350Z | 2024-09-06T12:07:29.161Z |
4968121 | 4968121 | 20240811215437_1MpOl | UK0060 | 2024-09-05T12:08:03.097Z | 2024-09-06T12:07:24.740Z |
4967785 | 4967785 | 20240811214951_d6lrg | UK0060 | 2024-09-05T12:07:48.636Z | 2024-09-06T12:07:09.057Z |
4967708 | 4967708 | 20240811214821_5E2gJ | UK0060 | 2024-09-05T12:07:46.033Z | 2024-09-06T12:07:07.528Z |
4967499 | 4967499 | 20240811214502_1gJPo | UK0060 | 2024-09-05T12:07:40.666Z | 2024-09-06T12:07:01.165Z |
4967321 | 4967321 | 20240811214210_pIv8H | UK0060 | 2024-09-05T12:07:35.586Z | 2024-09-06T12:06:56.983Z |
4966454 | 4966454 | 20240811213010_vnIlC | UK0060 | 2024-09-04T12:07:27.632Z | 2024-09-06T12:06:30.065Z |
4965977 | 4965977 | 20240811212141_hdXi2 | UK0060 | 2024-09-04T12:07:14.848Z | 2024-09-06T12:06:08.944Z |
4965706 | 4965706 | 20240811211807_Y9C33 | UK0060 | 2024-09-04T12:07:06.098Z | 2024-09-06T12:06:01.994Z |
4965567 | 4965567 | 20240811211656_dQ23b | UK0060 | 2024-09-04T12:07:01.230Z | 2024-09-06T12:05:59.856Z |
4964697 | 4964697 | 20240811210115_PElgE | UK0060 | 2024-09-04T12:06:31.801Z | 2024-09-06T12:05:29.409Z |
4964658 | 4964658 | 20240811210013_FJD90 | UK0060 | 2024-09-04T12:06:30.721Z | 2024-09-06T12:05:27.297Z |
4964317 | 4964317 | 20240811205202_3tb18 | UK0060 | 2024-09-04T12:06:18.039Z | 2024-09-06T12:05:17.410Z |
4949666 | 4949666 | 20240811015343_HBsEY | UK0060 | 2024-09-02T12:15:52.378Z | 2024-09-06T12:27:36.548Z |
4944254 | 4944254 | 20240811002556_zL94J | UK0060 | 2024-09-02T12:12:26.134Z | 2024-09-06T12:25:16.501Z |
4944199 | 4944199 | 20240811002514_KR5dc | UK0060 | 2024-09-02T12:12:25.090Z | 2024-09-06T12:25:15.924Z |
4943950 | 4943950 | 20240811001945_V1g2X | UK0060 | 2024-09-02T12:12:15.279Z | 2024-09-06T12:25:06.974Z |
4943692 | 4943692 | 20240811001548_meNi2 | UK0060 | 2024-09-02T12:12:04.902Z | 2024-09-06T12:25:01.431Z |
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);