participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,264 rows where station_code = "UK003V" 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 |
---|---|---|---|---|---|
5421188 | 5421188 | 20241028050212_Dor6U | UK003V | 2024-10-30T12:19:41.116Z | 2024-11-05T14:27:17.698Z |
5410695 | 5410695 | 20241027052903_M1m7L | UK003V | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5410487 | 5410487 | 20241027051501_HxJlR | UK003V | 2024-10-29T12:17:56.913Z | 2024-11-04T14:29:04.646Z |
5409153 | 5409153 | 20241027040324_piW2n | UK003V | 2024-10-29T12:17:09.260Z | 2024-11-04T14:29:01.228Z |
5409035 | 5409035 | 20241027035615_DQS0F | UK003V | 2024-10-29T12:17:02.070Z | 2024-11-04T14:29:00.952Z |
5408967 | 5408967 | 20241027035141_O3X66 | UK003V | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408605 | 5408605 | 20241027033204_cQPv8 | UK003V | 2024-10-29T12:16:39.108Z | 2024-11-04T14:28:59.674Z |
5408561 | 5408561 | 20241027033030_vnuBv | UK003V | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5407439 | 5407439 | 20241027023700_3iYrH | UK003V | 2024-10-29T12:15:24.742Z | 2024-11-04T14:28:57.570Z |
5406982 | 5406982 | 20241027021544_5IMa5 | UK003V | 2024-10-29T12:15:04.259Z | 2024-11-04T14:28:56.748Z |
5406521 | 5406521 | 20241027014237_CZ3Fi | UK003V | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5405822 | 5405822 | 20241027010123_llt5F | UK003V | 2024-10-29T12:13:20.070Z | 2024-11-04T14:28:54.406Z |
5405648 | 5405648 | 20241027005213_mQwjZ | UK003V | 2024-10-29T12:13:07.403Z | 2024-11-04T14:28:53.747Z |
5402049 | 5402049 | 20241026183503_zAyMj | UK003V | 2024-10-29T12:06:10.572Z | 2024-11-04T14:28:41.855Z |
5400074 | 5400074 | 20241026053607_D5Hb6 | UK003V | 2024-10-28T12:20:21.764Z | 2024-11-03T14:27:41.266Z |
5399981 | 5399981 | 20241026051859_o7xBp | UK003V | 2024-10-28T12:20:18.080Z | 2024-11-03T14:27:40.945Z |
5399966 | 5399966 | 20241026051807_R1307 | UK003V | 2024-10-28T12:20:17.648Z | 2024-11-03T14:27:40.899Z |
5399783 | 5399783 | 20241026050217_EV6q3 | UK003V | 2024-10-28T12:20:11.091Z | 2024-11-03T14:27:40.510Z |
5399767 | 5399767 | 20241026050042_xy1sv | UK003V | 2024-10-28T12:20:10.595Z | 2024-11-03T14:27:40.484Z |
5399669 | 5399669 | 20241026044705_5Z03f | UK003V | 2024-10-28T12:20:05.637Z | 2024-11-03T14:27:40.216Z |
5399540 | 5399540 | 20241026043330_T2J2E | UK003V | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399339 | 5399339 | 20241026041140_R376e | UK003V | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399217 | 5399217 | 20241026040219_cdA3y | UK003V | 2024-10-28T12:19:51.594Z | 2024-11-03T14:27:39.253Z |
5399045 | 5399045 | 20241026034658_XAPTn | UK003V | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5398754 | 5398754 | 20241026032600_aDLHv | UK003V | 2024-10-28T12:19:31.368Z | 2024-11-03T14:27:37.986Z |
5398746 | 5398746 | 20241026032516_wFRR8 | UK003V | 2024-10-28T12:19:30.214Z | 2024-11-03T14:27:37.966Z |
5398740 | 5398740 | 20241026032349_hdf7j | UK003V | 2024-10-28T12:19:30.069Z | 2024-11-03T14:27:37.942Z |
5398723 | 5398723 | 20241026032150_7NVzB | UK003V | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
5398687 | 5398687 | 20241026031900_tYto2 | UK003V | 2024-10-28T12:19:28.487Z | 2024-11-03T14:27:37.732Z |
5397508 | 5397508 | 20241026013556_PAgLj | UK003V | 2024-10-28T12:18:25.871Z | 2024-11-03T14:27:33.292Z |
5397471 | 5397471 | 20241026013248_pQQM4 | UK003V | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397448 | 5397448 | 20241026013125_od88K | UK003V | 2024-10-28T12:18:23.018Z | 2024-11-03T14:27:33.026Z |
5397279 | 5397279 | 20241026011458_kUCHK | UK003V | 2024-10-28T12:18:14.217Z | 2024-11-03T14:27:32.511Z |
5396494 | 5396494 | 20241026000809_cadJN | UK003V | 2024-10-28T12:17:47.224Z | 2024-11-03T14:27:30.018Z |
5396353 | 5396353 | 20241025235919_BiiW2 | UK003V | 2024-10-28T12:17:35.937Z | 2024-11-03T14:27:29.621Z |
5396011 | 5396011 | 20241025232940_rxr35 | UK003V | 2024-10-28T12:17:12.246Z | 2024-11-03T14:27:28.039Z |
5384846 | 5384846 | 20241024210324_0pQ2Q | UK003V | 2024-10-27T12:17:49.466Z | 2024-11-02T12:28:28.456Z |
5384657 | 5384657 | 20241024203347_PTgnd | UK003V | 2024-10-27T12:17:24.487Z | 2024-11-02T12:28:27.576Z |
5384193 | 5384193 | 20241024194517_39uSn | UK003V | 2024-10-27T12:16:51.527Z | 2024-11-02T12:28:26.828Z |
5378282 | 5378282 | 20241024054953_o5nwl | UK003V | 2024-10-26T12:22:59.383Z | 2024-11-01T12:27:03.705Z |
5378159 | 5378159 | 20241024053337_p3pi0 | UK003V | 2024-10-26T12:22:56.662Z | 2024-11-01T12:27:03.333Z |
5378100 | 5378100 | 20241024052715_BEwzo | UK003V | 2024-10-26T12:22:54.459Z | 2024-11-01T12:27:03.283Z |
5377944 | 5377944 | 20241024051818_jgq2t | UK003V | 2024-10-26T12:22:50.579Z | 2024-11-01T12:27:03.184Z |
5377641 | 5377641 | 20241024050148_gwgbN | UK003V | 2024-10-26T12:22:43.045Z | 2024-11-01T12:27:02.691Z |
5376915 | 5376915 | 20241024042230_vGSWW | UK003V | 2024-10-26T12:22:16.804Z | 2024-11-01T12:27:01.916Z |
5376302 | 5376302 | 20241024035030_pLWSq | UK003V | 2024-10-26T12:21:56.015Z | 2024-11-01T12:27:01.488Z |
5375978 | 5375978 | 20241024033706_gnf9l | UK003V | 2024-10-26T12:21:45.561Z | 2024-11-01T12:27:01.302Z |
5375888 | 5375888 | 20241024033505_K4kKv | UK003V | 2024-10-26T12:21:43.317Z | 2024-11-01T12:27:01.249Z |
5375541 | 5375541 | 20241024031937_7wDJY | UK003V | 2024-10-26T12:21:31.052Z | 2024-11-01T12:27:00.771Z |
5375385 | 5375385 | 20241024031118_Tuh6M | UK003V | 2024-10-26T12:21:23.331Z | 2024-11-01T12:27:00.660Z |
5375151 | 5375151 | 20241024025952_Yzi8m | UK003V | 2024-10-26T12:21:14.525Z | 2024-11-01T12:27:00.306Z |
5375008 | 5375008 | 20241024025230_p5XVt | UK003V | 2024-10-26T12:21:09.642Z | 2024-11-01T12:27:00.113Z |
5374988 | 5374988 | 20241024025209_9NBxw | UK003V | 2024-10-26T12:21:08.973Z | 2024-11-01T12:27:00.108Z |
5374888 | 5374888 | 20241024024826_uGHrz | UK003V | 2024-10-26T12:21:05.215Z | 2024-11-01T12:27:00.029Z |
5374765 | 5374765 | 20241024024302_HFeeo | UK003V | 2024-10-26T12:21:00.615Z | 2024-11-01T12:26:59.591Z |
5374431 | 5374431 | 20241024022649_6CLTw | UK003V | 2024-10-26T12:20:48.459Z | 2024-11-01T12:26:59.366Z |
5374342 | 5374342 | 20241024022310_jJ1Fx | UK003V | 2024-10-26T12:20:45.600Z | 2024-11-01T12:26:58.853Z |
5374185 | 5374185 | 20241024021501_JAZSH | UK003V | 2024-10-26T12:20:38.822Z | 2024-11-01T12:26:58.751Z |
5374152 | 5374152 | 20241024021219_I935R | UK003V | 2024-10-26T12:20:38.016Z | 2024-11-01T12:26:58.712Z |
5374085 | 5374085 | 20241024020854_Nx0r1 | UK003V | 2024-10-26T12:20:36.697Z | 2024-11-01T12:26:58.692Z |
5373979 | 5373979 | 20241024020350_qtHvP | UK003V | 2024-10-26T12:20:33.154Z | 2024-11-01T12:26:58.617Z |
5373925 | 5373925 | 20241024020010_gLiO1 | UK003V | 2024-10-26T12:20:31.153Z | 2024-11-01T12:26:58.572Z |
5373861 | 5373861 | 20241024015725_lIvsZ | UK003V | 2024-10-26T12:20:28.276Z | 2024-11-01T12:26:58.538Z |
5373820 | 5373820 | 20241024015529_329cv | UK003V | 2024-10-26T12:20:26.712Z | 2024-11-01T12:26:58.506Z |
5373581 | 5373581 | 20241024014525_MxnH2 | UK003V | 2024-10-26T12:20:17.678Z | 2024-11-01T12:26:58.332Z |
5373568 | 5373568 | 20241024014445_0gNP0 | UK003V | 2024-10-26T12:20:17.021Z | 2024-11-01T12:26:58.328Z |
5373372 | 5373372 | 20241024013455_qI20o | UK003V | 2024-10-26T12:20:09.044Z | 2024-11-01T12:26:58.236Z |
5373064 | 5373064 | 20241024012218_YgEIG | UK003V | 2024-10-26T12:19:55.669Z | 2024-11-01T12:26:58.110Z |
5372609 | 5372609 | 20241024005733_1W7jP | UK003V | 2024-10-26T12:19:33.072Z | 2024-11-01T12:26:57.750Z |
5372523 | 5372523 | 20241024005245_eMqpt | UK003V | 2024-10-26T12:19:28.930Z | 2024-11-01T12:26:57.503Z |
5372459 | 5372459 | 20241024004914_IdDKK | UK003V | 2024-10-26T12:19:25.612Z | 2024-11-01T12:26:57.464Z |
5372401 | 5372401 | 20241024004650_JmVe2 | UK003V | 2024-10-26T12:19:23.370Z | 2024-11-01T12:26:57.432Z |
5372323 | 5372323 | 20241024004438_2t5jw | UK003V | 2024-10-26T12:19:20.515Z | 2024-11-01T12:26:57.393Z |
5372299 | 5372299 | 20241024004252_L5clr | UK003V | 2024-10-26T12:19:18.901Z | 2024-11-01T12:26:57.370Z |
5372172 | 5372172 | 20241024003602_Uq2rz | UK003V | 2024-10-26T12:19:12.418Z | 2024-11-01T12:26:57.189Z |
5372124 | 5372124 | 20241024003346_V7ll4 | UK003V | 2024-10-26T12:19:10.457Z | 2024-11-01T12:26:57.154Z |
5371917 | 5371917 | 20241024002326_vhYNi | UK003V | 2024-10-26T12:18:58.096Z | 2024-11-01T12:26:57.000Z |
5371914 | 5371914 | 20241024002308_MRPgj | UK003V | 2024-10-26T12:18:57.954Z | 2024-11-01T12:26:56.999Z |
5365786 | 5365786 | 20241023234937_F5n1X | UK003V | 2024-10-25T12:18:07.670Z | 2024-11-01T12:26:56.413Z |
5365763 | 5365763 | 20241023234759_gUr3m | UK003V | 2024-10-25T12:18:07.393Z | 2024-11-01T12:26:56.400Z |
5365613 | 5365613 | 20241023234106_2EpIz | UK003V | 2024-10-25T12:18:03.112Z | 2024-11-01T12:26:56.290Z |
5365604 | 5365604 | 20241023233942_7LjrD | UK003V | 2024-10-25T12:18:02.938Z | 2024-11-01T12:26:56.276Z |
5365592 | 5365592 | 20241023233849_V4V2f | UK003V | 2024-10-25T12:18:02.333Z | 2024-11-01T12:26:56.266Z |
5365575 | 5365575 | 20241023233824_IXe5Y | UK003V | 2024-10-25T12:18:01.732Z | 2024-11-01T12:26:56.238Z |
5365242 | 5365242 | 20241023232215_TjniV | UK003V | 2024-10-25T12:17:52.040Z | 2024-11-01T12:26:55.990Z |
5364351 | 5364351 | 20241023222250_YZnvj | UK003V | 2024-10-25T12:17:17.713Z | 2024-11-01T12:26:54.703Z |
5364316 | 5364316 | 20241023222024_1SEWe | UK003V | 2024-10-25T12:17:16.732Z | 2024-11-01T12:26:54.673Z |
5363857 | 5363857 | 20241023215256_osM0r | UK003V | 2024-10-25T12:16:55.440Z | 2024-11-01T12:26:53.897Z |
5363526 | 5363526 | 20241023211640_z6uzg | UK003V | 2024-10-25T12:16:20.305Z | 2024-11-01T12:26:53.349Z |
5363273 | 5363273 | 20241023204211_WVDUy | UK003V | 2024-10-25T12:15:50.099Z | 2024-11-01T12:26:53.014Z |
5363263 | 5363263 | 20241023204044_aP4ZA | UK003V | 2024-10-25T12:15:49.053Z | 2024-11-01T12:26:53.011Z |
5356182 | 5356182 | 20241023051233_RG0XD | UK003V | 2024-10-24T12:21:55.036Z | 2024-10-31T12:30:10.771Z |
5356107 | 5356107 | 20241023045918_A1CzZ | UK003V | 2024-10-24T12:21:52.615Z | 2024-10-31T12:30:10.426Z |
5355777 | 5355777 | 20241023041432_vvJKw | UK003V | 2024-10-24T12:21:36.336Z | 2024-10-31T12:30:08.824Z |
5355570 | 5355570 | 20241023035158_chn5i | UK003V | 2024-10-24T12:21:26.549Z | 2024-10-31T12:30:08.074Z |
5355505 | 5355505 | 20241023034630_XQI4S | UK003V | 2024-10-24T12:21:24.045Z | 2024-10-31T12:30:07.894Z |
5355208 | 5355208 | 20241023032209_ZL9Yt | UK003V | 2024-10-24T12:21:10.336Z | 2024-10-31T12:30:07.381Z |
5355193 | 5355193 | 20241023032127_BbwKY | UK003V | 2024-10-24T12:21:10.148Z | 2024-10-31T12:30:07.375Z |
5355180 | 5355180 | 20241023032034_zjo3S | UK003V | 2024-10-24T12:21:09.520Z | 2024-10-31T12:30:07.367Z |
5355105 | 5355105 | 20241023031451_oIjCE | UK003V | 2024-10-24T12:21:05.941Z | 2024-10-31T12:30:07.281Z |
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);