participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,887 rows where station_code = "UK006B" 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 |
---|---|---|---|---|---|
5565265 | 5565265 | 20241120040847_2Crxx | UK006B | 2024-11-21T14:18:44.082Z | 2024-11-21T14:18:54.182Z |
5564998 | 5564998 | 20241120034414_un24h | UK006B | 2024-11-21T14:18:18.614Z | 2024-11-21T14:18:54.137Z |
5564333 | 5564333 | 20241120024857_Cm9Kb | UK006B | 2024-11-21T14:17:27.701Z | 2024-11-21T14:18:54.025Z |
5563882 | 5563882 | 20241120021216_RHPRj | UK006B | 2024-11-21T14:16:53.430Z | 2024-11-21T14:18:53.937Z |
5563714 | 5563714 | 20241120015944_DpvME | UK006B | 2024-11-21T14:16:35.920Z | 2024-11-21T14:18:53.904Z |
5562862 | 5562862 | 20241120002143_kbM5L | UK006B | 2024-11-21T14:15:25.685Z | 2024-11-21T14:18:53.752Z |
5562659 | 5562659 | 20241120000233_QSrEj | UK006B | 2024-11-21T14:15:15.893Z | 2024-11-21T14:18:53.717Z |
5562651 | 5562651 | 20241120000143_VrNaM | UK006B | 2024-11-21T14:15:15.500Z | 2024-11-21T14:18:53.716Z |
5562577 | 5562577 | 20241119235306_Nak4W | UK006B | 2024-11-21T14:15:10.815Z | 2024-11-21T14:18:53.705Z |
5561632 | 5561632 | 20241119212216_dUmiL | UK006B | 2024-11-21T14:13:38.433Z | 2024-11-21T14:18:53.552Z |
5558454 | 5558454 | 20241120060604_DhdoA | UK006B | 2024-11-21T14:03:18.024Z | 2024-11-21T14:03:18.024Z |
5558451 | 5558451 | 20241120060552_0RyG1 | UK006B | 2024-11-21T14:03:17.251Z | 2024-11-21T14:03:17.251Z |
5558409 | 5558409 | 20241120060228_5NrA2 | UK006B | 2024-11-21T14:03:13.120Z | 2024-11-21T14:03:13.120Z |
5558396 | 5558396 | 20241120060146_j6u2x | UK006B | 2024-11-21T14:03:11.314Z | 2024-11-21T14:03:11.314Z |
5545628 | 5545628 | 20241117054910_Y6j01 | UK006B | 2024-11-18T14:00:29.935Z | 2024-11-21T14:20:55.463Z |
5537807 | 5537807 | 20241113004435_F29Gk | UK006B | 2024-11-14T14:12:31.307Z | 2024-11-21T14:26:16.346Z |
5532031 | 5532031 | 20241112042949_8TC83 | UK006B | 2024-11-13T14:16:11.580Z | 2024-11-20T14:26:17.637Z |
5529756 | 5529756 | 20241112010220_38bUj | UK006B | 2024-11-13T14:13:09.320Z | 2024-11-20T14:25:47.933Z |
5529742 | 5529742 | 20241112010120_YqAhD | UK006B | 2024-11-13T14:13:08.719Z | 2024-11-20T14:25:47.888Z |
5529733 | 5529733 | 20241112010052_l63wZ | UK006B | 2024-11-13T14:13:08.343Z | 2024-11-20T14:25:47.839Z |
5529337 | 5529337 | 20241112000411_g3mWa | UK006B | 2024-11-13T14:12:23.393Z | 2024-11-20T14:25:42.972Z |
5529301 | 5529301 | 20241111235836_WJUII | UK006B | 2024-11-13T14:12:20.735Z | 2024-11-20T14:25:42.639Z |
5529247 | 5529247 | 20241111235427_iJnx8 | UK006B | 2024-11-13T14:12:15.923Z | 2024-11-20T14:25:42.216Z |
5528978 | 5528978 | 20241111231447_IIVBr | UK006B | 2024-11-13T14:11:53.819Z | 2024-11-20T14:25:38.297Z |
5528827 | 5528827 | 20241111224803_LGUof | UK006B | 2024-11-13T14:11:28.652Z | 2024-11-20T14:25:36.402Z |
5524641 | 5524641 | 20241111045414_goW2e | UK006B | 2024-11-12T14:17:49.874Z | 2024-11-19T14:22:23.111Z |
5524598 | 5524598 | 20241111044446_6rMFC | UK006B | 2024-11-12T14:17:44.955Z | 2024-11-19T14:22:22.711Z |
5524395 | 5524395 | 20241111040740_QF39l | UK006B | 2024-11-12T14:17:15.170Z | 2024-11-19T14:22:20.960Z |
5524338 | 5524338 | 20241111035756_huQ5j | UK006B | 2024-11-12T14:17:03.817Z | 2024-11-19T14:22:20.263Z |
5524263 | 5524263 | 20241111034207_iV5pT | UK006B | 2024-11-12T14:16:52.760Z | 2024-11-19T14:22:19.285Z |
5524239 | 5524239 | 20241111033800_wH1B8 | UK006B | 2024-11-12T14:16:50.203Z | 2024-11-19T14:22:19.128Z |
5524183 | 5524183 | 20241111032427_lWR5k | UK006B | 2024-11-12T14:16:42.129Z | 2024-11-19T14:22:17.847Z |
5524123 | 5524123 | 20241111031710_X3Wml | UK006B | 2024-11-12T14:16:34.597Z | 2024-11-19T14:22:17.475Z |
5524001 | 5524001 | 20241111030109_zKSRD | UK006B | 2024-11-12T14:16:25.542Z | 2024-11-19T14:22:16.488Z |
5523950 | 5523950 | 20241111025351_EYSdz | UK006B | 2024-11-12T14:16:22.091Z | 2024-11-19T14:22:16.102Z |
5523919 | 5523919 | 20241111024740_bqdrR | UK006B | 2024-11-12T14:16:20.595Z | 2024-11-19T14:22:15.902Z |
5441886 | 5441886 | 20241029235607_GfAsF | UK006B | 2024-11-01T12:19:11.146Z | 2024-11-07T14:26:44.231Z |
5441686 | 5441686 | 20241029231033_zoQCL | UK006B | 2024-11-01T12:18:52.973Z | 2024-11-07T14:26:42.995Z |
5441614 | 5441614 | 20241029225045_1BHJl | UK006B | 2024-11-01T12:18:47.912Z | 2024-11-07T14:26:42.752Z |
5441529 | 5441529 | 20241029223132_lpjfL | UK006B | 2024-11-01T12:18:42.945Z | 2024-11-07T14:26:42.615Z |
5441329 | 5441329 | 20241029214306_w3mEN | UK006B | 2024-11-01T12:18:26.469Z | 2024-11-07T14:26:41.722Z |
5441239 | 5441239 | 20241029211820_bMcvI | UK006B | 2024-11-01T12:18:20.749Z | 2024-11-07T14:26:41.357Z |
5433648 | 5433648 | 20241029203618_4yN3D | UK006B | 2024-10-31T12:22:26.106Z | 2024-11-07T14:26:40.486Z |
5433451 | 5433451 | 20241029200007_RdE4V | UK006B | 2024-10-31T12:22:16.541Z | 2024-11-07T14:26:39.654Z |
5422998 | 5422998 | 20241027033453_49xrV | UK006B | 2024-10-30T12:22:58.298Z | 2024-11-04T14:28:59.809Z |
5410191 | 5410191 | 20241027045924_nrQwp | UK006B | 2024-10-29T12:17:50.511Z | 2024-11-04T14:29:04.035Z |
5410115 | 5410115 | 20241027045423_jYoi2 | UK006B | 2024-10-29T12:17:48.284Z | 2024-11-04T14:29:03.794Z |
5409970 | 5409970 | 20241027044630_VpkuQ | UK006B | 2024-10-29T12:17:45.189Z | 2024-11-04T14:29:03.165Z |
5409861 | 5409861 | 20241027043845_IEzAP | UK006B | 2024-10-29T12:17:42.495Z | 2024-11-04T14:29:02.822Z |
5409826 | 5409826 | 20241027043718_TPpRm | UK006B | 2024-10-29T12:17:41.961Z | 2024-11-04T14:29:02.773Z |
5409755 | 5409755 | 20241027043416_YLCoo | UK006B | 2024-10-29T12:17:40.250Z | 2024-11-04T14:29:02.617Z |
5409619 | 5409619 | 20241027042822_BqxLZ | UK006B | 2024-10-29T12:17:33.873Z | 2024-11-04T14:29:02.017Z |
5409528 | 5409528 | 20241027042329_wiHUZ | UK006B | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5409457 | 5409457 | 20241027041930_hQEPn | UK006B | 2024-10-29T12:17:25.074Z | 2024-11-04T14:29:01.830Z |
5409425 | 5409425 | 20241027041722_Iz5YN | UK006B | 2024-10-29T12:17:22.888Z | 2024-11-04T14:29:01.729Z |
5408838 | 5408838 | 20241027034524_MdEft | UK006B | 2024-10-29T12:16:54.655Z | 2024-11-04T14:29:00.616Z |
5408677 | 5408677 | 20241027033613_0V4hV | UK006B | 2024-10-29T12:16:44.859Z | 2024-11-04T14:29:00.301Z |
5408648 | 5408648 | 20241027033423_U9diu | UK006B | 2024-10-29T12:16:42.188Z | 2024-11-04T14:28:59.776Z |
5408218 | 5408218 | 20241027031655_u4K2R | UK006B | 2024-10-29T12:16:17.424Z | 2024-11-04T14:28:58.999Z |
5408070 | 5408070 | 20241027030532_rtsX5 | UK006B | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5407844 | 5407844 | 20241027025517_nXNAb | UK006B | 2024-10-29T12:15:48.501Z | 2024-11-04T14:28:58.242Z |
5407747 | 5407747 | 20241027025023_O1W3U | UK006B | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.092Z |
5407258 | 5407258 | 20241027022841_QfjO2 | UK006B | 2024-10-29T12:15:19.103Z | 2024-11-04T14:28:57.274Z |
5406951 | 5406951 | 20241027021252_Iw03g | UK006B | 2024-10-29T12:15:02.586Z | 2024-11-04T14:28:56.728Z |
5406698 | 5406698 | 20241027015528_SZFYe | UK006B | 2024-10-29T12:14:33.158Z | 2024-11-04T14:28:56.043Z |
5406453 | 5406453 | 20241027013824_kkpkl | UK006B | 2024-10-29T12:14:10.696Z | 2024-11-04T14:28:55.715Z |
5405974 | 5405974 | 20241027011126_7gWv5 | UK006B | 2024-10-29T12:13:42.790Z | 2024-11-04T14:28:54.803Z |
5405928 | 5405928 | 20241027010849_WtxI4 | UK006B | 2024-10-29T12:13:34.531Z | 2024-11-04T14:28:54.620Z |
5405727 | 5405727 | 20241027005443_3f52Q | UK006B | 2024-10-29T12:13:10.863Z | 2024-11-04T14:28:54.119Z |
5405693 | 5405693 | 20241027005351_oqV7D | UK006B | 2024-10-29T12:13:09.984Z | 2024-11-04T14:28:53.917Z |
5405682 | 5405682 | 20241027005316_bssPK | UK006B | 2024-10-29T12:13:09.536Z | 2024-11-04T14:28:53.898Z |
5405673 | 5405673 | 20241027005237_6cjxi | UK006B | 2024-10-29T12:13:09.047Z | 2024-11-04T14:28:53.887Z |
5405422 | 5405422 | 20241027003309_mIghY | UK006B | 2024-10-29T12:12:55.159Z | 2024-11-04T14:28:53.464Z |
5405036 | 5405036 | 20241027001001_5ODqS | UK006B | 2024-10-29T12:12:19.052Z | 2024-11-04T14:28:52.615Z |
5404955 | 5404955 | 20241027000250_hZG38 | UK006B | 2024-10-29T12:12:10.720Z | 2024-11-04T14:28:52.451Z |
5404909 | 5404909 | 20241027000030_kqAoN | UK006B | 2024-10-29T12:12:06.753Z | 2024-11-04T14:28:52.402Z |
5404628 | 5404628 | 20241026234105_8I0kh | UK006B | 2024-10-29T12:11:47.007Z | 2024-11-04T14:28:51.446Z |
5404465 | 5404465 | 20241026232939_9d72X | UK006B | 2024-10-29T12:11:31.528Z | 2024-11-04T14:28:51.080Z |
5404086 | 5404086 | 20241026225640_Mx9Bw | UK006B | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5403669 | 5403669 | 20241026222240_C47Zp | UK006B | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403433 | 5403433 | 20241026215616_gM3Z8 | UK006B | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403345 | 5403345 | 20241026214332_3Ty5J | UK006B | 2024-10-29T12:09:23.415Z | 2024-11-04T14:28:48.440Z |
5402980 | 5402980 | 20241026205724_0uW0d | UK006B | 2024-10-29T12:08:42.014Z | 2024-11-04T14:28:47.254Z |
5402013 | 5402013 | 20241026182437_Npo1r | UK006B | 2024-10-29T12:06:04.045Z | 2024-11-04T14:28:41.575Z |
5399933 | 5399933 | 20241026051344_tLaUs | UK006B | 2024-10-28T12:20:17.143Z | 2024-11-03T14:27:40.871Z |
5399778 | 5399778 | 20241026050210_q3etH | UK006B | 2024-10-28T12:20:10.902Z | 2024-11-03T14:27:40.493Z |
5399750 | 5399750 | 20241026045922_Yn5dP | UK006B | 2024-10-28T12:20:10.092Z | 2024-11-03T14:27:40.420Z |
5399642 | 5399642 | 20241026044418_1ORQT | UK006B | 2024-10-28T12:20:04.600Z | 2024-11-03T14:27:40.159Z |
5399515 | 5399515 | 20241026043056_RzaNs | UK006B | 2024-10-28T12:20:01.428Z | 2024-11-03T14:27:39.902Z |
5399412 | 5399412 | 20241026041555_liYDh | UK006B | 2024-10-28T12:19:58.541Z | 2024-11-03T14:27:39.656Z |
5399354 | 5399354 | 20241026041145_Q3JZ0 | UK006B | 2024-10-28T12:19:55.694Z | 2024-11-03T14:27:39.537Z |
5399346 | 5399346 | 20241026041141_BepxY | UK006B | 2024-10-28T12:19:55.373Z | 2024-11-03T14:27:39.527Z |
5399297 | 5399297 | 20241026040914_uoC5V | UK006B | 2024-10-28T12:19:53.561Z | 2024-11-03T14:27:39.350Z |
5399237 | 5399237 | 20241026040412_FjTZg | UK006B | 2024-10-28T12:19:52.306Z | 2024-11-03T14:27:39.275Z |
5399081 | 5399081 | 20241026034919_IsFTH | UK006B | 2024-10-28T12:19:48.143Z | 2024-11-03T14:27:39.008Z |
5399069 | 5399069 | 20241026034824_qfmVA | UK006B | 2024-10-28T12:19:47.164Z | 2024-11-03T14:27:38.960Z |
5399000 | 5399000 | 20241026034411_4L5Kh | UK006B | 2024-10-28T12:19:44.002Z | 2024-11-03T14:27:38.857Z |
5398995 | 5398995 | 20241026034411_0wBnx | UK006B | 2024-10-28T12:19:43.957Z | 2024-11-03T14:27:38.856Z |
5398829 | 5398829 | 20241026033159_tE9sf | UK006B | 2024-10-28T12:19:35.734Z | 2024-11-03T14:27:38.273Z |
5398714 | 5398714 | 20241026032144_Fl0F8 | UK006B | 2024-10-28T12:19:29.484Z | 2024-11-03T14:27:37.888Z |
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);