participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,394 rows where station_code = "UK00AJ" 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 |
---|---|---|---|---|---|
5254750 | 5254750 | 20241007025337_W3GP7 | UK00AJ | 2024-10-08T12:14:45.047Z | 2024-10-15T12:29:16.973Z |
5254640 | 5254640 | 20241007023703_RI7kY | UK00AJ | 2024-10-08T12:14:36.945Z | 2024-10-15T12:29:16.461Z |
5254600 | 5254600 | 20241007023226_a8zaW | UK00AJ | 2024-10-08T12:14:35.080Z | 2024-10-15T12:29:16.366Z |
5254512 | 5254512 | 20241007022256_hUNM8 | UK00AJ | 2024-10-08T12:14:29.440Z | 2024-10-15T12:29:16.052Z |
5254431 | 5254431 | 20241007021034_CzqTi | UK00AJ | 2024-10-08T12:14:25.218Z | 2024-10-15T12:29:15.360Z |
5254410 | 5254410 | 20241007020908_oV67V | UK00AJ | 2024-10-08T12:14:24.361Z | 2024-10-15T12:29:15.334Z |
5253814 | 5253814 | 20241007004837_umj8t | UK00AJ | 2024-10-08T12:13:43.211Z | 2024-10-15T12:29:11.122Z |
5253363 | 5253363 | 20241006233929_MdBK8 | UK00AJ | 2024-10-08T12:13:09.766Z | 2024-10-15T12:29:08.997Z |
5253182 | 5253182 | 20241006230251_bfoUC | UK00AJ | 2024-10-08T12:13:00.442Z | 2024-10-15T12:29:07.758Z |
5247908 | 5247908 | 20241007032859_OZnn9 | UK00AJ | 2024-10-08T12:01:00.565Z | 2024-10-16T12:20:57.242Z |
5247578 | 5247578 | 20241005021455_gta43 | UK00AJ | 2024-10-07T12:18:56.562Z | 2024-10-13T12:26:26.467Z |
5240164 | 5240164 | 20241005051850_OxhpA | UK00AJ | 2024-10-07T12:07:45.769Z | 2024-10-14T12:24:21.235Z |
5240141 | 5240141 | 20241005050632_3l6rG | UK00AJ | 2024-10-07T12:07:43.971Z | 2024-10-14T12:24:21.206Z |
5240120 | 5240120 | 20241005050248_HiLe2 | UK00AJ | 2024-10-07T12:07:42.424Z | 2024-10-14T12:24:21.186Z |
5240108 | 5240108 | 20241005050149_Zl4Fu | UK00AJ | 2024-10-07T12:07:41.811Z | 2024-10-14T12:24:21.184Z |
5239928 | 5239928 | 20241005043937_7Gg7J | UK00AJ | 2024-10-07T12:07:21.572Z | 2024-10-14T12:24:20.999Z |
5239187 | 5239187 | 20241005033804_TBkzp | UK00AJ | 2024-10-07T12:06:04.881Z | 2024-10-14T12:24:18.628Z |
5238593 | 5238593 | 20241005024450_MHQ6q | UK00AJ | 2024-10-07T12:04:43.267Z | 2024-10-14T12:24:16.859Z |
5235390 | 5235390 | 20241004232811_Bg92F | UK00AJ | 2024-10-06T12:16:02.847Z | 2024-10-13T12:26:24.187Z |
5235078 | 5235078 | 20241004225033_2QFPF | UK00AJ | 2024-10-06T12:15:49.079Z | 2024-10-13T12:26:23.480Z |
5234959 | 5234959 | 20241004223630_r7uHI | UK00AJ | 2024-10-06T12:15:43.432Z | 2024-10-13T12:26:23.198Z |
5234825 | 5234825 | 20241004221845_iJoC3 | UK00AJ | 2024-10-06T12:15:23.870Z | 2024-10-13T12:26:22.836Z |
5227666 | 5227666 | 20241004013636_08iJC | UK00AJ | 2024-10-05T12:21:37.014Z | 2024-10-12T12:25:12.903Z |
5227640 | 5227640 | 20241004013428_OXJXf | UK00AJ | 2024-10-05T12:21:36.547Z | 2024-10-12T12:25:12.885Z |
5227319 | 5227319 | 20241004011630_ICQsU | UK00AJ | 2024-10-05T12:21:24.831Z | 2024-10-12T12:25:12.681Z |
5227073 | 5227073 | 20241004010026_2S3nH | UK00AJ | 2024-10-05T12:21:12.059Z | 2024-10-12T12:25:12.415Z |
5226822 | 5226822 | 20241004004123_Flbfd | UK00AJ | 2024-10-05T12:20:59.843Z | 2024-10-12T12:25:12.116Z |
5226633 | 5226633 | 20241004002721_OC0Im | UK00AJ | 2024-10-05T12:20:51.643Z | 2024-10-12T12:25:11.938Z |
5226526 | 5226526 | 20241004002021_mKsGu | UK00AJ | 2024-10-05T12:20:46.963Z | 2024-10-12T12:25:11.801Z |
5226131 | 5226131 | 20241003234643_5wixv | UK00AJ | 2024-10-05T12:20:29.891Z | 2024-10-12T12:25:11.256Z |
5226104 | 5226104 | 20241003234315_tQuCB | UK00AJ | 2024-10-05T12:20:28.728Z | 2024-10-12T12:25:11.224Z |
5226047 | 5226047 | 20241003233812_aOfOv | UK00AJ | 2024-10-05T12:20:24.913Z | 2024-10-12T12:25:11.130Z |
5226003 | 5226003 | 20241003233644_TgnTN | UK00AJ | 2024-10-05T12:20:22.101Z | 2024-10-12T12:25:11.082Z |
5225783 | 5225783 | 20241003231920_vP3QQ | UK00AJ | 2024-10-05T12:20:09.917Z | 2024-10-12T12:25:10.781Z |
5225287 | 5225287 | 20241003221942_watx1 | UK00AJ | 2024-10-05T12:19:34.157Z | 2024-10-12T12:25:09.791Z |
5225031 | 5225031 | 20241003215355_8WWe8 | UK00AJ | 2024-10-05T12:19:20.583Z | 2024-10-12T12:25:09.513Z |
5224619 | 5224619 | 20241003210342_80u0i | UK00AJ | 2024-10-05T12:18:49.039Z | 2024-10-12T12:25:08.751Z |
5223994 | 5223994 | 20241003195609_xg5bp | UK00AJ | 2024-10-05T12:18:05.699Z | 2024-10-12T12:25:07.159Z |
5223807 | 5223807 | 20241003193235_lnKiJ | UK00AJ | 2024-10-05T12:17:36.186Z | 2024-10-12T12:25:07.024Z |
5219278 | 5219278 | 20241004050528_RsfJe | UK00AJ | 2024-10-05T12:06:28.396Z | 2024-10-13T12:26:10.096Z |
5219208 | 5219208 | 20241004045619_CIxju | UK00AJ | 2024-10-05T12:06:16.994Z | 2024-10-13T12:26:10.035Z |
5219201 | 5219201 | 20241004045542_iaoqj | UK00AJ | 2024-10-05T12:06:16.300Z | 2024-10-13T12:26:09.996Z |
5218889 | 5218889 | 20241004042046_hGjk7 | UK00AJ | 2024-10-05T12:05:34.607Z | 2024-10-13T12:26:09.191Z |
5218407 | 5218407 | 20241004033712_3tjIa | UK00AJ | 2024-10-05T12:04:17.373Z | 2024-10-13T12:26:08.457Z |
5218230 | 5218230 | 20241004032231_kifyc | UK00AJ | 2024-10-05T12:03:50.244Z | 2024-10-13T12:26:08.272Z |
5217938 | 5217938 | 20241004030654_cvA0N | UK00AJ | 2024-10-05T12:02:58.230Z | 2024-10-13T12:26:07.682Z |
5217783 | 5217783 | 20241004025401_LE45g | UK00AJ | 2024-10-05T12:02:33.915Z | 2024-10-13T12:26:07.477Z |
5217740 | 5217740 | 20241004025143_v9KBv | UK00AJ | 2024-10-05T12:02:29.372Z | 2024-10-13T12:26:07.362Z |
5217324 | 5217324 | 20241004021750_qhHLD | UK00AJ | 2024-10-05T12:01:07.660Z | 2024-10-13T12:26:06.769Z |
5217242 | 5217242 | 20241004021413_JAgbw | UK00AJ | 2024-10-05T12:00:58.060Z | 2024-10-13T12:26:06.683Z |
5217117 | 5217117 | 20241004020848_lCy8M | UK00AJ | 2024-10-05T12:00:40.201Z | 2024-10-13T12:26:06.487Z |
5217083 | 5217083 | 20241004020622_cSwwL | UK00AJ | 2024-10-05T12:00:34.365Z | 2024-10-13T12:26:06.432Z |
5216900 | 5216900 | 20241003013411_hLiG4 | UK00AJ | 2024-10-04T12:13:54.289Z | 2024-10-11T12:23:37.894Z |
5216738 | 5216738 | 20241003012040_NBCed | UK00AJ | 2024-10-04T12:13:45.356Z | 2024-10-11T12:23:37.735Z |
5216678 | 5216678 | 20241003011511_BRSGQ | UK00AJ | 2024-10-04T12:13:40.320Z | 2024-10-11T12:23:37.660Z |
5216668 | 5216668 | 20241003011346_X7rtw | UK00AJ | 2024-10-04T12:13:39.077Z | 2024-10-11T12:23:37.643Z |
5216602 | 5216602 | 20241003010933_Wfeyd | UK00AJ | 2024-10-04T12:13:32.861Z | 2024-10-11T12:23:37.530Z |
5216450 | 5216450 | 20241003010020_DlWKh | UK00AJ | 2024-10-04T12:13:16.752Z | 2024-10-11T12:23:37.172Z |
5216433 | 5216433 | 20241003005805_qoS8X | UK00AJ | 2024-10-04T12:13:13.926Z | 2024-10-11T12:23:37.133Z |
5216282 | 5216282 | 20241003004602_F4SLo | UK00AJ | 2024-10-04T12:12:59.540Z | 2024-10-11T12:23:36.723Z |
5216073 | 5216073 | 20241003003216_Erhds | UK00AJ | 2024-10-04T12:12:50.296Z | 2024-10-11T12:23:36.485Z |
5216040 | 5216040 | 20241003003018_0cSoF | UK00AJ | 2024-10-04T12:12:47.973Z | 2024-10-11T12:23:36.425Z |
5215984 | 5215984 | 20241003002511_srquy | UK00AJ | 2024-10-04T12:12:45.438Z | 2024-10-11T12:23:36.354Z |
5215762 | 5215762 | 20241003000207_GEDRk | UK00AJ | 2024-10-04T12:12:26.635Z | 2024-10-11T12:23:36.037Z |
5215669 | 5215669 | 20241002235122_rWzWu | UK00AJ | 2024-10-04T12:12:13.096Z | 2024-10-11T12:23:35.708Z |
5215427 | 5215427 | 20241002232733_2NxLC | UK00AJ | 2024-10-04T12:11:49.697Z | 2024-10-11T12:23:35.346Z |
5215389 | 5215389 | 20241002232243_cyqZu | UK00AJ | 2024-10-04T12:11:47.419Z | 2024-10-11T12:23:35.327Z |
5215383 | 5215383 | 20241002232219_KVUNd | UK00AJ | 2024-10-04T12:11:47.082Z | 2024-10-11T12:23:35.326Z |
5215276 | 5215276 | 20241002231319_fur7b | UK00AJ | 2024-10-04T12:11:40.387Z | 2024-10-11T12:23:35.157Z |
5215196 | 5215196 | 20241002230646_0w6Gj | UK00AJ | 2024-10-04T12:11:34.601Z | 2024-10-11T12:23:35.008Z |
5214555 | 5214555 | 20241002215411_C89Kl | UK00AJ | 2024-10-04T12:10:31.340Z | 2024-10-11T12:23:33.894Z |
5213885 | 5213885 | 20241002201053_HNZlp | UK00AJ | 2024-10-04T12:09:12.315Z | 2024-10-11T12:23:32.307Z |
5213683 | 5213683 | 20241002193635_wFHQS | UK00AJ | 2024-10-04T12:08:50.203Z | 2024-10-11T12:23:31.608Z |
5212855 | 5212855 | 20241003032757_t5d82 | UK00AJ | 2024-10-04T12:03:53.297Z | 2024-10-12T12:24:55.037Z |
5212704 | 5212704 | 20241003031842_7GL6t | UK00AJ | 2024-10-04T12:03:34.175Z | 2024-10-12T12:24:54.917Z |
5212667 | 5212667 | 20241003031644_ErDrB | UK00AJ | 2024-10-04T12:03:30.613Z | 2024-10-12T12:24:54.883Z |
5212646 | 5212646 | 20241003031500_Z4Pdl | UK00AJ | 2024-10-04T12:03:29.115Z | 2024-10-12T12:24:54.868Z |
5212615 | 5212615 | 20241003031238_xrSQW | UK00AJ | 2024-10-04T12:03:26.378Z | 2024-10-12T12:24:54.838Z |
5212494 | 5212494 | 20241003030302_uDjr1 | UK00AJ | 2024-10-04T12:03:06.747Z | 2024-10-12T12:24:54.712Z |
5212294 | 5212294 | 20241003024819_C4WhB | UK00AJ | 2024-10-04T12:02:44.982Z | 2024-10-12T12:24:54.507Z |
5212242 | 5212242 | 20241003024428_896ih | UK00AJ | 2024-10-04T12:02:36.636Z | 2024-10-12T12:24:54.484Z |
5211778 | 5211778 | 20241003021553_fzWpd | UK00AJ | 2024-10-04T12:01:28.417Z | 2024-10-12T12:24:53.877Z |
5211764 | 5211764 | 20241003021503_TfYav | UK00AJ | 2024-10-04T12:01:25.288Z | 2024-10-12T12:24:53.851Z |
5211573 | 5211573 | 20241003020128_KmFtr | UK00AJ | 2024-10-04T12:00:56.815Z | 2024-10-12T12:24:53.713Z |
5192533 | 5192533 | 20240928224514_U3G8j | UK00AJ | 2024-09-30T12:18:44.814Z | 2024-10-06T12:28:25.875Z |
5192513 | 5192513 | 20240928224350_NRK32 | UK00AJ | 2024-09-30T12:18:43.927Z | 2024-10-06T12:28:25.826Z |
5192481 | 5192481 | 20240928224104_lLO3t | UK00AJ | 2024-09-30T12:18:42.489Z | 2024-10-06T12:28:25.749Z |
5192365 | 5192365 | 20240928222809_VhcK9 | UK00AJ | 2024-09-30T12:18:37.986Z | 2024-10-06T12:28:25.527Z |
5191889 | 5191889 | 20240928210816_Gw2Qj | UK00AJ | 2024-09-30T12:18:13.740Z | 2024-10-06T12:28:24.436Z |
5184219 | 5184219 | 20240929002721_4Eg7F | UK00AJ | 2024-09-30T12:00:53.861Z | 2024-10-07T12:21:14.517Z |
5183960 | 5183960 | 20240929000233_9s62B | UK00AJ | 2024-09-30T12:00:18.352Z | 2024-10-07T12:21:14.009Z |
5183921 | 5183921 | 20240928235827_Wxrv3 | UK00AJ | 2024-09-30T12:00:10.963Z | 2024-10-07T12:21:13.966Z |
5179738 | 5179738 | 20240928044217_CskqC | UK00AJ | 2024-09-29T12:08:24.514Z | 2024-10-06T12:28:05.327Z |
5179108 | 5179108 | 20240928034203_0gXLL | UK00AJ | 2024-09-29T12:07:26.510Z | 2024-10-06T12:28:02.360Z |
5179047 | 5179047 | 20240928033707_Jsy3N | UK00AJ | 2024-09-29T12:07:22.662Z | 2024-10-06T12:28:01.801Z |
5177973 | 5177973 | 20240928022326_BJOJz | UK00AJ | 2024-09-29T12:05:32.325Z | 2024-10-06T12:27:57.515Z |
5177876 | 5177876 | 20240928021754_ADxat | UK00AJ | 2024-09-29T12:05:13.770Z | 2024-10-06T12:27:56.477Z |
5177852 | 5177852 | 20240928021354_O13GW | UK00AJ | 2024-09-29T12:05:06.875Z | 2024-10-06T12:27:56.434Z |
5176785 | 5176785 | 20240928005724_yloMf | UK00AJ | 2024-09-29T12:03:02.461Z | 2024-10-06T12:27:52.450Z |
5176407 | 5176407 | 20240928003330_Z9Sqb | UK00AJ | 2024-09-29T12:02:17.148Z | 2024-10-06T12:27:51.248Z |
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);