participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,155 rows where station_code = "UK005G" 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 |
---|---|---|---|---|---|
5573134 | 5573134 | 20241121035806_BPMO8 | UK005G | 2024-11-22T14:19:11.683Z | 2024-11-22T14:19:22.457Z |
5573132 | 5573132 | 20241121035805_a2zdx | UK005G | 2024-11-22T14:19:11.540Z | 2024-11-22T14:19:22.456Z |
5573120 | 5573120 | 20241121035504_A2xr3 | UK005G | 2024-11-22T14:19:10.527Z | 2024-11-22T14:19:22.453Z |
5572831 | 5572831 | 20241121031422_F9UAL | UK005G | 2024-11-22T14:18:52.420Z | 2024-11-22T14:19:22.398Z |
5572500 | 5572500 | 20241121022904_RTW3Z | UK005G | 2024-11-22T14:18:30.306Z | 2024-11-22T14:19:22.340Z |
5571257 | 5571257 | 20241120230835_kXvco | UK005G | 2024-11-22T14:16:44.450Z | 2024-11-22T14:19:22.080Z |
5571159 | 5571159 | 20241120224018_UVdLK | UK005G | 2024-11-22T14:16:32.801Z | 2024-11-22T14:19:22.054Z |
5571048 | 5571048 | 20241120220445_2XX9H | UK005G | 2024-11-22T14:16:19.957Z | 2024-11-22T14:19:22.029Z |
5570754 | 5570754 | 20241120205026_dk9Io | UK005G | 2024-11-22T14:16:04.011Z | 2024-11-22T14:19:21.975Z |
5570462 | 5570462 | 20241120194151_PAzTs | UK005G | 2024-11-22T14:15:29.668Z | 2024-11-22T14:19:21.920Z |
5570288 | 5570288 | 20241120191413_fMilG | UK005G | 2024-11-22T14:15:06.189Z | 2024-11-22T14:19:21.892Z |
5570249 | 5570249 | 20241120190801_DUO2M | UK005G | 2024-11-22T14:15:04.159Z | 2024-11-22T14:19:21.887Z |
5570053 | 5570053 | 20241120183031_p3ex4 | UK005G | 2024-11-22T14:14:47.556Z | 2024-11-22T14:19:21.852Z |
5566271 | 5566271 | 20241121055503_xtAX8 | UK005G | 2024-11-22T14:02:20.901Z | 2024-11-22T14:02:20.901Z |
5566217 | 5566217 | 20241121054849_wQk4L | UK005G | 2024-11-22T14:02:15.400Z | 2024-11-22T14:02:15.400Z |
5565948 | 5565948 | 20241121051020_L5DxD | UK005G | 2024-11-22T14:01:28.105Z | 2024-11-22T14:01:28.105Z |
5565864 | 5565864 | 20241121045657_WqIGp | UK005G | 2024-11-22T14:01:13.920Z | 2024-11-22T14:01:13.920Z |
5565850 | 5565850 | 20241121045456_VUZ3C | UK005G | 2024-11-22T14:01:10.616Z | 2024-11-22T14:01:10.616Z |
5565687 | 5565687 | 20241121043533_SaNd7 | UK005G | 2024-11-22T14:00:41.043Z | 2024-11-22T14:00:41.043Z |
5565477 | 5565477 | 20241120042935_O6SIB | UK005G | 2024-11-21T14:18:50.373Z | 2024-11-22T14:21:47.525Z |
5565185 | 5565185 | 20241120040052_riXPz | UK005G | 2024-11-21T14:18:39.509Z | 2024-11-22T14:21:43.441Z |
5565047 | 5565047 | 20241120034550_0jLfJ | UK005G | 2024-11-21T14:18:23.852Z | 2024-11-22T14:21:40.522Z |
5564440 | 5564440 | 20241120025810_p41Tg | UK005G | 2024-11-21T14:17:35.807Z | 2024-11-22T14:21:31.872Z |
5564332 | 5564332 | 20241120024857_Cm9Kb | UK005G | 2024-11-21T14:17:27.700Z | 2024-11-22T14:21:30.522Z |
5564319 | 5564319 | 20241120024738_3Tnx3 | UK005G | 2024-11-21T14:17:27.288Z | 2024-11-22T14:21:30.422Z |
5563708 | 5563708 | 20241120015854_QQUUo | UK005G | 2024-11-21T14:16:35.482Z | 2024-11-22T14:21:21.264Z |
5563685 | 5563685 | 20241120015716_EDDOh | UK005G | 2024-11-21T14:16:34.157Z | 2024-11-22T14:21:21.026Z |
5558420 | 5558420 | 20241120060330_17whg | UK005G | 2024-11-21T14:03:13.819Z | 2024-11-22T14:19:21.226Z |
5558395 | 5558395 | 20241120060146_j6u2x | UK005G | 2024-11-21T14:03:11.314Z | 2024-11-22T14:19:21.222Z |
5558216 | 5558216 | 20241120054624_UyP2F | UK005G | 2024-11-21T14:02:45.215Z | 2024-11-22T14:19:21.194Z |
5558043 | 5558043 | 20241120053312_geoES | UK005G | 2024-11-21T14:02:22.365Z | 2024-11-22T14:19:21.168Z |
5557882 | 5557882 | 20241120052148_jcxBy | UK005G | 2024-11-21T14:02:00.558Z | 2024-11-22T14:19:21.141Z |
5557843 | 5557843 | 20241120051758_Cgb7v | UK005G | 2024-11-21T14:01:54.876Z | 2024-11-22T14:19:21.137Z |
5557815 | 5557815 | 20241120051441_0FIu9 | UK005G | 2024-11-21T14:01:50.827Z | 2024-11-22T14:19:21.133Z |
5557559 | 5557559 | 20241120045728_5Pvs1 | UK005G | 2024-11-21T14:01:11.338Z | 2024-11-22T14:19:21.091Z |
5557270 | 5557270 | 20241120043250_diECR | UK005G | 2024-11-21T14:00:20.056Z | 2024-11-22T14:19:21.044Z |
5553880 | 5553880 | 20241118044223_HjY4R | UK005G | 2024-11-19T14:11:31.202Z | 2024-11-22T14:22:57.022Z |
5552644 | 5552644 | 20241117194334_QO42v | UK005G | 2024-11-19T14:08:50.299Z | 2024-11-22T14:22:43.666Z |
5549578 | 5549578 | 20241118053412_Lj3Vk | UK005G | 2024-11-19T14:00:20.973Z | 2024-11-22T14:21:50.410Z |
5549534 | 5549534 | 20241118051408_baEV5 | UK005G | 2024-11-19T14:00:14.060Z | 2024-11-22T14:21:49.888Z |
5545640 | 5545640 | 20241117055607_00t75 | UK005G | 2024-11-18T14:00:30.911Z | 2024-11-22T14:22:25.277Z |
5543675 | 5543675 | 20241115025140_5h2h4 | UK005G | 2024-11-16T14:07:00.335Z | 2024-11-22T14:24:00.652Z |
5543538 | 5543538 | 20241115020006_geLhZ | UK005G | 2024-11-16T14:06:38.491Z | 2024-11-22T14:23:59.950Z |
5543520 | 5543520 | 20241115015453_oz2sI | UK005G | 2024-11-16T14:06:34.709Z | 2024-11-22T14:23:59.851Z |
5543469 | 5543469 | 20241115013715_97cn7 | UK005G | 2024-11-16T14:06:26.538Z | 2024-11-22T14:23:59.411Z |
5543366 | 5543366 | 20241115003857_IvdJ2 | UK005G | 2024-11-16T14:06:09.199Z | 2024-11-22T14:23:58.394Z |
5543351 | 5543351 | 20241115002918_Mj3jM | UK005G | 2024-11-16T14:06:08.562Z | 2024-11-22T14:23:58.372Z |
5543254 | 5543254 | 20241114232829_6y4wU | UK005G | 2024-11-16T14:05:51.730Z | 2024-11-22T14:23:57.760Z |
5543251 | 5543251 | 20241114232513_9FEm2 | UK005G | 2024-11-16T14:05:49.809Z | 2024-11-22T14:23:57.736Z |
5542041 | 5542041 | 20241114053244_T1TC3 | UK005G | 2024-11-15T14:08:50.338Z | 2024-11-22T14:24:21.866Z |
5538930 | 5538930 | 20241113052135_4obAQ | UK005G | 2024-11-14T14:14:04.328Z | 2024-11-21T14:26:29.772Z |
5538903 | 5538903 | 20241113051348_ma37S | UK005G | 2024-11-14T14:14:03.462Z | 2024-11-21T14:26:29.720Z |
5538722 | 5538722 | 20241113044708_3jQBv | UK005G | 2024-11-14T14:13:53.200Z | 2024-11-21T14:26:28.612Z |
5537806 | 5537806 | 20241113004435_F29Gk | UK005G | 2024-11-14T14:12:31.307Z | 2024-11-21T14:26:16.346Z |
5537776 | 5537776 | 20241113003617_DzLAp | UK005G | 2024-11-14T14:12:29.686Z | 2024-11-21T14:26:15.916Z |
5537734 | 5537734 | 20241113002537_QZlFv | UK005G | 2024-11-14T14:12:27.321Z | 2024-11-21T14:26:15.569Z |
5529300 | 5529300 | 20241111235836_WJUII | UK005G | 2024-11-13T14:12:20.735Z | 2024-11-20T14:25:42.639Z |
5529273 | 5529273 | 20241111235706_FM2mS | UK005G | 2024-11-13T14:12:18.372Z | 2024-11-20T14:25:42.510Z |
5528901 | 5528901 | 20241111230345_0DrJz | UK005G | 2024-11-13T14:11:37.677Z | 2024-11-20T14:25:37.150Z |
5528402 | 5528402 | 20241111203957_vdKGj | UK005G | 2024-11-13T14:10:35.184Z | 2024-11-20T14:25:30.041Z |
5527953 | 5527953 | 20241111190525_Wq6Ig | UK005G | 2024-11-13T14:09:36.777Z | 2024-11-20T14:25:23.488Z |
5524584 | 5524584 | 20241111044353_lEddc | UK005G | 2024-11-12T14:17:43.560Z | 2024-11-19T14:22:22.555Z |
5524576 | 5524576 | 20241111043907_UYDkj | UK005G | 2024-11-12T14:17:42.657Z | 2024-11-19T14:22:22.457Z |
5524421 | 5524421 | 20241111041015_bSsiE | UK005G | 2024-11-12T14:17:17.884Z | 2024-11-19T14:22:21.220Z |
5524246 | 5524246 | 20241111033828_pIIVz | UK005G | 2024-11-12T14:16:50.971Z | 2024-11-19T14:22:19.175Z |
5524150 | 5524150 | 20241111032011_rE32B | UK005G | 2024-11-12T14:16:37.995Z | 2024-11-19T14:22:17.594Z |
5524140 | 5524140 | 20241111031930_0yTzc | UK005G | 2024-11-12T14:16:36.212Z | 2024-11-19T14:22:17.546Z |
5524118 | 5524118 | 20241111031537_nrrUi | UK005G | 2024-11-12T14:16:33.919Z | 2024-11-19T14:22:17.404Z |
5441638 | 5441638 | 20241029225700_Hxbci | UK005G | 2024-11-01T12:18:49.596Z | 2024-11-07T14:26:42.794Z |
5441613 | 5441613 | 20241029225045_1BHJl | UK005G | 2024-11-01T12:18:47.912Z | 2024-11-07T14:26:42.752Z |
5441439 | 5441439 | 20241029221609_5SX8V | UK005G | 2024-11-01T12:18:36.087Z | 2024-11-07T14:26:42.114Z |
5441232 | 5441232 | 20241029211814_rf6aQ | UK005G | 2024-11-01T12:18:20.161Z | 2024-11-07T14:26:41.332Z |
5441171 | 5441171 | 20241029210308_BF4SN | UK005G | 2024-11-01T12:18:14.315Z | 2024-11-07T14:26:41.145Z |
5428903 | 5428903 | 20241028182032_ntlqa | UK005G | 2024-10-31T12:15:39.346Z | 2024-11-06T14:27:14.753Z |
5410586 | 5410586 | 20241027052007_cYzv3 | UK005G | 2024-10-29T12:17:58.907Z | 2024-11-04T14:29:05.067Z |
5410287 | 5410287 | 20241027050523_sT1ol | UK005G | 2024-10-29T12:17:52.434Z | 2024-11-04T14:29:04.303Z |
5410209 | 5410209 | 20241027045948_Tf9ip | UK005G | 2024-10-29T12:17:50.647Z | 2024-11-04T14:29:04.045Z |
5410140 | 5410140 | 20241027045526_BQ6Hg | UK005G | 2024-10-29T12:17:48.871Z | 2024-11-04T14:29:03.885Z |
5409456 | 5409456 | 20241027041930_hQEPn | UK005G | 2024-10-29T12:17:25.074Z | 2024-11-04T14:29:01.830Z |
5409336 | 5409336 | 20241027041119_jU0ix | UK005G | 2024-10-29T12:17:16.824Z | 2024-11-04T14:29:01.588Z |
5409317 | 5409317 | 20241027041050_KcRo2 | UK005G | 2024-10-29T12:17:16.302Z | 2024-11-04T14:29:01.518Z |
5409296 | 5409296 | 20241027041019_PAQMx | UK005G | 2024-10-29T12:17:15.280Z | 2024-11-04T14:29:01.495Z |
5409244 | 5409244 | 20241027040710_iXP1J | UK005G | 2024-10-29T12:17:13.998Z | 2024-11-04T14:29:01.423Z |
5408295 | 5408295 | 20241027032206_Zsote | UK005G | 2024-10-29T12:16:21.326Z | 2024-11-04T14:28:59.067Z |
5408285 | 5408285 | 20241027032126_NTzP5 | UK005G | 2024-10-29T12:16:20.975Z | 2024-11-04T14:28:59.055Z |
5408224 | 5408224 | 20241027031714_m04iw | UK005G | 2024-10-29T12:16:17.952Z | 2024-11-04T14:28:59.010Z |
5408047 | 5408047 | 20241027030455_2FlrU | UK005G | 2024-10-29T12:16:02.821Z | 2024-11-04T14:28:58.743Z |
5407891 | 5407891 | 20241027025702_sDJt4 | UK005G | 2024-10-29T12:15:50.900Z | 2024-11-04T14:28:58.306Z |
5407446 | 5407446 | 20241027023705_f6jLH | UK005G | 2024-10-29T12:15:24.945Z | 2024-11-04T14:28:57.582Z |
5407088 | 5407088 | 20241027022148_6zXmV | UK005G | 2024-10-29T12:15:12.001Z | 2024-11-04T14:28:56.842Z |
5404525 | 5404525 | 20241026233423_43tt7 | UK005G | 2024-10-29T12:11:40.873Z | 2024-11-04T14:28:51.294Z |
5403949 | 5403949 | 20241026224815_POq5j | UK005G | 2024-10-29T12:10:36.195Z | 2024-11-04T14:28:50.071Z |
5403827 | 5403827 | 20241026223441_2udXN | UK005G | 2024-10-29T12:10:17.024Z | 2024-11-04T14:28:49.835Z |
5403795 | 5403795 | 20241026223214_GHj0r | UK005G | 2024-10-29T12:10:14.241Z | 2024-11-04T14:28:49.743Z |
5403148 | 5403148 | 20241026212355_WraZH | UK005G | 2024-10-29T12:09:06.268Z | 2024-11-04T14:28:47.868Z |
5402461 | 5402461 | 20241026193937_lb3Oc | UK005G | 2024-10-29T12:07:21.063Z | 2024-11-04T14:28:44.682Z |
5399500 | 5399500 | 20241026042902_PL2t4 | UK005G | 2024-10-28T12:20:01.173Z | 2024-11-03T14:27:39.878Z |
5399445 | 5399445 | 20241026041841_xDpik | UK005G | 2024-10-28T12:19:59.745Z | 2024-11-03T14:27:39.733Z |
5399411 | 5399411 | 20241026041555_liYDh | UK005G | 2024-10-28T12:19:58.541Z | 2024-11-03T14:27:39.656Z |
5399296 | 5399296 | 20241026040914_uoC5V | UK005G | 2024-10-28T12:19:53.561Z | 2024-11-03T14:27:39.350Z |
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);