participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,512 rows where station_code = "UK002X" 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 |
---|---|---|---|---|---|
5573146 | 5573146 | 20241121040016_f2RMv | UK002X | 2024-11-22T14:19:12.763Z | 2024-11-22T14:19:22.460Z |
5572225 | 5572225 | 20241121015416_xnJkx | UK002X | 2024-11-22T14:18:05.848Z | 2024-11-22T14:19:22.283Z |
5572184 | 5572184 | 20241121014450_iLf13 | UK002X | 2024-11-22T14:18:03.836Z | 2024-11-22T14:19:22.276Z |
5571703 | 5571703 | 20241121003544_DZFM1 | UK002X | 2024-11-22T14:17:35.741Z | 2024-11-22T14:19:22.179Z |
5571648 | 5571648 | 20241121002657_1awaK | UK002X | 2024-11-22T14:17:32.326Z | 2024-11-22T14:19:22.166Z |
5571623 | 5571623 | 20241121002047_Ypq6P | UK002X | 2024-11-22T14:17:27.141Z | 2024-11-22T14:19:22.161Z |
5571575 | 5571575 | 20241121001042_zFArK | UK002X | 2024-11-22T14:17:20.185Z | 2024-11-22T14:19:22.152Z |
5571371 | 5571371 | 20241120233302_8CrQK | UK002X | 2024-11-22T14:16:58.592Z | 2024-11-22T14:19:22.113Z |
5571299 | 5571299 | 20241120231742_fsGAG | UK002X | 2024-11-22T14:16:49.587Z | 2024-11-22T14:19:22.095Z |
5571178 | 5571178 | 20241120224359_oELIY | UK002X | 2024-11-22T14:16:34.453Z | 2024-11-22T14:19:22.057Z |
5570758 | 5570758 | 20241120205052_QA9Hj | UK002X | 2024-11-22T14:16:04.197Z | 2024-11-22T14:19:21.975Z |
5570574 | 5570574 | 20241120201635_rpRJp | UK002X | 2024-11-22T14:15:49.194Z | 2024-11-22T14:19:21.941Z |
5570023 | 5570023 | 20241120182432_DOc2U | UK002X | 2024-11-22T14:14:45.814Z | 2024-11-22T14:19:21.848Z |
5569929 | 5569929 | 20241120180140_spbp7 | UK002X | 2024-11-22T14:14:37.981Z | 2024-11-22T14:19:21.831Z |
5569840 | 5569840 | 20241120174513_la8qv | UK002X | 2024-11-22T14:14:24.606Z | 2024-11-22T14:19:21.816Z |
5566337 | 5566337 | 20241121060207_aXcBg | UK002X | 2024-11-22T14:02:29.622Z | 2024-11-22T14:02:29.622Z |
5566326 | 5566326 | 20241121060058_toTMz | UK002X | 2024-11-22T14:02:28.274Z | 2024-11-22T14:02:28.274Z |
5566280 | 5566280 | 20241121055510_Sy06k | UK002X | 2024-11-22T14:02:21.583Z | 2024-11-22T14:02:21.583Z |
5566120 | 5566120 | 20241121053522_6urZL | UK002X | 2024-11-22T14:01:53.729Z | 2024-11-22T14:01:53.729Z |
5566077 | 5566077 | 20241121052653_Yx27D | UK002X | 2024-11-22T14:01:45.302Z | 2024-11-22T14:01:45.302Z |
5566018 | 5566018 | 20241121051904_goR8I | UK002X | 2024-11-22T14:01:35.283Z | 2024-11-22T14:01:35.283Z |
5566002 | 5566002 | 20241121051655_klAIN | UK002X | 2024-11-22T14:01:33.889Z | 2024-11-22T14:01:33.889Z |
5565989 | 5565989 | 20241121051515_E2UrW | UK002X | 2024-11-22T14:01:32.235Z | 2024-11-22T14:01:32.235Z |
5565778 | 5565778 | 20241121044455_yTdIU | UK002X | 2024-11-22T14:00:55.619Z | 2024-11-22T14:00:55.619Z |
5565597 | 5565597 | 20241121042442_fkZOm | UK002X | 2024-11-22T14:00:23.332Z | 2024-11-22T14:00:23.332Z |
5565547 | 5565547 | 20241121042109_zmJni | UK002X | 2024-11-22T14:00:15.837Z | 2024-11-22T14:00:15.837Z |
5565538 | 5565538 | 20241121042015_iqyty | UK002X | 2024-11-22T14:00:14.811Z | 2024-11-22T14:00:14.811Z |
5565516 | 5565516 | 20241121041843_CZkw4 | UK002X | 2024-11-22T14:00:10.059Z | 2024-11-22T14:00:10.059Z |
5565400 | 5565400 | 20241120042316_cC6y6 | UK002X | 2024-11-21T14:18:47.987Z | 2024-11-22T14:21:46.472Z |
5565316 | 5565316 | 20241120041908_9Y43M | UK002X | 2024-11-21T14:18:46.485Z | 2024-11-22T14:21:45.971Z |
5565308 | 5565308 | 20241120041839_B8neb | UK002X | 2024-11-21T14:18:46.204Z | 2024-11-22T14:21:45.887Z |
5565291 | 5565291 | 20241120041701_aDnh0 | UK002X | 2024-11-21T14:18:45.550Z | 2024-11-22T14:21:45.752Z |
5565121 | 5565121 | 20241120035322_w2ULo | UK002X | 2024-11-21T14:18:31.842Z | 2024-11-22T14:21:41.833Z |
5563385 | 5563385 | 20241120012418_BX0eD | UK002X | 2024-11-21T14:16:01.911Z | 2024-11-22T14:21:14.858Z |
5562400 | 5562400 | 20241119233359_JQ5Mm | UK002X | 2024-11-21T14:14:46.663Z | 2024-11-22T14:20:57.050Z |
5562129 | 5562129 | 20241119230248_rO6Mu | UK002X | 2024-11-21T14:14:28.176Z | 2024-11-22T14:20:53.058Z |
5561763 | 5561763 | 20241119220327_U1sJJ | UK002X | 2024-11-21T14:14:02.741Z | 2024-11-22T14:20:45.732Z |
5561424 | 5561424 | 20241119203021_yvGts | UK002X | 2024-11-21T14:13:15.764Z | 2024-11-22T14:20:35.908Z |
5561404 | 5561404 | 20241119202519_jX9qw | UK002X | 2024-11-21T14:13:13.575Z | 2024-11-22T14:20:34.862Z |
5561220 | 5561220 | 20241119190815_zehxp | UK002X | 2024-11-21T14:12:40.799Z | 2024-11-22T14:20:26.764Z |
5558400 | 5558400 | 20241120060206_ojGCL | UK002X | 2024-11-21T14:03:12.169Z | 2024-11-22T14:19:21.224Z |
5558384 | 5558384 | 20241120060139_ItavS | UK002X | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5558065 | 5558065 | 20241120053426_zGDiR | UK002X | 2024-11-21T14:02:26.215Z | 2024-11-22T14:19:21.172Z |
5558021 | 5558021 | 20241120053214_Nlfdq | UK002X | 2024-11-21T14:02:20.033Z | 2024-11-22T14:19:21.165Z |
5557727 | 5557727 | 20241120050806_ucm4i | UK002X | 2024-11-21T14:01:36.105Z | 2024-11-22T14:19:21.118Z |
5557674 | 5557674 | 20241120050436_6sJAR | UK002X | 2024-11-21T14:01:28.956Z | 2024-11-22T14:19:21.109Z |
5549482 | 5549482 | 20241117050327_oidc8 | UK002X | 2024-11-18T14:11:44.315Z | 2024-11-22T14:23:21.314Z |
5549446 | 5549446 | 20241117045522_a6n5U | UK002X | 2024-11-18T14:11:37.519Z | 2024-11-22T14:23:21.063Z |
5549361 | 5549361 | 20241117043444_EYXxW | UK002X | 2024-11-18T14:11:30.446Z | 2024-11-22T14:23:20.418Z |
5549328 | 5549328 | 20241117042526_j3fVB | UK002X | 2024-11-18T14:11:28.192Z | 2024-11-22T14:23:20.257Z |
5549288 | 5549288 | 20241117041219_0eP1W | UK002X | 2024-11-18T14:11:25.353Z | 2024-11-22T14:23:20.030Z |
5549278 | 5549278 | 20241117040757_xzDyB | UK002X | 2024-11-18T14:11:24.741Z | 2024-11-22T14:23:20.017Z |
5549246 | 5549246 | 20241117040129_3yTaZ | UK002X | 2024-11-18T14:11:22.082Z | 2024-11-22T14:23:19.572Z |
5549197 | 5549197 | 20241117034344_QuVhZ | UK002X | 2024-11-18T14:11:15.913Z | 2024-11-22T14:23:19.273Z |
5549183 | 5549183 | 20241117033847_l8oyu | UK002X | 2024-11-18T14:11:14.233Z | 2024-11-22T14:23:19.178Z |
5549085 | 5549085 | 20241117030151_1g3mw | UK002X | 2024-11-18T14:10:51.715Z | 2024-11-22T14:23:17.839Z |
5549048 | 5549048 | 20241117025116_uOvU2 | UK002X | 2024-11-18T14:10:46.622Z | 2024-11-22T14:23:17.701Z |
5548670 | 5548670 | 20241117010054_B9LeE | UK002X | 2024-11-18T14:09:49.104Z | 2024-11-22T14:23:15.088Z |
5545586 | 5545586 | 20241117053232_eNrxX | UK002X | 2024-11-18T14:00:23.186Z | 2024-11-22T14:22:25.014Z |
5545529 | 5545529 | 20241117051354_2dXDF | UK002X | 2024-11-18T14:00:12.149Z | 2024-11-22T14:22:24.572Z |
5532430 | 5532430 | 20241112051923_sPlCG | UK002X | 2024-11-13T14:16:45.115Z | 2024-11-20T14:26:22.812Z |
5532375 | 5532375 | 20241112051525_phoF9 | UK002X | 2024-11-13T14:16:40.833Z | 2024-11-20T14:26:22.580Z |
5532154 | 5532154 | 20241112044402_Ih3Ow | UK002X | 2024-11-13T14:16:23.031Z | 2024-11-20T14:26:20.403Z |
5531762 | 5531762 | 20241112040756_bnqEn | UK002X | 2024-11-13T14:15:53.951Z | 2024-11-20T14:26:14.086Z |
5531186 | 5531186 | 20241112032051_ktgcI | UK002X | 2024-11-13T14:15:23.157Z | 2024-11-20T14:26:08.504Z |
5530392 | 5530392 | 20241112021541_7W3zN | UK002X | 2024-11-13T14:14:13.786Z | 2024-11-20T14:25:58.453Z |
5529846 | 5529846 | 20241112011025_ScYzq | UK002X | 2024-11-13T14:13:15.221Z | 2024-11-20T14:25:49.969Z |
5529808 | 5529808 | 20241112010555_hes3A | UK002X | 2024-11-13T14:13:12.749Z | 2024-11-20T14:25:48.477Z |
5529787 | 5529787 | 20241112010512_cEo2D | UK002X | 2024-11-13T14:13:11.379Z | 2024-11-20T14:25:48.235Z |
5529669 | 5529669 | 20241112005244_3l3qq | UK002X | 2024-11-13T14:13:05.611Z | 2024-11-20T14:25:47.340Z |
5529364 | 5529364 | 20241112000840_YL0w3 | UK002X | 2024-11-13T14:12:27.391Z | 2024-11-20T14:25:43.416Z |
5528951 | 5528951 | 20241111231147_tucJU | UK002X | 2024-11-13T14:11:47.622Z | 2024-11-20T14:25:37.764Z |
5528752 | 5528752 | 20241111223250_JG3gM | UK002X | 2024-11-13T14:11:23.243Z | 2024-11-20T14:25:34.966Z |
5523857 | 5523857 | 20241111023910_fgYx3 | UK002X | 2024-11-12T14:16:17.762Z | 2024-11-19T14:22:15.605Z |
5523782 | 5523782 | 20241111022313_pWOLK | UK002X | 2024-11-12T14:16:13.103Z | 2024-11-19T14:22:14.919Z |
5523715 | 5523715 | 20241111021046_cJaEn | UK002X | 2024-11-12T14:16:08.996Z | 2024-11-19T14:22:14.530Z |
5523705 | 5523705 | 20241111021008_UWbC3 | UK002X | 2024-11-12T14:16:08.649Z | 2024-11-19T14:22:14.489Z |
5523666 | 5523666 | 20241111020317_uBlPv | UK002X | 2024-11-12T14:16:06.733Z | 2024-11-19T14:22:14.300Z |
5523581 | 5523581 | 20241111014944_gxQtI | UK002X | 2024-11-12T14:16:01.986Z | 2024-11-19T14:22:13.501Z |
5523535 | 5523535 | 20241111014117_ZZVcs | UK002X | 2024-11-12T14:15:54.561Z | 2024-11-19T14:22:13.126Z |
5523513 | 5523513 | 20241111013850_4B3TK | UK002X | 2024-11-12T14:15:51.690Z | 2024-11-19T14:22:13.049Z |
5523465 | 5523465 | 20241111012853_ha7CN | UK002X | 2024-11-12T14:15:41.127Z | 2024-11-19T14:22:12.681Z |
5523165 | 5523165 | 20241111001901_rmxgw | UK002X | 2024-11-12T14:14:52.479Z | 2024-11-19T14:22:10.261Z |
5523163 | 5523163 | 20241111001858_7poZo | UK002X | 2024-11-12T14:14:52.401Z | 2024-11-19T14:22:10.261Z |
5522774 | 5522774 | 20241110212645_HrbQM | UK002X | 2024-11-12T14:14:14.274Z | 2024-11-19T14:22:06.217Z |
5521654 | 5521654 | 20241110175116_vGi5g | UK002X | 2024-11-12T14:11:47.297Z | 2024-11-19T14:21:53.996Z |
5497840 | 5497840 | 20241107053149_bG8gF | UK002X | 2024-11-08T14:14:26.312Z | 2024-11-15T14:25:06.419Z |
5422958 | 5422958 | 20241026230214_JhQYp | UK002X | 2024-10-30T12:22:15.866Z | 2024-11-04T14:28:50.367Z |
5410892 | 5410892 | 20241027054715_Oo4Uh | UK002X | 2024-10-29T12:18:09.425Z | 2024-11-04T14:29:05.992Z |
5409907 | 5409907 | 20241027044129_WoBRi | UK002X | 2024-10-29T12:17:43.926Z | 2024-11-04T14:29:02.919Z |
5409787 | 5409787 | 20241027043606_kmwok | UK002X | 2024-10-29T12:17:41.045Z | 2024-11-04T14:29:02.641Z |
5409763 | 5409763 | 20241027043450_ehWo1 | UK002X | 2024-10-29T12:17:40.498Z | 2024-11-04T14:29:02.623Z |
5409584 | 5409584 | 20241027042722_QJHXP | UK002X | 2024-10-29T12:17:31.883Z | 2024-11-04T14:29:01.968Z |
5409352 | 5409352 | 20241027041211_cDKX0 | UK002X | 2024-10-29T12:17:17.253Z | 2024-11-04T14:29:01.595Z |
5409038 | 5409038 | 20241027035620_lO7ic | UK002X | 2024-10-29T12:17:02.522Z | 2024-11-04T14:29:00.975Z |
5408458 | 5408458 | 20241027032801_7qn1R | UK002X | 2024-10-29T12:16:31.455Z | 2024-11-04T14:28:59.542Z |
5408373 | 5408373 | 20241027032416_t0QgP | UK002X | 2024-10-29T12:16:25.291Z | 2024-11-04T14:28:59.295Z |
5407929 | 5407929 | 20241027025823_jYT3w | UK002X | 2024-10-29T12:15:54.115Z | 2024-11-04T14:28:58.511Z |
5407857 | 5407857 | 20241027025540_jtxy4 | UK002X | 2024-10-29T12:15:49.326Z | 2024-11-04T14:28:58.248Z |
5407718 | 5407718 | 20241027024909_5KLQQ | UK002X | 2024-10-29T12:15:35.742Z | 2024-11-04T14:28:58.076Z |
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);