participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,754 rows where station_code = "UK0070" 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 |
---|---|---|---|---|---|
5572989 | 5572989 | 20241121033537_sKrDj | UK0070 | 2024-11-22T14:19:02.691Z | 2024-11-22T14:19:22.428Z |
5572971 | 5572971 | 20241121033216_CyJMO | UK0070 | 2024-11-22T14:19:01.682Z | 2024-11-22T14:19:22.424Z |
5572870 | 5572870 | 20241121031826_VVY21 | UK0070 | 2024-11-22T14:18:55.224Z | 2024-11-22T14:19:22.405Z |
5572862 | 5572862 | 20241121031756_LYYPu | UK0070 | 2024-11-22T14:18:53.931Z | 2024-11-22T14:19:22.404Z |
5572641 | 5572641 | 20241121025248_80YBB | UK0070 | 2024-11-22T14:18:41.087Z | 2024-11-22T14:19:22.367Z |
5572617 | 5572617 | 20241121025019_nmQbI | UK0070 | 2024-11-22T14:18:39.773Z | 2024-11-22T14:19:22.363Z |
5572554 | 5572554 | 20241121023624_V7bdI | UK0070 | 2024-11-22T14:18:35.543Z | 2024-11-22T14:19:22.350Z |
5572348 | 5572348 | 20241121021252_WAQHR | UK0070 | 2024-11-22T14:18:18.279Z | 2024-11-22T14:19:22.313Z |
5572203 | 5572203 | 20241121014654_x2ne8 | UK0070 | 2024-11-22T14:18:04.710Z | 2024-11-22T14:19:22.279Z |
5572160 | 5572160 | 20241121014240_MuSJG | UK0070 | 2024-11-22T14:18:02.289Z | 2024-11-22T14:19:22.271Z |
5572046 | 5572046 | 20241121012531_HnRN3 | UK0070 | 2024-11-22T14:17:54.583Z | 2024-11-22T14:19:22.249Z |
5572018 | 5572018 | 20241121012102_n2T8O | UK0070 | 2024-11-22T14:17:52.967Z | 2024-11-22T14:19:22.243Z |
5571975 | 5571975 | 20241121011616_nH53Z | UK0070 | 2024-11-22T14:17:50.592Z | 2024-11-22T14:19:22.235Z |
5571949 | 5571949 | 20241121011002_iB4MB | UK0070 | 2024-11-22T14:17:48.944Z | 2024-11-22T14:19:22.230Z |
5571713 | 5571713 | 20241121003604_AMwed | UK0070 | 2024-11-22T14:17:35.817Z | 2024-11-22T14:19:22.180Z |
5571552 | 5571552 | 20241121000603_Q4WR8 | UK0070 | 2024-11-22T14:17:16.623Z | 2024-11-22T14:19:22.147Z |
5571409 | 5571409 | 20241120234015_QA76F | UK0070 | 2024-11-22T14:17:03.253Z | 2024-11-22T14:19:22.119Z |
5571381 | 5571381 | 20241120233514_mpndf | UK0070 | 2024-11-22T14:16:59.832Z | 2024-11-22T14:19:22.114Z |
5571337 | 5571337 | 20241120232450_7Fbu8 | UK0070 | 2024-11-22T14:16:51.874Z | 2024-11-22T14:19:22.104Z |
5571244 | 5571244 | 20241120230733_ogDn1 | UK0070 | 2024-11-22T14:16:43.205Z | 2024-11-22T14:19:22.077Z |
5571224 | 5571224 | 20241120230316_Htitr | UK0070 | 2024-11-22T14:16:39.894Z | 2024-11-22T14:19:22.072Z |
5571171 | 5571171 | 20241120224057_F2q6X | UK0070 | 2024-11-22T14:16:33.862Z | 2024-11-22T14:19:22.056Z |
5570860 | 5570860 | 20241120211906_xO23o | UK0070 | 2024-11-22T14:16:09.669Z | 2024-11-22T14:19:21.995Z |
5570495 | 5570495 | 20241120194903_Ktu3P | UK0070 | 2024-11-22T14:15:37.081Z | 2024-11-22T14:19:21.927Z |
5570441 | 5570441 | 20241120194114_p6uiR | UK0070 | 2024-11-22T14:15:26.390Z | 2024-11-22T14:19:21.918Z |
5570395 | 5570395 | 20241120193141_UzvGr | UK0070 | 2024-11-22T14:15:19.603Z | 2024-11-22T14:19:21.910Z |
5570276 | 5570276 | 20241120191243_3Vaop | UK0070 | 2024-11-22T14:15:05.925Z | 2024-11-22T14:19:21.891Z |
5569988 | 5569988 | 20241120182051_SfFxu | UK0070 | 2024-11-22T14:14:43.440Z | 2024-11-22T14:19:21.843Z |
5569877 | 5569877 | 20241120175338_OvrqZ | UK0070 | 2024-11-22T14:14:29.346Z | 2024-11-22T14:19:21.821Z |
5566352 | 5566352 | 20241121060440_X2LST | UK0070 | 2024-11-22T14:02:30.723Z | 2024-11-22T14:02:30.723Z |
5566303 | 5566303 | 20241121055822_IJY1Q | UK0070 | 2024-11-22T14:02:24.310Z | 2024-11-22T14:02:24.310Z |
5566227 | 5566227 | 20241121055001_rbgRH | UK0070 | 2024-11-22T14:02:16.174Z | 2024-11-22T14:02:16.174Z |
5566050 | 5566050 | 20241121052042_AO8co | UK0070 | 2024-11-22T14:01:37.454Z | 2024-11-22T14:01:37.454Z |
5566034 | 5566034 | 20241121052004_gAZiF | UK0070 | 2024-11-22T14:01:35.870Z | 2024-11-22T14:01:35.870Z |
5565858 | 5565858 | 20241121045524_CUhXT | UK0070 | 2024-11-22T14:01:12.981Z | 2024-11-22T14:01:12.981Z |
5565811 | 5565811 | 20241121044955_3mri5 | UK0070 | 2024-11-22T14:01:00.224Z | 2024-11-22T14:01:00.224Z |
5565766 | 5565766 | 20241121044239_CWd9f | UK0070 | 2024-11-22T14:00:54.011Z | 2024-11-22T14:00:54.011Z |
5565575 | 5565575 | 20241121042334_yav2c | UK0070 | 2024-11-22T14:00:19.615Z | 2024-11-22T14:00:19.615Z |
5564986 | 5564986 | 20241120034328_ALSKA | UK0070 | 2024-11-21T14:18:17.670Z | 2024-11-22T14:21:40.098Z |
5564054 | 5564054 | 20241120022621_zVcIL | UK0070 | 2024-11-21T14:17:07.231Z | 2024-11-22T14:21:26.753Z |
5563783 | 5563783 | 20241120020425_Uj2Jb | UK0070 | 2024-11-21T14:16:43.808Z | 2024-11-22T14:21:22.932Z |
5563373 | 5563373 | 20241120012208_mt8EH | UK0070 | 2024-11-21T14:16:00.434Z | 2024-11-22T14:21:14.728Z |
5562818 | 5562818 | 20241120001528_Kpr3c | UK0070 | 2024-11-21T14:15:23.704Z | 2024-11-22T14:21:05.094Z |
5562601 | 5562601 | 20241119235356_h5w2P | UK0070 | 2024-11-21T14:15:12.606Z | 2024-11-22T14:21:00.811Z |
5562492 | 5562492 | 20241119234356_QWnVi | UK0070 | 2024-11-21T14:15:01.604Z | 2024-11-22T14:20:59.423Z |
5562372 | 5562372 | 20241119233131_9Nsyw | UK0070 | 2024-11-21T14:14:45.463Z | 2024-11-22T14:20:56.840Z |
5562154 | 5562154 | 20241119230623_Tyc0K | UK0070 | 2024-11-21T14:14:29.368Z | 2024-11-22T14:20:53.498Z |
5562115 | 5562115 | 20241119230157_2wlaD | UK0070 | 2024-11-21T14:14:26.129Z | 2024-11-22T14:20:52.973Z |
5562079 | 5562079 | 20241119225836_Gb8zI | UK0070 | 2024-11-21T14:14:23.650Z | 2024-11-22T14:20:52.447Z |
5561981 | 5561981 | 20241119224031_2Cfjb | UK0070 | 2024-11-21T14:14:17.943Z | 2024-11-22T14:20:50.894Z |
5561372 | 5561372 | 20241119201722_KBj8m | UK0070 | 2024-11-21T14:13:10.739Z | 2024-11-22T14:20:33.931Z |
5561316 | 5561316 | 20241119195207_muFk3 | UK0070 | 2024-11-21T14:13:04.890Z | 2024-11-22T14:20:31.842Z |
5557899 | 5557899 | 20241120052225_wRKvI | UK0070 | 2024-11-21T14:02:01.533Z | 2024-11-22T14:19:21.143Z |
5557725 | 5557725 | 20241120050805_JZoqY | UK0070 | 2024-11-21T14:01:35.820Z | 2024-11-22T14:19:21.118Z |
5552863 | 5552863 | 20241117224808_wt43e | UK0070 | 2024-11-19T14:09:28.367Z | 2024-11-22T14:22:47.748Z |
5543115 | 5543115 | 20241114205025_BSQRV | UK0070 | 2024-11-16T14:05:32.843Z | 2024-11-22T14:23:56.946Z |
5539214 | 5539214 | 20241114055001_1S7Kw | UK0070 | 2024-11-15T14:00:22.637Z | 2024-11-22T14:23:42.462Z |
5539205 | 5539205 | 20241114054926_Xmt1K | UK0070 | 2024-11-15T14:00:21.813Z | 2024-11-22T14:23:42.444Z |
5539092 | 5539092 | 20241113054200_Cf8Lp | UK0070 | 2024-11-14T14:14:13.133Z | 2024-11-21T14:26:31.592Z |
5539005 | 5539005 | 20241113053226_rMAwE | UK0070 | 2024-11-14T14:14:08.205Z | 2024-11-21T14:26:31.008Z |
5538962 | 5538962 | 20241113052506_CiYf5 | UK0070 | 2024-11-14T14:14:05.661Z | 2024-11-21T14:26:30.491Z |
5538804 | 5538804 | 20241113050018_y7Yl2 | UK0070 | 2024-11-14T14:13:58.301Z | 2024-11-21T14:26:28.770Z |
5538744 | 5538744 | 20241113044941_tQ0Jl | UK0070 | 2024-11-14T14:13:54.506Z | 2024-11-21T14:26:28.683Z |
5538716 | 5538716 | 20241113044319_yPZ6F | UK0070 | 2024-11-14T14:13:52.681Z | 2024-11-21T14:26:28.570Z |
5538709 | 5538709 | 20241113044316_nnRXN | UK0070 | 2024-11-14T14:13:52.394Z | 2024-11-21T14:26:28.569Z |
5538673 | 5538673 | 20241113043335_qvs8L | UK0070 | 2024-11-14T14:13:48.284Z | 2024-11-21T14:26:28.472Z |
5538590 | 5538590 | 20241113041640_7rptk | UK0070 | 2024-11-14T14:13:41.937Z | 2024-11-21T14:26:27.308Z |
5531286 | 5531286 | 20241112032840_FEDCd | UK0070 | 2024-11-13T14:15:32.780Z | 2024-11-20T14:26:09.975Z |
5529360 | 5529360 | 20241112000642_0QOAy | UK0070 | 2024-11-13T14:12:26.902Z | 2024-11-20T14:25:43.329Z |
5528306 | 5528306 | 20241111201908_VmAUG | UK0070 | 2024-11-13T14:10:26.035Z | 2024-11-20T14:25:28.254Z |
5527732 | 5527732 | 20241111182548_t960E | UK0070 | 2024-11-13T14:09:00.619Z | 2024-11-20T14:25:18.629Z |
5524610 | 5524610 | 20241111044557_gKkPg | UK0070 | 2024-11-12T14:17:46.005Z | 2024-11-19T14:22:22.852Z |
5524470 | 5524470 | 20241111041812_Prqwa | UK0070 | 2024-11-12T14:17:23.936Z | 2024-11-19T14:22:21.505Z |
5524240 | 5524240 | 20241111033800_wH1B8 | UK0070 | 2024-11-12T14:16:50.203Z | 2024-11-19T14:22:19.128Z |
5524124 | 5524124 | 20241111031710_X3Wml | UK0070 | 2024-11-12T14:16:34.597Z | 2024-11-19T14:22:17.475Z |
5524042 | 5524042 | 20241111030625_4boNY | UK0070 | 2024-11-12T14:16:29.430Z | 2024-11-19T14:22:16.811Z |
5523970 | 5523970 | 20241111025659_GvLrL | UK0070 | 2024-11-12T14:16:22.947Z | 2024-11-19T14:22:16.261Z |
5523957 | 5523957 | 20241111025407_4R3t7 | UK0070 | 2024-11-12T14:16:22.266Z | 2024-11-19T14:22:16.117Z |
5523893 | 5523893 | 20241111024359_CRZFa | UK0070 | 2024-11-12T14:16:19.141Z | 2024-11-19T14:22:15.717Z |
5523786 | 5523786 | 20241111022313_pWOLK | UK0070 | 2024-11-12T14:16:13.127Z | 2024-11-19T14:22:14.920Z |
5523645 | 5523645 | 20241111015955_0ZC3K | UK0070 | 2024-11-12T14:16:05.698Z | 2024-11-19T14:22:14.207Z |
5523634 | 5523634 | 20241111015817_1WpG3 | UK0070 | 2024-11-12T14:16:04.912Z | 2024-11-19T14:22:13.941Z |
5523605 | 5523605 | 20241111015407_714rZ | UK0070 | 2024-11-12T14:16:03.282Z | 2024-11-19T14:22:13.741Z |
5452864 | 5452864 | 20241101050832_ncjNz | UK0070 | 2024-11-02T12:19:30.691Z | 2024-11-09T14:24:35.150Z |
5452846 | 5452846 | 20241101050417_bFtS2 | UK0070 | 2024-11-02T12:19:29.414Z | 2024-11-09T14:24:34.676Z |
5452836 | 5452836 | 20241101050110_SF9oD | UK0070 | 2024-11-02T12:19:28.475Z | 2024-11-09T14:24:34.483Z |
5452825 | 5452825 | 20241101045726_toVX3 | UK0070 | 2024-11-02T12:19:26.336Z | 2024-11-09T14:24:34.346Z |
5452792 | 5452792 | 20241101043827_zeb82 | UK0070 | 2024-11-02T12:19:22.606Z | 2024-11-09T14:24:33.879Z |
5442505 | 5442505 | 20241030014139_Pyv0T | UK0070 | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442489 | 5442489 | 20241030013755_U2R8w | UK0070 | 2024-11-01T12:19:54.006Z | 2024-11-07T14:26:46.732Z |
5441802 | 5441802 | 20241029233840_bZxyB | UK0070 | 2024-11-01T12:19:02.672Z | 2024-11-07T14:26:43.348Z |
5441513 | 5441513 | 20241029222823_kOgnn | UK0070 | 2024-11-01T12:18:42.200Z | 2024-11-07T14:26:42.543Z |
5441384 | 5441384 | 20241029215808_7ebEv | UK0070 | 2024-11-01T12:18:30.881Z | 2024-11-07T14:26:41.973Z |
5441322 | 5441322 | 20241029214241_BjRJd | UK0070 | 2024-11-01T12:18:26.274Z | 2024-11-07T14:26:41.695Z |
5441263 | 5441263 | 20241029212256_Vo0R7 | UK0070 | 2024-11-01T12:18:21.954Z | 2024-11-07T14:26:41.416Z |
5433610 | 5433610 | 20241029203124_xpST3 | UK0070 | 2024-10-31T12:22:24.367Z | 2024-11-07T14:26:40.316Z |
5433452 | 5433452 | 20241029200007_RdE4V | UK0070 | 2024-10-31T12:22:16.541Z | 2024-11-07T14:26:39.654Z |
5433423 | 5433423 | 20241029195032_XUZ1b | UK0070 | 2024-10-31T12:22:14.160Z | 2024-11-07T14:26:39.315Z |
5433401 | 5433401 | 20241029194104_5AiTr | UK0070 | 2024-10-31T12:22:12.924Z | 2024-11-07T14:26:39.033Z |
5433246 | 5433246 | 20241029183110_ftBjm | UK0070 | 2024-10-31T12:22:01.529Z | 2024-11-07T14:26:37.201Z |
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);