participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,486 rows where station_code = "UK008Z" 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 |
---|---|---|---|---|---|
5454075 | 5454075 | 20241031033955_aVdUJ | UK008Z | 2024-11-02T12:22:50.161Z | 2024-11-08T14:23:20.305Z |
5454031 | 5454031 | 20241031033303_zTspj | UK008Z | 2024-11-02T12:22:48.965Z | 2024-11-08T14:23:20.055Z |
5451681 | 5451681 | 20241101004510_NJfFw | UK008Z | 2024-11-02T12:17:49.663Z | 2024-11-09T14:24:24.970Z |
5451070 | 5451070 | 20241031223233_Xq4j0 | UK008Z | 2024-11-02T12:16:33.799Z | 2024-11-09T14:24:21.352Z |
5450758 | 5450758 | 20241031205031_gRTLz | UK008Z | 2024-11-02T12:15:50.908Z | 2024-11-09T14:24:17.838Z |
5450033 | 5450033 | 20241031173926_dGBpS | UK008Z | 2024-11-02T12:14:10.923Z | 2024-11-09T14:24:13.370Z |
5422992 | 5422992 | 20241027014118_O5AmZ | UK008Z | 2024-10-30T12:22:39.753Z | 2024-11-04T14:28:55.773Z |
5418773 | 5418773 | 20241027215459_4uyx4 | UK008Z | 2024-10-30T12:16:09.346Z | 2024-11-05T14:27:11.144Z |
5418759 | 5418759 | 20241027215303_h2J2B | UK008Z | 2024-10-30T12:16:07.922Z | 2024-11-05T14:27:11.103Z |
5410143 | 5410143 | 20241027045526_BQ6Hg | UK008Z | 2024-10-29T12:17:48.871Z | 2024-11-04T14:29:03.885Z |
5410135 | 5410135 | 20241027045515_aAX2y | UK008Z | 2024-10-29T12:17:48.559Z | 2024-11-04T14:29:03.870Z |
5409470 | 5409470 | 20241027041941_r3FCy | UK008Z | 2024-10-29T12:17:25.250Z | 2024-11-04T14:29:01.835Z |
5408444 | 5408444 | 20241027032714_qyRNA | UK008Z | 2024-10-29T12:16:29.653Z | 2024-11-04T14:28:59.408Z |
5408437 | 5408437 | 20241027032703_wAzT2 | UK008Z | 2024-10-29T12:16:29.472Z | 2024-11-04T14:28:59.405Z |
5408225 | 5408225 | 20241027031714_m04iw | UK008Z | 2024-10-29T12:16:17.952Z | 2024-11-04T14:28:59.010Z |
5407448 | 5407448 | 20241027023705_f6jLH | UK008Z | 2024-10-29T12:15:24.945Z | 2024-11-04T14:28:57.582Z |
5407225 | 5407225 | 20241027022652_ycZun | UK008Z | 2024-10-29T12:15:17.835Z | 2024-11-04T14:28:57.252Z |
5407147 | 5407147 | 20241027022401_ZXtfd | UK008Z | 2024-10-29T12:15:14.780Z | 2024-11-04T14:28:57.106Z |
5407090 | 5407090 | 20241027022148_6zXmV | UK008Z | 2024-10-29T12:15:12.001Z | 2024-11-04T14:28:56.842Z |
5406845 | 5406845 | 20241027020329_OCJ0I | UK008Z | 2024-10-29T12:14:49.454Z | 2024-11-04T14:28:56.509Z |
5406540 | 5406540 | 20241027014252_swiOo | UK008Z | 2024-10-29T12:14:18.548Z | 2024-11-04T14:28:55.842Z |
5405789 | 5405789 | 20241027005815_YoI2P | UK008Z | 2024-10-29T12:13:17.657Z | 2024-11-04T14:28:54.245Z |
5405185 | 5405185 | 20241027002058_8IYXN | UK008Z | 2024-10-29T12:12:39.932Z | 2024-11-04T14:28:52.762Z |
5404830 | 5404830 | 20241026235503_CWsjM | UK008Z | 2024-10-29T12:12:00.240Z | 2024-11-04T14:28:52.170Z |
5404527 | 5404527 | 20241026233423_43tt7 | UK008Z | 2024-10-29T12:11:40.873Z | 2024-11-04T14:28:51.294Z |
5403951 | 5403951 | 20241026224815_POq5j | UK008Z | 2024-10-29T12:10:36.195Z | 2024-11-04T14:28:50.071Z |
5403866 | 5403866 | 20241026224015_yrRpu | UK008Z | 2024-10-29T12:10:22.823Z | 2024-11-04T14:28:49.894Z |
5403150 | 5403150 | 20241026212355_WraZH | UK008Z | 2024-10-29T12:09:06.268Z | 2024-11-04T14:28:47.868Z |
5399502 | 5399502 | 20241026042902_PL2t4 | UK008Z | 2024-10-28T12:20:01.173Z | 2024-11-03T14:27:39.878Z |
5395478 | 5395478 | 20241025224544_spQGa | UK008Z | 2024-10-28T12:16:18.556Z | 2024-11-03T14:27:25.615Z |
5394852 | 5394852 | 20241025213424_LgrI0 | UK008Z | 2024-10-28T12:15:32.548Z | 2024-11-03T14:27:22.902Z |
5394605 | 5394605 | 20241025205638_ARALt | UK008Z | 2024-10-28T12:15:04.083Z | 2024-11-03T14:27:21.858Z |
5385514 | 5385514 | 20241024225552_yzjFF | UK008Z | 2024-10-27T12:19:00.872Z | 2024-11-02T12:28:29.890Z |
5385454 | 5385454 | 20241024224736_qp2ua | UK008Z | 2024-10-27T12:18:56.994Z | 2024-11-02T12:28:29.846Z |
5385140 | 5385140 | 20241024215630_6xG5Q | UK008Z | 2024-10-27T12:18:28.271Z | 2024-11-02T12:28:29.206Z |
5385076 | 5385076 | 20241024214738_4LkN2 | UK008Z | 2024-10-27T12:18:19.922Z | 2024-11-02T12:28:29.037Z |
5383507 | 5383507 | 20241024182659_E8IQ5 | UK008Z | 2024-10-27T12:15:37.742Z | 2024-11-02T12:28:25.687Z |
5377254 | 5377254 | 20241024044136_Q1f4S | UK008Z | 2024-10-26T12:22:32.092Z | 2024-11-01T12:27:02.338Z |
5377133 | 5377133 | 20241024043446_836up | UK008Z | 2024-10-26T12:22:27.830Z | 2024-11-01T12:27:02.206Z |
5376860 | 5376860 | 20241024041943_Opfto | UK008Z | 2024-10-26T12:22:15.016Z | 2024-11-01T12:27:01.900Z |
5376604 | 5376604 | 20241024040413_7iJTp | UK008Z | 2024-10-26T12:22:06.038Z | 2024-11-01T12:27:01.615Z |
5376478 | 5376478 | 20241024035710_r837A | UK008Z | 2024-10-26T12:22:02.893Z | 2024-11-01T12:27:01.567Z |
5376391 | 5376391 | 20241024035317_RM1us | UK008Z | 2024-10-26T12:22:00.248Z | 2024-11-01T12:27:01.521Z |
5375836 | 5375836 | 20241024033227_oXfbx | UK008Z | 2024-10-26T12:21:41.470Z | 2024-11-01T12:27:01.217Z |
5375593 | 5375593 | 20241024032058_rcN78 | UK008Z | 2024-10-26T12:21:32.575Z | 2024-11-01T12:27:01.102Z |
5375094 | 5375094 | 20241024025719_AhrcU | UK008Z | 2024-10-26T12:21:12.682Z | 2024-11-01T12:27:00.285Z |
5374969 | 5374969 | 20241024025113_J1y2I | UK008Z | 2024-10-26T12:21:08.538Z | 2024-11-01T12:27:00.073Z |
5373296 | 5373296 | 20241024013211_1eNlx | UK008Z | 2024-10-26T12:20:04.636Z | 2024-11-01T12:26:58.213Z |
5373200 | 5373200 | 20241024012739_mDsVN | UK008Z | 2024-10-26T12:20:01.690Z | 2024-11-01T12:26:58.163Z |
5372336 | 5372336 | 20241024004442_YrCCd | UK008Z | 2024-10-26T12:19:20.999Z | 2024-11-01T12:26:57.406Z |
5372149 | 5372149 | 20241024003525_8q2qL | UK008Z | 2024-10-26T12:19:11.368Z | 2024-11-01T12:26:57.162Z |
5371906 | 5371906 | 20241024002232_UR2dy | UK008Z | 2024-10-26T12:18:56.339Z | 2024-11-01T12:26:56.986Z |
5366203 | 5366203 | 20241024000917_JrCzY | UK008Z | 2024-10-25T12:18:19.175Z | 2024-11-01T12:26:56.794Z |
5365993 | 5365993 | 20241024000022_VU7dS | UK008Z | 2024-10-25T12:18:13.833Z | 2024-11-01T12:26:56.522Z |
5365757 | 5365757 | 20241023234741_SnRVM | UK008Z | 2024-10-25T12:18:07.221Z | 2024-11-01T12:26:56.398Z |
5365657 | 5365657 | 20241023234152_GVFt3 | UK008Z | 2024-10-25T12:18:04.078Z | 2024-11-01T12:26:56.329Z |
5365337 | 5365337 | 20241023232625_3AMLB | UK008Z | 2024-10-25T12:17:56.078Z | 2024-11-01T12:26:56.057Z |
5365312 | 5365312 | 20241023232537_QJSwT | UK008Z | 2024-10-25T12:17:55.313Z | 2024-11-01T12:26:56.050Z |
5365247 | 5365247 | 20241023232245_RqfRz | UK008Z | 2024-10-25T12:17:52.393Z | 2024-11-01T12:26:55.993Z |
5364513 | 5364513 | 20241023223519_sEjUB | UK008Z | 2024-10-25T12:17:23.346Z | 2024-11-01T12:26:55.165Z |
5364502 | 5364502 | 20241023223339_tsCws | UK008Z | 2024-10-25T12:17:22.986Z | 2024-11-01T12:26:55.162Z |
5364207 | 5364207 | 20241023221344_2P3tk | UK008Z | 2024-10-25T12:17:12.327Z | 2024-11-01T12:26:54.605Z |
5364161 | 5364161 | 20241023221104_En1jz | UK008Z | 2024-10-25T12:17:10.815Z | 2024-11-01T12:26:54.568Z |
5364138 | 5364138 | 20241023220920_BZgU5 | UK008Z | 2024-10-25T12:17:10.354Z | 2024-11-01T12:26:54.559Z |
5364029 | 5364029 | 20241023220344_jpeO8 | UK008Z | 2024-10-25T12:17:06.454Z | 2024-11-01T12:26:54.347Z |
5363847 | 5363847 | 20241023215134_AL47e | UK008Z | 2024-10-25T12:16:54.209Z | 2024-11-01T12:26:53.894Z |
5363720 | 5363720 | 20241023213832_xJZe1 | UK008Z | 2024-10-25T12:16:37.865Z | 2024-11-01T12:26:53.584Z |
5363714 | 5363714 | 20241023213706_t26pt | UK008Z | 2024-10-25T12:16:37.409Z | 2024-11-01T12:26:53.557Z |
5362948 | 5362948 | 20241023201319_F6VO5 | UK008Z | 2024-10-25T12:15:19.060Z | 2024-11-01T12:26:52.682Z |
5362482 | 5362482 | 20241023193607_82Phn | UK008Z | 2024-10-25T12:14:33.988Z | 2024-11-01T12:26:51.780Z |
5362097 | 5362097 | 20241023190715_EgRnH | UK008Z | 2024-10-25T12:13:51.519Z | 2024-11-01T12:26:50.991Z |
5362077 | 5362077 | 20241023190551_w53iN | UK008Z | 2024-10-25T12:13:49.682Z | 2024-11-01T12:26:50.967Z |
5350923 | 5350923 | 20241022224147_WQs6A | UK008Z | 2024-10-24T12:16:49.801Z | 2024-10-31T12:29:59.042Z |
5350653 | 5350653 | 20241022221259_Anuia | UK008Z | 2024-10-24T12:16:11.455Z | 2024-10-31T12:29:58.618Z |
5350555 | 5350555 | 20241022220321_5iGuj | UK008Z | 2024-10-24T12:15:56.144Z | 2024-10-31T12:29:58.429Z |
5350401 | 5350401 | 20241022214217_Aixvu | UK008Z | 2024-10-24T12:15:41.706Z | 2024-10-31T12:29:58.116Z |
5350093 | 5350093 | 20241022211054_nN0mM | UK008Z | 2024-10-24T12:15:21.603Z | 2024-10-31T12:29:57.300Z |
5349914 | 5349914 | 20241022204853_8LL7l | UK008Z | 2024-10-24T12:14:48.113Z | 2024-10-31T12:29:56.912Z |
5349467 | 5349467 | 20241022200256_CduXL | UK008Z | 2024-10-24T12:13:43.616Z | 2024-10-31T12:29:55.523Z |
5348549 | 5348549 | 20241022182835_ueVnm | UK008Z | 2024-10-24T12:11:38.378Z | 2024-10-31T12:29:52.889Z |
5348450 | 5348450 | 20241022182032_YRWj9 | UK008Z | 2024-10-24T12:11:26.685Z | 2024-10-31T12:29:52.596Z |
5345128 | 5345128 | 20241022051405_RBZAe | UK008Z | 2024-10-23T12:19:07.047Z | 2024-10-30T12:26:52.216Z |
5344973 | 5344973 | 20241022050420_Wumjm | UK008Z | 2024-10-23T12:19:00.814Z | 2024-10-30T12:26:52.048Z |
5344945 | 5344945 | 20241022050044_ue0qx | UK008Z | 2024-10-23T12:18:58.156Z | 2024-10-30T12:26:52.004Z |
5344853 | 5344853 | 20241022045159_d7JFw | UK008Z | 2024-10-23T12:18:53.908Z | 2024-10-30T12:26:51.880Z |
5344758 | 5344758 | 20241022044423_m4zJk | UK008Z | 2024-10-23T12:18:49.969Z | 2024-10-30T12:26:51.638Z |
5344533 | 5344533 | 20241022042939_CIHxY | UK008Z | 2024-10-23T12:18:40.742Z | 2024-10-30T12:26:51.348Z |
5344405 | 5344405 | 20241022041932_BrMsu | UK008Z | 2024-10-23T12:18:35.822Z | 2024-10-30T12:26:51.222Z |
5344380 | 5344380 | 20241022041754_gvDNn | UK008Z | 2024-10-23T12:18:33.939Z | 2024-10-30T12:26:51.205Z |
5343960 | 5343960 | 20241022035808_77Plz | UK008Z | 2024-10-23T12:18:15.999Z | 2024-10-30T12:26:50.817Z |
5343453 | 5343453 | 20241022033001_8fQqP | UK008Z | 2024-10-23T12:17:46.917Z | 2024-10-30T12:26:50.039Z |
5343445 | 5343445 | 20241022032926_0e0ZQ | UK008Z | 2024-10-23T12:17:46.585Z | 2024-10-30T12:26:50.029Z |
5343405 | 5343405 | 20241022032743_4hNa3 | UK008Z | 2024-10-23T12:17:45.762Z | 2024-10-30T12:26:50.004Z |
5343313 | 5343313 | 20241022032138_QUjPf | UK008Z | 2024-10-23T12:17:42.195Z | 2024-10-30T12:26:49.910Z |
5342889 | 5342889 | 20241022025204_kb8g8 | UK008Z | 2024-10-23T12:17:27.840Z | 2024-10-30T12:26:49.032Z |
5342812 | 5342812 | 20241022024659_ghZX8 | UK008Z | 2024-10-23T12:17:24.475Z | 2024-10-30T12:26:48.923Z |
5342754 | 5342754 | 20241022024335_rjgwK | UK008Z | 2024-10-23T12:17:20.312Z | 2024-10-30T12:26:48.891Z |
5342613 | 5342613 | 20241022023621_1RpPK | UK008Z | 2024-10-23T12:17:08.093Z | 2024-10-30T12:26:48.712Z |
5342589 | 5342589 | 20241022023521_3XjzQ | UK008Z | 2024-10-23T12:17:06.132Z | 2024-10-30T12:26:48.689Z |
5342575 | 5342575 | 20241022023429_4Qq3l | UK008Z | 2024-10-23T12:17:05.033Z | 2024-10-30T12:26:48.683Z |
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);