participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK000S" 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 |
---|---|---|---|---|---|
5440585 | 5440585 | 20241030223045_4mckj | UK000S | 2024-11-01T12:15:38.372Z | 2024-11-08T14:23:09.953Z |
5440549 | 5440549 | 20241030222650_d3eYq | UK000S | 2024-11-01T12:15:36.599Z | 2024-11-08T14:23:09.899Z |
5440542 | 5440542 | 20241030222632_XdSPO | UK000S | 2024-11-01T12:15:36.325Z | 2024-11-08T14:23:09.885Z |
5440413 | 5440413 | 20241030220853_1tx8l | UK000S | 2024-11-01T12:15:29.499Z | 2024-11-08T14:23:09.370Z |
5440401 | 5440401 | 20241030220817_qidos | UK000S | 2024-11-01T12:15:29.110Z | 2024-11-08T14:23:09.357Z |
5440311 | 5440311 | 20241030215554_ZwxHj | UK000S | 2024-11-01T12:15:21.835Z | 2024-11-08T14:23:08.939Z |
5440239 | 5440239 | 20241030214604_HKiF0 | UK000S | 2024-11-01T12:15:04.198Z | 2024-11-08T14:23:08.188Z |
5440101 | 5440101 | 20241030212312_cPqJP | UK000S | 2024-11-01T12:14:50.416Z | 2024-11-08T14:23:07.350Z |
5440094 | 5440094 | 20241030212237_3aAbd | UK000S | 2024-11-01T12:14:49.789Z | 2024-11-08T14:23:07.326Z |
5439994 | 5439994 | 20241030210438_SsIqy | UK000S | 2024-11-01T12:14:43.600Z | 2024-11-08T14:23:06.692Z |
5439978 | 5439978 | 20241030210032_W42aY | UK000S | 2024-11-01T12:14:41.987Z | 2024-11-08T14:23:06.586Z |
5439798 | 5439798 | 20241030203329_rxcN1 | UK000S | 2024-11-01T12:14:30.812Z | 2024-11-08T14:23:05.829Z |
5433008 | 5433008 | 20241029054305_sW24H | UK000S | 2024-10-31T12:21:42.783Z | 2024-11-06T14:27:29.601Z |
5432945 | 5432945 | 20241029052349_N2K4C | UK000S | 2024-10-31T12:21:40.843Z | 2024-11-06T14:27:29.374Z |
5432933 | 5432933 | 20241029052018_kQMnp | UK000S | 2024-10-31T12:21:39.852Z | 2024-11-06T14:27:29.351Z |
5432923 | 5432923 | 20241029051655_tiUaB | UK000S | 2024-10-31T12:21:38.901Z | 2024-11-06T14:27:29.288Z |
5432895 | 5432895 | 20241029050911_MCNRA | UK000S | 2024-10-31T12:21:38.098Z | 2024-11-06T14:27:29.134Z |
5432875 | 5432875 | 20241029050515_iSKu3 | UK000S | 2024-10-31T12:21:37.483Z | 2024-11-06T14:27:29.076Z |
5432871 | 5432871 | 20241029050354_cGx00 | UK000S | 2024-10-31T12:21:37.324Z | 2024-11-06T14:27:29.070Z |
5432854 | 5432854 | 20241029045856_uP5VX | UK000S | 2024-10-31T12:21:36.843Z | 2024-11-06T14:27:29.018Z |
5432833 | 5432833 | 20241029045208_nlk6Y | UK000S | 2024-10-31T12:21:36.365Z | 2024-11-06T14:27:28.902Z |
5432777 | 5432777 | 20241029043603_Gryc8 | UK000S | 2024-10-31T12:21:34.669Z | 2024-11-06T14:27:28.691Z |
5432697 | 5432697 | 20241029042010_NjSzC | UK000S | 2024-10-31T12:21:31.530Z | 2024-11-06T14:27:28.454Z |
5422838 | 5422838 | 20241026182846_BKp4a | UK000S | 2024-10-30T12:21:39.607Z | 2024-11-04T14:28:41.676Z |
5418133 | 5418133 | 20241027195810_mEubV | UK000S | 2024-10-30T12:14:58.819Z | 2024-11-05T14:27:09.260Z |
5418109 | 5418109 | 20241027195635_XPV1a | UK000S | 2024-10-30T12:14:54.855Z | 2024-11-05T14:27:09.139Z |
5417779 | 5417779 | 20241027191232_Gz1bM | UK000S | 2024-10-30T12:14:27.701Z | 2024-11-05T14:27:08.255Z |
5417766 | 5417766 | 20241027191218_36ro4 | UK000S | 2024-10-30T12:14:26.860Z | 2024-11-05T14:27:08.205Z |
5417614 | 5417614 | 20241027185350_nnM0P | UK000S | 2024-10-30T12:13:59.783Z | 2024-11-05T14:27:07.802Z |
5417386 | 5417386 | 20241027182423_uZC1j | UK000S | 2024-10-30T12:13:36.290Z | 2024-11-05T14:27:07.156Z |
5417153 | 5417153 | 20241027175154_uzgPe | UK000S | 2024-10-30T12:13:07.413Z | 2024-11-05T14:27:06.621Z |
5410826 | 5410826 | 20241027053957_mtQzN | UK000S | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410269 | 5410269 | 20241027050500_GTyik | UK000S | 2024-10-29T12:17:52.120Z | 2024-11-04T14:29:04.277Z |
5410240 | 5410240 | 20241027050234_4umfj | UK000S | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5410228 | 5410228 | 20241027050109_XaB1Z | UK000S | 2024-10-29T12:17:51.031Z | 2024-11-04T14:29:04.222Z |
5410171 | 5410171 | 20241027045834_ZwIQq | UK000S | 2024-10-29T12:17:49.836Z | 2024-11-04T14:29:03.984Z |
5410163 | 5410163 | 20241027045832_yZY1r | UK000S | 2024-10-29T12:17:49.745Z | 2024-11-04T14:29:03.980Z |
5409857 | 5409857 | 20241027043845_IEzAP | UK000S | 2024-10-29T12:17:42.495Z | 2024-11-04T14:29:02.821Z |
5409656 | 5409656 | 20241027042956_UToeI | UK000S | 2024-10-29T12:17:36.291Z | 2024-11-04T14:29:02.059Z |
5409576 | 5409576 | 20241027042713_LUPXj | UK000S | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.963Z |
5409369 | 5409369 | 20241027041300_IFt1x | UK000S | 2024-10-29T12:17:18.194Z | 2024-11-04T14:29:01.603Z |
5409078 | 5409078 | 20241027035918_Ss0G2 | UK000S | 2024-10-29T12:17:05.048Z | 2024-11-04T14:29:01.037Z |
5409019 | 5409019 | 20241027035545_CacHo | UK000S | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5409011 | 5409011 | 20241027035431_D2JLe | UK000S | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408916 | 5408916 | 20241027034956_e8IYl | UK000S | 2024-10-29T12:16:57.132Z | 2024-11-04T14:29:00.824Z |
5408855 | 5408855 | 20241027034647_9Rrkv | UK000S | 2024-10-29T12:16:55.008Z | 2024-11-04T14:29:00.733Z |
5408519 | 5408519 | 20241027032901_tVlBs | UK000S | 2024-10-29T12:16:34.284Z | 2024-11-04T14:28:59.593Z |
5408449 | 5408449 | 20241027032738_UTREC | UK000S | 2024-10-29T12:16:30.939Z | 2024-11-04T14:28:59.506Z |
5408311 | 5408311 | 20241027032209_2JJ6D | UK000S | 2024-10-29T12:16:22.104Z | 2024-11-04T14:28:59.079Z |
5408257 | 5408257 | 20241027032003_zOBKL | UK000S | 2024-10-29T12:16:20.123Z | 2024-11-04T14:28:59.039Z |
5408011 | 5408011 | 20241027030215_8dZrM | UK000S | 2024-10-29T12:15:59.680Z | 2024-11-04T14:28:58.691Z |
5407936 | 5407936 | 20241027025839_GLXBN | UK000S | 2024-10-29T12:15:54.213Z | 2024-11-04T14:28:58.515Z |
5407520 | 5407520 | 20241027024034_INvSO | UK000S | 2024-10-29T12:15:28.161Z | 2024-11-04T14:28:57.840Z |
5407294 | 5407294 | 20241027023036_BfjWF | UK000S | 2024-10-29T12:15:20.142Z | 2024-11-04T14:28:57.298Z |
5407171 | 5407171 | 20241027022457_RalF2 | UK000S | 2024-10-29T12:15:15.865Z | 2024-11-04T14:28:57.168Z |
5407149 | 5407149 | 20241027022404_742y8 | UK000S | 2024-10-29T12:15:14.951Z | 2024-11-04T14:28:57.110Z |
5407033 | 5407033 | 20241027021751_ZtfmF | UK000S | 2024-10-29T12:15:09.756Z | 2024-11-04T14:28:56.791Z |
5406965 | 5406965 | 20241027021426_L90xQ | UK000S | 2024-10-29T12:15:03.381Z | 2024-11-04T14:28:56.736Z |
5406854 | 5406854 | 20241027020439_0A7AZ | UK000S | 2024-10-29T12:14:50.744Z | 2024-11-04T14:28:56.519Z |
5406785 | 5406785 | 20241027015948_VWc9O | UK000S | 2024-10-29T12:14:42.191Z | 2024-11-04T14:28:56.383Z |
5406741 | 5406741 | 20241027015741_DEZLL | UK000S | 2024-10-29T12:14:38.484Z | 2024-11-04T14:28:56.332Z |
5405982 | 5405982 | 20241027011146_1oNZQ | UK000S | 2024-10-29T12:13:44.803Z | 2024-11-04T14:28:54.819Z |
5405877 | 5405877 | 20241027010546_fxSH3 | UK000S | 2024-10-29T12:13:27.709Z | 2024-11-04T14:28:54.558Z |
5405805 | 5405805 | 20241027010014_3Y08T | UK000S | 2024-10-29T12:13:18.711Z | 2024-11-04T14:28:54.336Z |
5405716 | 5405716 | 20241027005426_BE5eI | UK000S | 2024-10-29T12:13:10.676Z | 2024-11-04T14:28:53.929Z |
5405660 | 5405660 | 20241027005228_PfhNB | UK000S | 2024-10-29T12:13:08.385Z | 2024-11-04T14:28:53.877Z |
5405289 | 5405289 | 20241027002707_xYNQt | UK000S | 2024-10-29T12:12:48.269Z | 2024-11-04T14:28:53.253Z |
5405243 | 5405243 | 20241027002538_wvpGC | UK000S | 2024-10-29T12:12:46.104Z | 2024-11-04T14:28:53.162Z |
5405052 | 5405052 | 20241027001103_RJiYj | UK000S | 2024-10-29T12:12:20.312Z | 2024-11-04T14:28:52.622Z |
5405041 | 5405041 | 20241027001005_sYxuw | UK000S | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404792 | 5404792 | 20241026235236_4BpHX | UK000S | 2024-10-29T12:11:58.053Z | 2024-11-04T14:28:51.952Z |
5404589 | 5404589 | 20241026233956_AI8fa | UK000S | 2024-10-29T12:11:45.066Z | 2024-11-04T14:28:51.366Z |
5404337 | 5404337 | 20241026231842_Ru2n4 | UK000S | 2024-10-29T12:11:11.257Z | 2024-11-04T14:28:50.728Z |
5404082 | 5404082 | 20241026225640_Mx9Bw | UK000S | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.319Z |
5403969 | 5403969 | 20241026224935_13ak2 | UK000S | 2024-10-29T12:10:39.633Z | 2024-11-04T14:28:50.128Z |
5403680 | 5403680 | 20241026222325_ehWM8 | UK000S | 2024-10-29T12:10:07.452Z | 2024-11-04T14:28:49.486Z |
5403665 | 5403665 | 20241026222240_C47Zp | UK000S | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403367 | 5403367 | 20241026214653_23kU0 | UK000S | 2024-10-29T12:09:25.415Z | 2024-11-04T14:28:48.583Z |
5403303 | 5403303 | 20241026213913_F7x7K | UK000S | 2024-10-29T12:09:21.047Z | 2024-11-04T14:28:48.293Z |
5403213 | 5403213 | 20241026213015_1dM52 | UK000S | 2024-10-29T12:09:13.371Z | 2024-11-04T14:28:47.966Z |
5403164 | 5403164 | 20241026212536_TnACF | UK000S | 2024-10-29T12:09:09.167Z | 2024-11-04T14:28:47.906Z |
5403090 | 5403090 | 20241026211748_OAwnL | UK000S | 2024-10-29T12:08:53.727Z | 2024-11-04T14:28:47.701Z |
5403069 | 5403069 | 20241026211440_wPGmK | UK000S | 2024-10-29T12:08:52.191Z | 2024-11-04T14:28:47.661Z |
5402813 | 5402813 | 20241026202902_ZJYYP | UK000S | 2024-10-29T12:08:17.911Z | 2024-11-04T14:28:46.630Z |
5402696 | 5402696 | 20241026201529_2JLqC | UK000S | 2024-10-29T12:07:58.503Z | 2024-11-04T14:28:46.213Z |
5402575 | 5402575 | 20241026195745_Q4t2b | UK000S | 2024-10-29T12:07:43.910Z | 2024-11-04T14:28:45.359Z |
5402532 | 5402532 | 20241026195313_LVKHv | UK000S | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402524 | 5402524 | 20241026195115_IJwcy | UK000S | 2024-10-29T12:07:32.872Z | 2024-11-04T14:28:45.085Z |
5401992 | 5401992 | 20241026181751_WqiMm | UK000S | 2024-10-29T12:05:59.694Z | 2024-11-04T14:28:41.389Z |
5386011 | 5386011 | 20241024235311_LuDNm | UK000S | 2024-10-27T12:19:45.668Z | 2024-11-02T12:28:30.579Z |
5385356 | 5385356 | 20241024222958_sj3Bn | UK000S | 2024-10-27T12:18:47.339Z | 2024-11-02T12:28:29.667Z |
5384919 | 5384919 | 20241024211616_W44bK | UK000S | 2024-10-27T12:17:58.822Z | 2024-11-02T12:28:28.703Z |
5378000 | 5378000 | 20241024052323_x4Pcf | UK000S | 2024-10-26T12:22:52.548Z | 2024-11-01T12:27:03.221Z |
5377990 | 5377990 | 20241024052241_e90z3 | UK000S | 2024-10-26T12:22:52.158Z | 2024-11-01T12:27:03.216Z |
5377841 | 5377841 | 20241024051424_xWSQy | UK000S | 2024-10-26T12:22:48.459Z | 2024-11-01T12:27:03.088Z |
5377810 | 5377810 | 20241024051209_z1LwV | UK000S | 2024-10-26T12:22:47.546Z | 2024-11-01T12:27:03.075Z |
5377670 | 5377670 | 20241024050353_ZMqkP | UK000S | 2024-10-26T12:22:43.722Z | 2024-11-01T12:27:02.715Z |
5377587 | 5377587 | 20241024045819_DjBC3 | UK000S | 2024-10-26T12:22:41.260Z | 2024-11-01T12:27:02.616Z |
5377557 | 5377557 | 20241024045702_pDnxj | UK000S | 2024-10-26T12:22:40.627Z | 2024-11-01T12:27:02.596Z |
5377505 | 5377505 | 20241024045440_EaY8y | UK000S | 2024-10-26T12:22:39.061Z | 2024-11-01T12:27:02.477Z |
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);