participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK003X" 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 |
---|---|---|---|---|---|
5406584 | 5406584 | 20241027014709_n6cY3 | UK003X | 2024-10-29T12:14:22.810Z | 2024-11-04T14:28:55.890Z |
5406302 | 5406302 | 20241027012647_e1hSo | UK003X | 2024-10-29T12:14:01.490Z | 2024-11-04T14:28:55.422Z |
5406153 | 5406153 | 20241027011941_us5rC | UK003X | 2024-10-29T12:13:54.080Z | 2024-11-04T14:28:55.168Z |
5406076 | 5406076 | 20241027011419_PO33W | UK003X | 2024-10-29T12:13:50.498Z | 2024-11-04T14:28:54.974Z |
5405992 | 5405992 | 20241027011156_4fZZZ | UK003X | 2024-10-29T12:13:45.289Z | 2024-11-04T14:28:54.829Z |
5405879 | 5405879 | 20241027010546_fxSH3 | UK003X | 2024-10-29T12:13:27.709Z | 2024-11-04T14:28:54.559Z |
5405767 | 5405767 | 20241027005652_q7IMQ | UK003X | 2024-10-29T12:13:14.401Z | 2024-11-04T14:28:54.169Z |
5405290 | 5405290 | 20241027002707_xYNQt | UK003X | 2024-10-29T12:12:48.269Z | 2024-11-04T14:28:53.254Z |
5405253 | 5405253 | 20241027002547_lNBYz | UK003X | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.177Z |
5405042 | 5405042 | 20241027001005_sYxuw | UK003X | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404676 | 5404676 | 20241026234422_CluJZ | UK003X | 2024-10-29T12:11:50.205Z | 2024-11-04T14:28:51.517Z |
5404610 | 5404610 | 20241026234047_H30uQ | UK003X | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404400 | 5404400 | 20241026232310_huiNO | UK003X | 2024-10-29T12:11:18.993Z | 2024-11-04T14:28:50.851Z |
5404270 | 5404270 | 20241026231312_2dMb8 | UK003X | 2024-10-29T12:11:04.002Z | 2024-11-04T14:28:50.571Z |
5404169 | 5404169 | 20241026230351_UeIko | UK003X | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5404141 | 5404141 | 20241026230210_OO3ek | UK003X | 2024-10-29T12:10:55.886Z | 2024-11-04T14:28:50.356Z |
5404085 | 5404085 | 20241026225640_Mx9Bw | UK003X | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5404016 | 5404016 | 20241026225307_zY5cN | UK003X | 2024-10-29T12:10:48.284Z | 2024-11-04T14:28:50.242Z |
5403733 | 5403733 | 20241026222636_tlNb2 | UK003X | 2024-10-29T12:10:10.593Z | 2024-11-04T14:28:49.527Z |
5403666 | 5403666 | 20241026222240_C47Zp | UK003X | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403432 | 5403432 | 20241026215616_gM3Z8 | UK003X | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403275 | 5403275 | 20241026213540_6RNrh | UK003X | 2024-10-29T12:09:18.338Z | 2024-11-04T14:28:48.259Z |
5403074 | 5403074 | 20241026211518_74PqD | UK003X | 2024-10-29T12:08:52.434Z | 2024-11-04T14:28:47.680Z |
5403041 | 5403041 | 20241026210855_8qLR2 | UK003X | 2024-10-29T12:08:48.264Z | 2024-11-04T14:28:47.607Z |
5402909 | 5402909 | 20241026204325_eInjn | UK003X | 2024-10-29T12:08:35.112Z | 2024-11-04T14:28:46.934Z |
5402787 | 5402787 | 20241026202432_iupb7 | UK003X | 2024-10-29T12:08:08.247Z | 2024-11-04T14:28:46.528Z |
5402746 | 5402746 | 20241026201918_PXVF6 | UK003X | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402533 | 5402533 | 20241026195313_LVKHv | UK003X | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402484 | 5402484 | 20241026194441_2luwM | UK003X | 2024-10-29T12:07:23.496Z | 2024-11-04T14:28:44.772Z |
5402375 | 5402375 | 20241026192444_MS5ox | UK003X | 2024-10-29T12:07:07.006Z | 2024-11-04T14:28:44.162Z |
5402276 | 5402276 | 20241026190926_Fh2Md | UK003X | 2024-10-29T12:06:52.216Z | 2024-11-04T14:28:43.594Z |
5402237 | 5402237 | 20241026190525_zPSdF | UK003X | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5402125 | 5402125 | 20241026184707_7buar | UK003X | 2024-10-29T12:06:28.717Z | 2024-11-04T14:28:42.411Z |
5402004 | 5402004 | 20241026182338_ydLlA | UK003X | 2024-10-29T12:06:03.268Z | 2024-11-04T14:28:41.538Z |
5385637 | 5385637 | 20241024231121_13APy | UK003X | 2024-10-27T12:19:12.426Z | 2024-11-02T12:28:30.006Z |
5385487 | 5385487 | 20241024225328_njVJz | UK003X | 2024-10-27T12:18:59.769Z | 2024-11-02T12:28:29.882Z |
5384921 | 5384921 | 20241024211616_W44bK | UK003X | 2024-10-27T12:17:58.882Z | 2024-11-02T12:28:28.703Z |
5384894 | 5384894 | 20241024211316_agnBZ | UK003X | 2024-10-27T12:17:56.655Z | 2024-11-02T12:28:28.579Z |
5384606 | 5384606 | 20241024202754_FAtyB | UK003X | 2024-10-27T12:17:17.640Z | 2024-11-02T12:28:27.399Z |
5384111 | 5384111 | 20241024193725_FmTJ2 | UK003X | 2024-10-27T12:16:47.675Z | 2024-11-02T12:28:26.760Z |
5377956 | 5377956 | 20241024051937_918K6 | UK003X | 2024-10-26T12:22:50.896Z | 2024-11-01T12:27:03.200Z |
5377891 | 5377891 | 20241024051628_rj81p | UK003X | 2024-10-26T12:22:49.324Z | 2024-11-01T12:27:03.154Z |
5377773 | 5377773 | 20241024050923_2pBoi | UK003X | 2024-10-26T12:22:46.807Z | 2024-11-01T12:27:02.814Z |
5377373 | 5377373 | 20241024044759_uqEd1 | UK003X | 2024-10-26T12:22:35.427Z | 2024-11-01T12:27:02.411Z |
5377266 | 5377266 | 20241024044136_Ew0Pi | UK003X | 2024-10-26T12:22:32.470Z | 2024-11-01T12:27:02.341Z |
5377257 | 5377257 | 20241024044136_Dbg5m | UK003X | 2024-10-26T12:22:32.237Z | 2024-11-01T12:27:02.340Z |
5377180 | 5377180 | 20241024043732_5mO3X | UK003X | 2024-10-26T12:22:29.836Z | 2024-11-01T12:27:02.254Z |
5376905 | 5376905 | 20241024042225_bPXhT | UK003X | 2024-10-26T12:22:16.518Z | 2024-11-01T12:27:01.911Z |
5376577 | 5376577 | 20241024040236_3V73z | UK003X | 2024-10-26T12:22:05.268Z | 2024-11-01T12:27:01.605Z |
5376324 | 5376324 | 20241024035140_ZaP1s | UK003X | 2024-10-26T12:21:56.829Z | 2024-11-01T12:27:01.501Z |
5376224 | 5376224 | 20241024034600_ZpLqH | UK003X | 2024-10-26T12:21:53.772Z | 2024-11-01T12:27:01.463Z |
5375974 | 5375974 | 20241024033702_m73UA | UK003X | 2024-10-26T12:21:45.417Z | 2024-11-01T12:27:01.301Z |
5375841 | 5375841 | 20241024033229_nKCCg | UK003X | 2024-10-26T12:21:41.625Z | 2024-11-01T12:27:01.219Z |
5375821 | 5375821 | 20241024033205_Du9An | UK003X | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5375783 | 5375783 | 20241024032929_74r6X | UK003X | 2024-10-26T12:21:39.566Z | 2024-11-01T12:27:01.194Z |
5375689 | 5375689 | 20241024032459_rHgjz | UK003X | 2024-10-26T12:21:35.762Z | 2024-11-01T12:27:01.162Z |
5375253 | 5375253 | 20241024030431_3DhCb | UK003X | 2024-10-26T12:21:17.443Z | 2024-11-01T12:27:00.462Z |
5375196 | 5375196 | 20241024030204_1qbrG | UK003X | 2024-10-26T12:21:16.596Z | 2024-11-01T12:27:00.438Z |
5374629 | 5374629 | 20241024023712_ANSMv | UK003X | 2024-10-26T12:20:55.198Z | 2024-11-01T12:26:59.522Z |
5374588 | 5374588 | 20241024023607_67m4j | UK003X | 2024-10-26T12:20:54.339Z | 2024-11-01T12:26:59.514Z |
5374289 | 5374289 | 20241024022030_DyxCL | UK003X | 2024-10-26T12:20:43.917Z | 2024-11-01T12:26:58.827Z |
5374057 | 5374057 | 20241024020802_kNfyV | UK003X | 2024-10-26T12:20:35.665Z | 2024-11-01T12:26:58.683Z |
5373664 | 5373664 | 20241024014900_Fjb2V | UK003X | 2024-10-26T12:20:20.504Z | 2024-11-01T12:26:58.357Z |
5373356 | 5373356 | 20241024013422_30UCm | UK003X | 2024-10-26T12:20:08.815Z | 2024-11-01T12:26:58.233Z |
5373077 | 5373077 | 20241024012248_Rl1U2 | UK003X | 2024-10-26T12:19:56.263Z | 2024-11-01T12:26:58.124Z |
5372989 | 5372989 | 20241024011743_32VbZ | UK003X | 2024-10-26T12:19:51.321Z | 2024-11-01T12:26:58.060Z |
5372539 | 5372539 | 20241024005358_q6ZT7 | UK003X | 2024-10-26T12:19:29.671Z | 2024-11-01T12:26:57.511Z |
5372392 | 5372392 | 20241024004639_zmXa2 | UK003X | 2024-10-26T12:19:23.230Z | 2024-11-01T12:26:57.428Z |
5367141 | 5367141 | 20241023053605_Gx4A8 | UK003X | 2024-10-25T12:21:46.760Z | 2024-10-31T12:30:11.553Z |
5365145 | 5365145 | 20241023231704_WTNLs | UK003X | 2024-10-25T12:17:47.577Z | 2024-11-01T12:26:55.892Z |
5364770 | 5364770 | 20241023225211_o2Fbj | UK003X | 2024-10-25T12:17:33.873Z | 2024-11-01T12:26:55.624Z |
5364631 | 5364631 | 20241023224437_1XVjR | UK003X | 2024-10-25T12:17:27.391Z | 2024-11-01T12:26:55.261Z |
5364482 | 5364482 | 20241023223159_r8h2B | UK003X | 2024-10-25T12:17:22.530Z | 2024-11-01T12:26:55.116Z |
5363648 | 5363648 | 20241023213113_7jwaR | UK003X | 2024-10-25T12:16:31.828Z | 2024-11-01T12:26:53.479Z |
5363591 | 5363591 | 20241023212611_DkPbL | UK003X | 2024-10-25T12:16:26.545Z | 2024-11-01T12:26:53.454Z |
5363377 | 5363377 | 20241023205421_kYHJG | UK003X | 2024-10-25T12:16:02.604Z | 2024-11-01T12:26:53.239Z |
5362769 | 5362769 | 20241023195909_YAsTX | UK003X | 2024-10-25T12:15:06.610Z | 2024-11-01T12:26:52.352Z |
5362105 | 5362105 | 20241023190849_2XPCh | UK003X | 2024-10-25T12:13:52.145Z | 2024-11-01T12:26:50.996Z |
5361484 | 5361484 | 20241023182105_06emf | UK003X | 2024-10-25T12:12:45.885Z | 2024-11-01T12:26:50.271Z |
5356266 | 5356266 | 20241023052711_RBgK2 | UK003X | 2024-10-24T12:21:56.951Z | 2024-10-31T12:30:11.197Z |
5356005 | 5356005 | 20241023044916_imlGN | UK003X | 2024-10-24T12:21:47.011Z | 2024-10-31T12:30:09.497Z |
5350690 | 5350690 | 20241022221539_LmC5O | UK003X | 2024-10-24T12:16:16.010Z | 2024-10-31T12:29:58.664Z |
5350442 | 5350442 | 20241022215115_EfpSs | UK003X | 2024-10-24T12:15:46.145Z | 2024-10-31T12:29:58.191Z |
5350131 | 5350131 | 20241022211604_mdZTw | UK003X | 2024-10-24T12:15:23.691Z | 2024-10-31T12:29:57.344Z |
5349886 | 5349886 | 20241022204409_7sle2 | UK003X | 2024-10-24T12:14:45.858Z | 2024-10-31T12:29:56.830Z |
5349379 | 5349379 | 20241022195030_hQ2Op | UK003X | 2024-10-24T12:13:33.758Z | 2024-10-31T12:29:55.160Z |
5349225 | 5349225 | 20241022193507_jCC3J | UK003X | 2024-10-24T12:13:19.921Z | 2024-10-31T12:29:54.917Z |
5349132 | 5349132 | 20241022192734_h22oK | UK003X | 2024-10-24T12:13:12.185Z | 2024-10-31T12:29:54.626Z |
5349024 | 5349024 | 20241022192042_eZCoK | UK003X | 2024-10-24T12:12:54.287Z | 2024-10-31T12:29:54.491Z |
5348838 | 5348838 | 20241022190224_bwiZE | UK003X | 2024-10-24T12:12:25.272Z | 2024-10-31T12:29:53.856Z |
5348810 | 5348810 | 20241022185958_WY3bk | UK003X | 2024-10-24T12:12:22.216Z | 2024-10-31T12:29:53.819Z |
5345228 | 5345228 | 20241022052800_A5DLb | UK003X | 2024-10-23T12:19:11.608Z | 2024-10-30T12:26:52.310Z |
5345213 | 5345213 | 20241022052620_h2I3Y | UK003X | 2024-10-23T12:19:11.211Z | 2024-10-30T12:26:52.302Z |
5345138 | 5345138 | 20241022051502_d88ED | UK003X | 2024-10-23T12:19:07.341Z | 2024-10-30T12:26:52.226Z |
5344501 | 5344501 | 20241022042747_9JbMs | UK003X | 2024-10-23T12:18:40.004Z | 2024-10-30T12:26:51.292Z |
5343641 | 5343641 | 20241022033922_Hw0ma | UK003X | 2024-10-23T12:17:58.361Z | 2024-10-30T12:26:50.380Z |
5343358 | 5343358 | 20241022032505_2sIKS | UK003X | 2024-10-23T12:17:44.183Z | 2024-10-30T12:26:49.974Z |
5343340 | 5343340 | 20241022032333_WRRvl | UK003X | 2024-10-23T12:17:43.474Z | 2024-10-30T12:26:49.961Z |
5343117 | 5343117 | 20241022031004_o1jRG | UK003X | 2024-10-23T12:17:35.163Z | 2024-10-30T12:26:49.412Z |
5343104 | 5343104 | 20241022030943_07m8I | UK003X | 2024-10-23T12:17:35.103Z | 2024-10-30T12:26:49.394Z |
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);