participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK002F" 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 |
---|---|---|---|---|---|
5565479 | 5565479 | 20241120043016_ZHdt8 | UK002F | 2024-11-21T14:18:50.649Z | 2024-11-21T14:18:54.216Z |
5565454 | 5565454 | 20241120042807_EXWOu | UK002F | 2024-11-21T14:18:49.803Z | 2024-11-21T14:18:54.212Z |
5565343 | 5565343 | 20241120042009_5YeXg | UK002F | 2024-11-21T14:18:46.869Z | 2024-11-21T14:18:54.195Z |
5565319 | 5565319 | 20241120041931_BKxVw | UK002F | 2024-11-21T14:18:46.548Z | 2024-11-21T14:18:54.193Z |
5565289 | 5565289 | 20241120041605_ZDRzV | UK002F | 2024-11-21T14:18:45.380Z | 2024-11-21T14:18:54.188Z |
5565127 | 5565127 | 20241120035432_PW6Ms | UK002F | 2024-11-21T14:18:32.947Z | 2024-11-21T14:18:54.159Z |
5565038 | 5565038 | 20241120034535_3lqSv | UK002F | 2024-11-21T14:18:23.436Z | 2024-11-21T14:18:54.144Z |
5565008 | 5565008 | 20241120034424_49SUs | UK002F | 2024-11-21T14:18:19.115Z | 2024-11-21T14:18:54.139Z |
5564948 | 5564948 | 20241120034038_06HNq | UK002F | 2024-11-21T14:18:16.067Z | 2024-11-21T14:18:54.129Z |
5564841 | 5564841 | 20241120033011_gSD9H | UK002F | 2024-11-21T14:18:06.804Z | 2024-11-21T14:18:54.108Z |
5564661 | 5564661 | 20241120031703_WCQnX | UK002F | 2024-11-21T14:17:55.901Z | 2024-11-21T14:18:54.078Z |
5564645 | 5564645 | 20241120031556_3z33O | UK002F | 2024-11-21T14:17:54.998Z | 2024-11-21T14:18:54.075Z |
5564544 | 5564544 | 20241120030747_TluGP | UK002F | 2024-11-21T14:17:47.687Z | 2024-11-21T14:18:54.059Z |
5564489 | 5564489 | 20241120030300_tdre2 | UK002F | 2024-11-21T14:17:42.057Z | 2024-11-21T14:18:54.050Z |
5564343 | 5564343 | 20241120024857_wVpgf | UK002F | 2024-11-21T14:17:28.232Z | 2024-11-21T14:18:54.026Z |
5564316 | 5564316 | 20241120024738_3Tnx3 | UK002F | 2024-11-21T14:17:27.288Z | 2024-11-21T14:18:54.023Z |
5564263 | 5564263 | 20241120024313_gvibO | UK002F | 2024-11-21T14:17:23.041Z | 2024-11-21T14:18:54.013Z |
5564114 | 5564114 | 20241120022927_lSnCz | UK002F | 2024-11-21T14:17:11.210Z | 2024-11-21T14:18:53.982Z |
5564108 | 5564108 | 20241120022838_6rg10 | UK002F | 2024-11-21T14:17:10.604Z | 2024-11-21T14:18:53.980Z |
5564101 | 5564101 | 20241120022833_wJJzG | UK002F | 2024-11-21T14:17:09.903Z | 2024-11-21T14:18:53.980Z |
5563937 | 5563937 | 20241120021818_wc39y | UK002F | 2024-11-21T14:16:59.902Z | 2024-11-21T14:18:53.950Z |
5563713 | 5563713 | 20241120015944_DpvME | UK002F | 2024-11-21T14:16:35.920Z | 2024-11-21T14:18:53.904Z |
5563219 | 5563219 | 20241120010723_QtyUZ | UK002F | 2024-11-21T14:15:40.929Z | 2024-11-21T14:18:53.810Z |
5563151 | 5563151 | 20241120005856_a8L3l | UK002F | 2024-11-21T14:15:38.500Z | 2024-11-21T14:18:53.799Z |
5563070 | 5563070 | 20241120004819_Pyamh | UK002F | 2024-11-21T14:15:34.521Z | 2024-11-21T14:18:53.786Z |
5562650 | 5562650 | 20241120000143_VrNaM | UK002F | 2024-11-21T14:15:15.500Z | 2024-11-21T14:18:53.716Z |
5562419 | 5562419 | 20241119233512_YNsFl | UK002F | 2024-11-21T14:14:48.615Z | 2024-11-21T14:18:53.680Z |
5561955 | 5561955 | 20241119223904_UDAd2 | UK002F | 2024-11-21T14:14:17.025Z | 2024-11-21T14:18:53.611Z |
5561877 | 5561877 | 20241119222414_lQ5vc | UK002F | 2024-11-21T14:14:12.193Z | 2024-11-21T14:18:53.598Z |
5561864 | 5561864 | 20241119221902_xeJ3B | UK002F | 2024-11-21T14:14:10.968Z | 2024-11-21T14:18:53.595Z |
5561749 | 5561749 | 20241119215957_yraov | UK002F | 2024-11-21T14:13:58.196Z | 2024-11-21T14:18:53.574Z |
5561711 | 5561711 | 20241119214742_utnXH | UK002F | 2024-11-21T14:13:49.582Z | 2024-11-21T14:18:53.567Z |
5561664 | 5561664 | 20241119212809_VFtNs | UK002F | 2024-11-21T14:13:41.823Z | 2024-11-21T14:18:53.558Z |
5561630 | 5561630 | 20241119212216_dUmiL | UK002F | 2024-11-21T14:13:38.433Z | 2024-11-21T14:18:53.552Z |
5561625 | 5561625 | 20241119211845_UUj4r | UK002F | 2024-11-21T14:13:36.770Z | 2024-11-21T14:18:53.551Z |
5561531 | 5561531 | 20241119205446_txdYY | UK002F | 2024-11-21T14:13:25.336Z | 2024-11-21T14:18:53.531Z |
5561106 | 5561106 | 20241119181704_EZ5U2 | UK002F | 2024-11-21T14:12:24.006Z | 2024-11-21T14:18:53.405Z |
5558512 | 5558512 | 20241120061951_PLFUQ | UK002F | 2024-11-21T14:03:29.127Z | 2024-11-21T14:03:29.127Z |
5558214 | 5558214 | 20241120054624_UyP2F | UK002F | 2024-11-21T14:02:45.214Z | 2024-11-21T14:02:45.214Z |
5558163 | 5558163 | 20241120054136_fR05W | UK002F | 2024-11-21T14:02:38.617Z | 2024-11-21T14:02:38.617Z |
5558154 | 5558154 | 20241120054122_OMuy8 | UK002F | 2024-11-21T14:02:37.574Z | 2024-11-21T14:02:37.574Z |
5558119 | 5558119 | 20241120053858_198Rd | UK002F | 2024-11-21T14:02:33.547Z | 2024-11-21T14:02:33.547Z |
5557955 | 5557955 | 20241120052620_cYQ6m | UK002F | 2024-11-21T14:02:08.801Z | 2024-11-21T14:02:08.801Z |
5557650 | 5557650 | 20241120050344_jlK41 | UK002F | 2024-11-21T14:01:26.020Z | 2024-11-21T14:01:26.020Z |
5557414 | 5557414 | 20241120044425_fMhrY | UK002F | 2024-11-21T14:00:45.707Z | 2024-11-21T14:00:45.707Z |
5557401 | 5557401 | 20241120044355_xEU13 | UK002F | 2024-11-21T14:00:43.431Z | 2024-11-21T14:00:43.431Z |
5557363 | 5557363 | 20241120044042_z6lj1 | UK002F | 2024-11-21T14:00:36.947Z | 2024-11-21T14:00:36.947Z |
5549648 | 5549648 | 20241118054811_Hjged | UK002F | 2024-11-19T14:00:29.990Z | 2024-11-21T14:18:57.256Z |
5549638 | 5549638 | 20241118054747_o2TJx | UK002F | 2024-11-19T14:00:29.152Z | 2024-11-21T14:18:57.196Z |
5549566 | 5549566 | 20241118053122_4UcrV | UK002F | 2024-11-19T14:00:19.518Z | 2024-11-21T14:18:56.442Z |
5543867 | 5543867 | 20241115035742_F7wT2 | UK002F | 2024-11-16T14:07:33.610Z | 2024-11-21T14:24:35.357Z |
5543758 | 5543758 | 20241115032010_FXHf3 | UK002F | 2024-11-16T14:07:09.081Z | 2024-11-21T14:24:32.694Z |
5543649 | 5543649 | 20241115024254_rW6gI | UK002F | 2024-11-16T14:06:58.263Z | 2024-11-21T14:24:30.681Z |
5543518 | 5543518 | 20241115015453_oz2sI | UK002F | 2024-11-16T14:06:34.709Z | 2024-11-21T14:24:28.968Z |
5543508 | 5543508 | 20241115015118_4PkkR | UK002F | 2024-11-16T14:06:33.748Z | 2024-11-21T14:24:28.941Z |
5543467 | 5543467 | 20241115013715_97cn7 | UK002F | 2024-11-16T14:06:26.538Z | 2024-11-21T14:24:28.655Z |
5543398 | 5543398 | 20241115010341_nHjmM | UK002F | 2024-11-16T14:06:14.173Z | 2024-11-21T14:24:27.783Z |
5543394 | 5543394 | 20241115010248_gjNOh | UK002F | 2024-11-16T14:06:13.995Z | 2024-11-21T14:24:27.780Z |
5543389 | 5543389 | 20241115005617_Ps2AB | UK002F | 2024-11-16T14:06:13.506Z | 2024-11-21T14:24:27.758Z |
5543369 | 5543369 | 20241115004434_DUlD0 | UK002F | 2024-11-16T14:06:10.040Z | 2024-11-21T14:24:26.851Z |
5543350 | 5543350 | 20241115002918_Mj3jM | UK002F | 2024-11-16T14:06:08.562Z | 2024-11-21T14:24:26.815Z |
5543307 | 5543307 | 20241115000331_TL6kl | UK002F | 2024-11-16T14:06:04.330Z | 2024-11-21T14:24:25.786Z |
5543277 | 5543277 | 20241114234502_MfvkU | UK002F | 2024-11-16T14:05:59.253Z | 2024-11-21T14:24:25.637Z |
5543227 | 5543227 | 20241114231722_fjfrZ | UK002F | 2024-11-16T14:05:48.173Z | 2024-11-21T14:24:25.368Z |
5532810 | 5532810 | 20241113055734_VG8lK | UK002F | 2024-11-14T14:00:18.133Z | 2024-11-21T14:24:40.220Z |
5531389 | 5531389 | 20241112033516_9xokQ | UK002F | 2024-11-13T14:15:37.184Z | 2024-11-20T14:26:11.061Z |
5531301 | 5531301 | 20241112032951_vHMQr | UK002F | 2024-11-13T14:15:33.500Z | 2024-11-20T14:26:10.169Z |
5530910 | 5530910 | 20241112025921_qmpNG | UK002F | 2024-11-13T14:14:50.444Z | 2024-11-20T14:26:05.171Z |
5530881 | 5530881 | 20241112025657_Dqk48 | UK002F | 2024-11-13T14:14:47.449Z | 2024-11-20T14:26:04.398Z |
5530667 | 5530667 | 20241112023725_idj2d | UK002F | 2024-11-13T14:14:27.213Z | 2024-11-20T14:26:02.533Z |
5530626 | 5530626 | 20241112023545_0eS32 | UK002F | 2024-11-13T14:14:25.277Z | 2024-11-20T14:26:02.037Z |
5530559 | 5530559 | 20241112022803_TC35r | UK002F | 2024-11-13T14:14:22.308Z | 2024-11-20T14:26:01.636Z |
5530376 | 5530376 | 20241112021332_33wys | UK002F | 2024-11-13T14:14:12.631Z | 2024-11-20T14:25:58.266Z |
5530356 | 5530356 | 20241112021118_W6aqY | UK002F | 2024-11-13T14:14:11.032Z | 2024-11-20T14:25:57.971Z |
5530202 | 5530202 | 20241112015624_bQ2kV | UK002F | 2024-11-13T14:14:01.612Z | 2024-11-20T14:25:55.418Z |
5530189 | 5530189 | 20241112015507_pQPgu | UK002F | 2024-11-13T14:14:01.223Z | 2024-11-20T14:25:55.381Z |
5529915 | 5529915 | 20241112012156_B7l5I | UK002F | 2024-11-13T14:13:22.738Z | 2024-11-20T14:25:50.977Z |
5529881 | 5529881 | 20241112011643_0KtwD | UK002F | 2024-11-13T14:13:18.622Z | 2024-11-20T14:25:50.168Z |
5529848 | 5529848 | 20241112011029_kTr7j | UK002F | 2024-11-13T14:13:15.325Z | 2024-11-20T14:25:49.988Z |
5529795 | 5529795 | 20241112010524_1XQF2 | UK002F | 2024-11-13T14:13:11.434Z | 2024-11-20T14:25:48.254Z |
5529741 | 5529741 | 20241112010120_YqAhD | UK002F | 2024-11-13T14:13:08.719Z | 2024-11-20T14:25:47.888Z |
5529691 | 5529691 | 20241112005517_yOi4O | UK002F | 2024-11-13T14:13:06.488Z | 2024-11-20T14:25:47.529Z |
5529654 | 5529654 | 20241112005045_13g4Q | UK002F | 2024-11-13T14:13:04.735Z | 2024-11-20T14:25:47.185Z |
5529516 | 5529516 | 20241112003016_3FrQx | UK002F | 2024-11-13T14:12:56.027Z | 2024-11-20T14:25:45.956Z |
5529335 | 5529335 | 20241112000411_g3mWa | UK002F | 2024-11-13T14:12:23.393Z | 2024-11-20T14:25:42.972Z |
5529330 | 5529330 | 20241112000336_gfuLD | UK002F | 2024-11-13T14:12:22.751Z | 2024-11-20T14:25:42.868Z |
5529321 | 5529321 | 20241112000059_TDgS9 | UK002F | 2024-11-13T14:12:22.004Z | 2024-11-20T14:25:42.804Z |
5529297 | 5529297 | 20241111235836_WJUII | UK002F | 2024-11-13T14:12:20.735Z | 2024-11-20T14:25:42.639Z |
5529246 | 5529246 | 20241111235427_iJnx8 | UK002F | 2024-11-13T14:12:15.923Z | 2024-11-20T14:25:42.216Z |
5529230 | 5529230 | 20241111235241_Sjk8j | UK002F | 2024-11-13T14:12:14.803Z | 2024-11-20T14:25:42.042Z |
5529213 | 5529213 | 20241111234711_VF8R6 | UK002F | 2024-11-13T14:12:13.975Z | 2024-11-20T14:25:41.874Z |
5529155 | 5529155 | 20241111233849_FWfE7 | UK002F | 2024-11-13T14:12:09.554Z | 2024-11-20T14:25:40.840Z |
5529118 | 5529118 | 20241111233148_DvcB1 | UK002F | 2024-11-13T14:12:06.228Z | 2024-11-20T14:25:40.123Z |
5528986 | 5528986 | 20241111231618_cnTeT | UK002F | 2024-11-13T14:11:55.080Z | 2024-11-20T14:25:38.464Z |
5528862 | 5528862 | 20241111225811_Xn1TU | UK002F | 2024-11-13T14:11:33.319Z | 2024-11-20T14:25:36.799Z |
5528852 | 5528852 | 20241111225418_zUXW9 | UK002F | 2024-11-13T14:11:31.717Z | 2024-11-20T14:25:36.744Z |
5528843 | 5528843 | 20241111224941_udmX2 | UK002F | 2024-11-13T14:11:29.549Z | 2024-11-20T14:25:36.679Z |
5528810 | 5528810 | 20241111224159_X3UxM | UK002F | 2024-11-13T14:11:27.513Z | 2024-11-20T14:25:36.147Z |
5528802 | 5528802 | 20241111224159_suo6e | UK002F | 2024-11-13T14:11:27.233Z | 2024-11-20T14:25:36.068Z |
5528639 | 5528639 | 20241111220256_CByhL | UK002F | 2024-11-13T14:11:12.180Z | 2024-11-20T14:25:33.055Z |
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);