participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,828 rows where station_code = "UK001S" 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 |
---|---|---|---|---|---|
5600851 | 5600851 | 20241125061741_GANHP | UK001S | 2024-11-26T14:03:31.086Z | 2024-11-26T14:03:31.086Z |
5600824 | 5600824 | 20241125061341_zaelJ | UK001S | 2024-11-26T14:03:26.837Z | 2024-11-26T14:03:26.837Z |
5600779 | 5600779 | 20241125060624_pdfyp | UK001S | 2024-11-26T14:03:21.020Z | 2024-11-26T14:03:21.020Z |
5600708 | 5600708 | 20241125055238_CIpfQ | UK001S | 2024-11-26T14:03:00.860Z | 2024-11-26T14:03:00.860Z |
5600696 | 5600696 | 20241125055028_M5uH2 | UK001S | 2024-11-26T14:02:58.877Z | 2024-11-26T14:02:58.877Z |
5600492 | 5600492 | 20241125050313_y7ya1 | UK001S | 2024-11-26T14:02:07.685Z | 2024-11-26T14:02:07.685Z |
5589920 | 5589920 | 20241122175509_Zeptn | UK001S | 2024-11-24T14:17:51.858Z | 2024-11-26T14:23:00.187Z |
5573251 | 5573251 | 20241121041408_HCDUi | UK001S | 2024-11-22T14:19:18.354Z | 2024-11-26T14:27:02.073Z |
5573247 | 5573247 | 20241121041330_wq2AX | UK001S | 2024-11-22T14:19:18.013Z | 2024-11-26T14:27:01.800Z |
5573095 | 5573095 | 20241121035059_30wDC | UK001S | 2024-11-22T14:19:09.648Z | 2024-11-26T14:26:59.917Z |
5571947 | 5571947 | 20241121011002_iB4MB | UK001S | 2024-11-22T14:17:48.944Z | 2024-11-26T14:26:42.719Z |
5570820 | 5570820 | 20241120210719_C65VE | UK001S | 2024-11-22T14:16:07.267Z | 2024-11-26T14:26:30.382Z |
5570633 | 5570633 | 20241120203251_HWYlT | UK001S | 2024-11-22T14:15:57.632Z | 2024-11-26T14:26:26.320Z |
5570208 | 5570208 | 20241120190318_MpLAb | UK001S | 2024-11-22T14:15:00.809Z | 2024-11-26T14:26:15.215Z |
5569881 | 5569881 | 20241120175338_khRPy | UK001S | 2024-11-22T14:14:29.587Z | 2024-11-26T14:26:11.479Z |
5562327 | 5562327 | 20241119232215_yldBj | UK001S | 2024-11-21T14:14:42.404Z | 2024-11-26T14:27:36.457Z |
5562248 | 5562248 | 20241119231605_1Ydoh | UK001S | 2024-11-21T14:14:36.362Z | 2024-11-26T14:27:36.178Z |
5561969 | 5561969 | 20241119224031_WCmy2 | UK001S | 2024-11-21T14:14:17.599Z | 2024-11-26T14:27:34.307Z |
5561916 | 5561916 | 20241119222847_AIU57 | UK001S | 2024-11-21T14:14:13.752Z | 2024-11-26T14:27:33.675Z |
5561514 | 5561514 | 20241119205123_zBptH | UK001S | 2024-11-21T14:13:23.591Z | 2024-11-26T14:27:29.662Z |
5561087 | 5561087 | 20241119180239_cM5LX | UK001S | 2024-11-21T14:12:21.506Z | 2024-11-26T14:27:23.790Z |
5537994 | 5537994 | 20241113015012_Qd6KF | UK001S | 2024-11-14T14:12:41.969Z | 2024-11-21T14:26:18.356Z |
5433572 | 5433572 | 20241029202504_hmqx6 | UK001S | 2024-10-31T12:22:22.416Z | 2024-11-07T14:26:40.215Z |
5433420 | 5433420 | 20241029195032_XUZ1b | UK001S | 2024-10-31T12:22:14.159Z | 2024-11-07T14:26:39.315Z |
5433391 | 5433391 | 20241029193615_WvQGF | UK001S | 2024-10-31T12:22:12.044Z | 2024-11-07T14:26:38.919Z |
5421310 | 5421310 | 20241028054451_bXJU0 | UK001S | 2024-10-30T12:19:50.154Z | 2024-11-05T14:27:18.172Z |
5410335 | 5410335 | 20241027050707_1K6eG | UK001S | 2024-10-29T12:17:53.420Z | 2024-11-04T14:29:04.346Z |
5410290 | 5410290 | 20241027050526_0Wr2Q | UK001S | 2024-10-29T12:17:52.607Z | 2024-11-04T14:29:04.314Z |
5410221 | 5410221 | 20241027050029_2hblT | UK001S | 2024-10-29T12:17:50.921Z | 2024-11-04T14:29:04.202Z |
5409841 | 5409841 | 20241027043820_W8Geq | UK001S | 2024-10-29T12:17:42.362Z | 2024-11-04T14:29:02.816Z |
5409625 | 5409625 | 20241027042827_h9c2W | UK001S | 2024-10-29T12:17:34.168Z | 2024-11-04T14:29:02.023Z |
5409473 | 5409473 | 20241027042008_j3uvR | UK001S | 2024-10-29T12:17:25.662Z | 2024-11-04T14:29:01.853Z |
5409277 | 5409277 | 20241027040846_rxzqP | UK001S | 2024-10-29T12:17:14.575Z | 2024-11-04T14:29:01.447Z |
5408985 | 5408985 | 20241027035230_OoKjm | UK001S | 2024-10-29T12:16:59.827Z | 2024-11-04T14:29:00.898Z |
5408917 | 5408917 | 20241027034956_e8IYl | UK001S | 2024-10-29T12:16:57.132Z | 2024-11-04T14:29:00.824Z |
5408636 | 5408636 | 20241027033405_Yu5Dt | UK001S | 2024-10-29T12:16:41.913Z | 2024-11-04T14:28:59.711Z |
5408589 | 5408589 | 20241027033120_FgEod | UK001S | 2024-10-29T12:16:38.400Z | 2024-11-04T14:28:59.668Z |
5408551 | 5408551 | 20241027033015_JimKY | UK001S | 2024-10-29T12:16:35.922Z | 2024-11-04T14:28:59.615Z |
5408527 | 5408527 | 20241027032901_2BMhE | UK001S | 2024-10-29T12:16:34.560Z | 2024-11-04T14:28:59.605Z |
5408520 | 5408520 | 20241027032901_tVlBs | UK001S | 2024-10-29T12:16:34.284Z | 2024-11-04T14:28:59.593Z |
5408497 | 5408497 | 20241027032816_MnvOW | UK001S | 2024-10-29T12:16:33.266Z | 2024-11-04T14:28:59.566Z |
5407985 | 5407985 | 20241027030058_62XJv | UK001S | 2024-10-29T12:15:57.179Z | 2024-11-04T14:28:58.552Z |
5407979 | 5407979 | 20241027030058_7Ut9V | UK001S | 2024-10-29T12:15:56.966Z | 2024-11-04T14:28:58.551Z |
5407880 | 5407880 | 20241027025623_Pyuft | UK001S | 2024-10-29T12:15:50.494Z | 2024-11-04T14:28:58.289Z |
5407627 | 5407627 | 20241027024517_RVdVd | UK001S | 2024-10-29T12:15:31.926Z | 2024-11-04T14:28:57.954Z |
5407304 | 5407304 | 20241027023112_vVxL4 | UK001S | 2024-10-29T12:15:20.463Z | 2024-11-04T14:28:57.326Z |
5407172 | 5407172 | 20241027022457_RalF2 | UK001S | 2024-10-29T12:15:15.865Z | 2024-11-04T14:28:57.168Z |
5407094 | 5407094 | 20241027022218_4q33v | UK001S | 2024-10-29T12:15:12.227Z | 2024-11-04T14:28:56.843Z |
5406974 | 5406974 | 20241027021455_QR9Gj | UK001S | 2024-10-29T12:15:03.683Z | 2024-11-04T14:28:56.741Z |
5406779 | 5406779 | 20241027015943_0Y222 | UK001S | 2024-10-29T12:14:41.859Z | 2024-11-04T14:28:56.379Z |
5406758 | 5406758 | 20241027015842_R53Zk | UK001S | 2024-10-29T12:14:39.731Z | 2024-11-04T14:28:56.361Z |
5402760 | 5402760 | 20241026202223_wo2Vn | UK001S | 2024-10-29T12:08:06.522Z | 2024-11-04T14:28:46.477Z |
5402628 | 5402628 | 20241026200646_rsevq | UK001S | 2024-10-29T12:07:50.182Z | 2024-11-04T14:28:45.813Z |
5375646 | 5375646 | 20241024032257_eQfVm | UK001S | 2024-10-26T12:21:34.694Z | 2024-11-01T12:27:01.146Z |
5374530 | 5374530 | 20241024023211_yRHxo | UK001S | 2024-10-26T12:20:52.438Z | 2024-11-01T12:26:59.459Z |
5366366 | 5366366 | 20241024001750_NUMLr | UK001S | 2024-10-25T12:18:24.416Z | 2024-11-01T12:26:56.910Z |
5366358 | 5366358 | 20241024001707_X9aKI | UK001S | 2024-10-25T12:18:24.016Z | 2024-11-01T12:26:56.907Z |
5366218 | 5366218 | 20241024000929_Rmuhs | UK001S | 2024-10-25T12:18:19.369Z | 2024-11-01T12:26:56.799Z |
5366156 | 5366156 | 20241024000740_waCpp | UK001S | 2024-10-25T12:18:18.203Z | 2024-11-01T12:26:56.775Z |
5365968 | 5365968 | 20241023235944_NSQuX | UK001S | 2024-10-25T12:18:12.703Z | 2024-11-01T12:26:56.507Z |
5365831 | 5365831 | 20241023235138_hu64H | UK001S | 2024-10-25T12:18:08.456Z | 2024-11-01T12:26:56.445Z |
5365738 | 5365738 | 20241023234640_HGCci | UK001S | 2024-10-25T12:18:06.547Z | 2024-11-01T12:26:56.382Z |
5365281 | 5365281 | 20241023232429_YFEdx | UK001S | 2024-10-25T12:17:53.878Z | 2024-11-01T12:26:56.016Z |
5365123 | 5365123 | 20241023231600_Y4QEc | UK001S | 2024-10-25T12:17:46.926Z | 2024-11-01T12:26:55.886Z |
5364536 | 5364536 | 20241023223631_y30Tg | UK001S | 2024-10-25T12:17:24.093Z | 2024-11-01T12:26:55.181Z |
5364493 | 5364493 | 20241023223332_oDDfN | UK001S | 2024-10-25T12:17:22.837Z | 2024-11-01T12:26:55.156Z |
5364060 | 5364060 | 20241023220446_4dTBn | UK001S | 2024-10-25T12:17:07.480Z | 2024-11-01T12:26:54.358Z |
5363781 | 5363781 | 20241023214359_9A0tL | UK001S | 2024-10-25T12:16:45.015Z | 2024-11-01T12:26:53.621Z |
5341543 | 5341543 | 20241022013953_vMfXi | UK001S | 2024-10-23T12:15:57.685Z | 2024-10-30T12:26:47.199Z |
5341242 | 5341242 | 20241022012127_lKfFH | UK001S | 2024-10-23T12:15:32.670Z | 2024-10-30T12:26:46.690Z |
5340899 | 5340899 | 20241022005758_QH08c | UK001S | 2024-10-23T12:15:02.457Z | 2024-10-30T12:26:46.348Z |
5340873 | 5340873 | 20241022005649_qiIGj | UK001S | 2024-10-23T12:15:00.036Z | 2024-10-30T12:26:46.339Z |
5338455 | 5338455 | 20241021193839_lsT78 | UK001S | 2024-10-23T12:11:07.513Z | 2024-10-30T12:26:42.387Z |
5338387 | 5338387 | 20241021192716_LMoZ9 | UK001S | 2024-10-23T12:10:52.903Z | 2024-10-30T12:26:42.211Z |
5338365 | 5338365 | 20241021192259_h9d3d | UK001S | 2024-10-23T12:10:50.604Z | 2024-10-30T12:26:42.192Z |
5338133 | 5338133 | 20241021184355_JPQUU | UK001S | 2024-10-23T12:10:21.609Z | 2024-10-30T12:26:41.783Z |
5338054 | 5338054 | 20241021182746_I8SOs | UK001S | 2024-10-23T12:10:00.578Z | 2024-10-30T12:26:41.417Z |
5333108 | 5333108 | 20241020233850_BpsZn | UK001S | 2024-10-22T12:14:41.940Z | 2024-10-29T12:26:34.065Z |
5319699 | 5319699 | 20241017200852_oANdV | UK001S | 2024-10-19T12:03:33.063Z | 2024-10-26T12:27:52.910Z |
5319664 | 5319664 | 20241017194312_RU3Rs | UK001S | 2024-10-19T12:03:30.220Z | 2024-10-26T12:27:52.819Z |
5318506 | 5318506 | 20241017034024_6ftCB | UK001S | 2024-10-18T12:03:54.747Z | 2024-10-25T12:24:36.068Z |
5318474 | 5318474 | 20241017033408_KGaKP | UK001S | 2024-10-18T12:03:51.489Z | 2024-10-25T12:24:35.752Z |
5318439 | 5318439 | 20241017032606_F4Jti | UK001S | 2024-10-18T12:03:48.333Z | 2024-10-25T12:24:35.531Z |
5303374 | 5303374 | 20241013025521_0C3K3 | UK001S | 2024-10-14T12:17:22.942Z | 2024-10-21T12:24:17.708Z |
5301546 | 5301546 | 20241012234218_oSzDR | UK001S | 2024-10-14T12:15:30.767Z | 2024-10-21T12:23:59.011Z |
5300680 | 5300680 | 20241012212353_EmtQZ | UK001S | 2024-10-14T12:14:22.422Z | 2024-10-21T12:23:51.734Z |
5299770 | 5299770 | 20241012192951_3Zk58 | UK001S | 2024-10-14T12:13:08.447Z | 2024-10-21T12:23:43.746Z |
5299748 | 5299748 | 20241012192751_3zd30 | UK001S | 2024-10-14T12:13:06.960Z | 2024-10-21T12:23:43.670Z |
5294947 | 5294947 | 20241013051115_bS02h | UK001S | 2024-10-14T12:00:39.780Z | 2024-10-22T12:24:06.816Z |
5294825 | 5294825 | 20241013045905_ZoNGb | UK001S | 2024-10-14T12:00:25.219Z | 2024-10-22T12:24:05.889Z |
5294735 | 5294735 | 20241013044340_yLDNS | UK001S | 2024-10-14T12:00:15.545Z | 2024-10-22T12:24:04.889Z |
5291594 | 5291594 | 20241011212752_2VBYl | UK001S | 2024-10-13T12:14:50.832Z | 2024-10-20T12:24:33.804Z |
5291473 | 5291473 | 20241011210240_3Qjxj | UK001S | 2024-10-13T12:14:38.021Z | 2024-10-20T12:24:31.847Z |
5291442 | 5291442 | 20241011205920_KXpDK | UK001S | 2024-10-13T12:14:34.849Z | 2024-10-20T12:24:31.592Z |
5291339 | 5291339 | 20241011203728_xzVyw | UK001S | 2024-10-13T12:14:18.670Z | 2024-10-20T12:24:29.361Z |
5290892 | 5290892 | 20241011191512_uufnf | UK001S | 2024-10-13T12:13:35.292Z | 2024-10-20T12:24:22.161Z |
5283010 | 5283010 | 20241011002927_RgVdS | UK001S | 2024-10-12T12:16:18.112Z | 2024-10-19T12:27:48.138Z |
5282915 | 5282915 | 20241011000915_W2ZEw | UK001S | 2024-10-12T12:16:11.753Z | 2024-10-19T12:27:47.508Z |
5282877 | 5282877 | 20241011000230_B0XIF | UK001S | 2024-10-12T12:16:09.779Z | 2024-10-19T12:27:47.183Z |
5282376 | 5282376 | 20241010212906_XaBD2 | UK001S | 2024-10-12T12:15:30.285Z | 2024-10-19T12:27:43.580Z |
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);