participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,098 rows where station_code = "UK005R" 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 |
---|---|---|---|---|---|
5462059 | 5462059 | 20241101225343_PEqrH | UK005R | 2024-11-03T14:16:55.194Z | 2024-11-08T14:21:46.864Z |
5461980 | 5461980 | 20241101223150_DmZq3 | UK005R | 2024-11-03T14:16:50.371Z | 2024-11-08T14:21:46.637Z |
5429223 | 5429223 | 20241028190109_8ONZf | UK005R | 2024-10-31T12:16:13.705Z | 2024-11-06T14:27:15.553Z |
5410653 | 5410653 | 20241027052553_C9o85 | UK005R | 2024-10-29T12:18:02.170Z | 2024-11-04T14:29:05.201Z |
5410125 | 5410125 | 20241027045507_S3k7g | UK005R | 2024-10-29T12:17:48.435Z | 2024-11-04T14:29:03.799Z |
5409999 | 5409999 | 20241027044732_8VXYk | UK005R | 2024-10-29T12:17:45.663Z | 2024-11-04T14:29:03.248Z |
5409960 | 5409960 | 20241027044421_dpcfG | UK005R | 2024-10-29T12:17:44.940Z | 2024-11-04T14:29:03.110Z |
5409910 | 5409910 | 20241027044129_WoBRi | UK005R | 2024-10-29T12:17:43.926Z | 2024-11-04T14:29:02.919Z |
5409790 | 5409790 | 20241027043606_kmwok | UK005R | 2024-10-29T12:17:41.045Z | 2024-11-04T14:29:02.641Z |
5409645 | 5409645 | 20241027042922_3n8Bg | UK005R | 2024-10-29T12:17:35.930Z | 2024-11-04T14:29:02.044Z |
5409553 | 5409553 | 20241027042425_9kHyr | UK005R | 2024-10-29T12:17:29.974Z | 2024-11-04T14:29:01.952Z |
5409493 | 5409493 | 20241027042210_e6uaU | UK005R | 2024-10-29T12:17:26.435Z | 2024-11-04T14:29:01.912Z |
5409410 | 5409410 | 20241027041659_Vot6b | UK005R | 2024-10-29T12:17:22.478Z | 2024-11-04T14:29:01.652Z |
5408946 | 5408946 | 20241027035101_vr3cI | UK005R | 2024-10-29T12:16:57.866Z | 2024-11-04T14:29:00.850Z |
5408816 | 5408816 | 20241027034415_Ilfc7 | UK005R | 2024-10-29T12:16:53.446Z | 2024-11-04T14:29:00.560Z |
5408707 | 5408707 | 20241027033825_uBljj | UK005R | 2024-10-29T12:16:46.586Z | 2024-11-04T14:29:00.328Z |
5408562 | 5408562 | 20241027033030_vnuBv | UK005R | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5407954 | 5407954 | 20241027025952_uRgjI | UK005R | 2024-10-29T12:15:54.985Z | 2024-11-04T14:28:58.527Z |
5407050 | 5407050 | 20241027021846_CCLDK | UK005R | 2024-10-29T12:15:10.139Z | 2024-11-04T14:28:56.813Z |
5406635 | 5406635 | 20241027015121_e4x6F | UK005R | 2024-10-29T12:14:27.693Z | 2024-11-04T14:28:55.961Z |
5406319 | 5406319 | 20241027012728_I35oo | UK005R | 2024-10-29T12:14:01.974Z | 2024-11-04T14:28:55.430Z |
5406243 | 5406243 | 20241027012331_BbnsN | UK005R | 2024-10-29T12:13:59.057Z | 2024-11-04T14:28:55.249Z |
5406136 | 5406136 | 20241027011855_Mdjx3 | UK005R | 2024-10-29T12:13:53.233Z | 2024-11-04T14:28:55.158Z |
5405365 | 5405365 | 20241027002952_3WxUx | UK005R | 2024-10-29T12:12:51.763Z | 2024-11-04T14:28:53.353Z |
5405212 | 5405212 | 20241027002342_FXWm3 | UK005R | 2024-10-29T12:12:43.190Z | 2024-11-04T14:28:52.978Z |
5399566 | 5399566 | 20241026043500_C44VJ | UK005R | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399542 | 5399542 | 20241026043330_T2J2E | UK005R | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399406 | 5399406 | 20241026041545_XJ0ic | UK005R | 2024-10-28T12:19:58.479Z | 2024-11-03T14:27:39.617Z |
5399182 | 5399182 | 20241026035937_oYHlK | UK005R | 2024-10-28T12:19:50.784Z | 2024-11-03T14:27:39.194Z |
5399112 | 5399112 | 20241026035415_3DSX9 | UK005R | 2024-10-28T12:19:48.750Z | 2024-11-03T14:27:39.052Z |
5398747 | 5398747 | 20241026032516_wFRR8 | UK005R | 2024-10-28T12:19:30.214Z | 2024-11-03T14:27:37.967Z |
5398688 | 5398688 | 20241026031900_tYto2 | UK005R | 2024-10-28T12:19:28.487Z | 2024-11-03T14:27:37.732Z |
5398609 | 5398609 | 20241026031113_Sr2hc | UK005R | 2024-10-28T12:19:23.753Z | 2024-11-03T14:27:36.921Z |
5398367 | 5398367 | 20241026025037_OIqTF | UK005R | 2024-10-28T12:19:12.907Z | 2024-11-03T14:27:36.106Z |
5398356 | 5398356 | 20241026024928_OVUy1 | UK005R | 2024-10-28T12:19:12.141Z | 2024-11-03T14:27:36.048Z |
5397629 | 5397629 | 20241026014401_WmO0e | UK005R | 2024-10-28T12:18:30.447Z | 2024-11-03T14:27:33.622Z |
5397624 | 5397624 | 20241026014401_kfMnR | UK005R | 2024-10-28T12:18:30.360Z | 2024-11-03T14:27:33.621Z |
5397479 | 5397479 | 20241026013301_J22ig | UK005R | 2024-10-28T12:18:24.490Z | 2024-11-03T14:27:33.144Z |
5397457 | 5397457 | 20241026013130_9KjkZ | UK005R | 2024-10-28T12:18:23.304Z | 2024-11-03T14:27:33.032Z |
5397449 | 5397449 | 20241026013125_od88K | UK005R | 2024-10-28T12:18:23.018Z | 2024-11-03T14:27:33.026Z |
5396495 | 5396495 | 20241026000809_cadJN | UK005R | 2024-10-28T12:17:47.224Z | 2024-11-03T14:27:30.018Z |
5396013 | 5396013 | 20241025232940_rxr35 | UK005R | 2024-10-28T12:17:12.246Z | 2024-11-03T14:27:28.039Z |
5395949 | 5395949 | 20241025232523_8TT0E | UK005R | 2024-10-28T12:17:06.860Z | 2024-11-03T14:27:27.735Z |
5395809 | 5395809 | 20241025231224_CSRMC | UK005R | 2024-10-28T12:16:53.783Z | 2024-11-03T14:27:26.704Z |
5394976 | 5394976 | 20241025215509_1mNV1 | UK005R | 2024-10-28T12:15:51.355Z | 2024-11-03T14:27:23.603Z |
5385289 | 5385289 | 20241024221824_LUhnQ | UK005R | 2024-10-27T12:18:41.995Z | 2024-11-02T12:28:29.531Z |
5383572 | 5383572 | 20241024183428_PrrJU | UK005R | 2024-10-27T12:15:47.572Z | 2024-11-02T12:28:25.767Z |
5378212 | 5378212 | 20241024053716_9iBFB | UK005R | 2024-10-26T12:22:58.033Z | 2024-11-01T12:27:03.403Z |
5378161 | 5378161 | 20241024053337_p3pi0 | UK005R | 2024-10-26T12:22:56.662Z | 2024-11-01T12:27:03.333Z |
5378136 | 5378136 | 20241024052921_lyz6U | UK005R | 2024-10-26T12:22:55.124Z | 2024-11-01T12:27:03.297Z |
5378133 | 5378133 | 20241024052913_QUk3R | UK005R | 2024-10-26T12:22:54.941Z | 2024-11-01T12:27:03.296Z |
5378043 | 5378043 | 20241024052522_fyNS1 | UK005R | 2024-10-26T12:22:53.678Z | 2024-11-01T12:27:03.264Z |
5377937 | 5377937 | 20241024051807_eLxdM | UK005R | 2024-10-26T12:22:50.359Z | 2024-11-01T12:27:03.168Z |
5377857 | 5377857 | 20241024051450_LIfqw | UK005R | 2024-10-26T12:22:48.576Z | 2024-11-01T12:27:03.091Z |
5377521 | 5377521 | 20241024045538_vw591 | UK005R | 2024-10-26T12:22:39.456Z | 2024-11-01T12:27:02.564Z |
5377403 | 5377403 | 20241024044851_3sB7h | UK005R | 2024-10-26T12:22:36.503Z | 2024-11-01T12:27:02.420Z |
5377273 | 5377273 | 20241024044137_ebhL3 | UK005R | 2024-10-26T12:22:32.540Z | 2024-11-01T12:27:02.343Z |
5376773 | 5376773 | 20241024041447_g1dqs | UK005R | 2024-10-26T12:22:13.015Z | 2024-11-01T12:27:01.849Z |
5376738 | 5376738 | 20241024041113_miVKF | UK005R | 2024-10-26T12:22:12.245Z | 2024-11-01T12:27:01.756Z |
5376397 | 5376397 | 20241024035326_o8qHu | UK005R | 2024-10-26T12:22:00.554Z | 2024-11-01T12:27:01.523Z |
5375340 | 5375340 | 20241024030731_hSI1P | UK005R | 2024-10-26T12:21:21.393Z | 2024-11-01T12:27:00.626Z |
5375154 | 5375154 | 20241024025952_Yzi8m | UK005R | 2024-10-26T12:21:14.525Z | 2024-11-01T12:27:00.306Z |
5374797 | 5374797 | 20241024024407_TSCW1 | UK005R | 2024-10-26T12:21:01.734Z | 2024-11-01T12:26:59.608Z |
5374412 | 5374412 | 20241024022616_PLa3H | UK005R | 2024-10-26T12:20:47.754Z | 2024-11-01T12:26:59.361Z |
5374258 | 5374258 | 20241024021855_SMvNV | UK005R | 2024-10-26T12:20:41.766Z | 2024-11-01T12:26:58.796Z |
5374086 | 5374086 | 20241024020854_Nx0r1 | UK005R | 2024-10-26T12:20:36.697Z | 2024-11-01T12:26:58.692Z |
5373980 | 5373980 | 20241024020350_qtHvP | UK005R | 2024-10-26T12:20:33.154Z | 2024-11-01T12:26:58.617Z |
5373068 | 5373068 | 20241024012218_YgEIG | UK005R | 2024-10-26T12:19:55.669Z | 2024-11-01T12:26:58.111Z |
5372809 | 5372809 | 20241024010926_4K6BA | UK005R | 2024-10-26T12:19:44.231Z | 2024-11-01T12:26:57.926Z |
5372610 | 5372610 | 20241024005733_1W7jP | UK005R | 2024-10-26T12:19:33.072Z | 2024-11-01T12:26:57.750Z |
5372531 | 5372531 | 20241024005354_B5ZsS | UK005R | 2024-10-26T12:19:29.323Z | 2024-11-01T12:26:57.508Z |
5372524 | 5372524 | 20241024005245_eMqpt | UK005R | 2024-10-26T12:19:28.930Z | 2024-11-01T12:26:57.503Z |
5372404 | 5372404 | 20241024004650_JmVe2 | UK005R | 2024-10-26T12:19:23.370Z | 2024-11-01T12:26:57.432Z |
5372014 | 5372014 | 20241024002743_wuD8M | UK005R | 2024-10-26T12:19:03.764Z | 2024-11-01T12:26:57.064Z |
5366000 | 5366000 | 20241024000029_1HyoQ | UK005R | 2024-10-25T12:18:14.015Z | 2024-11-01T12:26:56.526Z |
5365787 | 5365787 | 20241023234937_F5n1X | UK005R | 2024-10-25T12:18:07.670Z | 2024-11-01T12:26:56.413Z |
5365593 | 5365593 | 20241023233849_V4V2f | UK005R | 2024-10-25T12:18:02.333Z | 2024-11-01T12:26:56.266Z |
5365567 | 5365567 | 20241023233757_A8KEk | UK005R | 2024-10-25T12:18:01.250Z | 2024-11-01T12:26:56.217Z |
5365483 | 5365483 | 20241023233426_9aNDv | UK005R | 2024-10-25T12:17:59.030Z | 2024-11-01T12:26:56.170Z |
5365433 | 5365433 | 20241023233222_vYaOe | UK005R | 2024-10-25T12:17:57.898Z | 2024-11-01T12:26:56.128Z |
5365006 | 5365006 | 20241023231004_SAWXg | UK005R | 2024-10-25T12:17:43.568Z | 2024-11-01T12:26:55.829Z |
5364332 | 5364332 | 20241023222135_3oynK | UK005R | 2024-10-25T12:17:17.243Z | 2024-11-01T12:26:54.694Z |
5362972 | 5362972 | 20241023201503_qmOvO | UK005R | 2024-10-25T12:15:21.037Z | 2024-11-01T12:26:52.760Z |
5355210 | 5355210 | 20241023032209_ZL9Yt | UK005R | 2024-10-24T12:21:10.336Z | 2024-10-31T12:30:07.381Z |
5349830 | 5349830 | 20241022203845_k2jWP | UK005R | 2024-10-24T12:14:42.213Z | 2024-10-31T12:29:56.661Z |
5349455 | 5349455 | 20241022200112_wsOGo | UK005R | 2024-10-24T12:13:42.400Z | 2024-10-31T12:29:55.477Z |
5348942 | 5348942 | 20241022191119_uZrpv | UK005R | 2024-10-24T12:12:37.284Z | 2024-10-31T12:29:54.183Z |
5348572 | 5348572 | 20241022183122_c2TXd | UK005R | 2024-10-24T12:11:42.548Z | 2024-10-31T12:29:52.950Z |
5345407 | 5345407 | 20241022054402_U53by | UK005R | 2024-10-23T12:19:19.201Z | 2024-10-30T12:26:52.637Z |
5345179 | 5345179 | 20241022052100_MyeOG | UK005R | 2024-10-23T12:19:09.488Z | 2024-10-30T12:26:52.280Z |
5333129 | 5333129 | 20241020234557_m2hVV | UK005R | 2024-10-22T12:14:45.386Z | 2024-10-29T12:26:34.128Z |
5321652 | 5321652 | 20241018053339_Dyop2 | UK005R | 2024-10-19T12:07:59.581Z | 2024-10-26T12:27:57.098Z |
5321638 | 5321638 | 20241018053309_AVwzO | UK005R | 2024-10-19T12:07:58.188Z | 2024-10-26T12:27:57.082Z |
5321448 | 5321448 | 20241018045307_62oWP | UK005R | 2024-10-19T12:07:29.561Z | 2024-10-26T12:27:56.843Z |
5321348 | 5321348 | 20241018043519_AsOp2 | UK005R | 2024-10-19T12:07:14.248Z | 2024-10-26T12:27:56.558Z |
5321210 | 5321210 | 20241018041011_zh06z | UK005R | 2024-10-19T12:07:01.421Z | 2024-10-26T12:27:56.349Z |
5321197 | 5321197 | 20241018040349_LES1C | UK005R | 2024-10-19T12:07:00.620Z | 2024-10-26T12:27:56.336Z |
5321066 | 5321066 | 20241018033901_cVYfr | UK005R | 2024-10-19T12:06:38.209Z | 2024-10-26T12:27:56.095Z |
5321062 | 5321062 | 20241018033836_R73nq | UK005R | 2024-10-19T12:06:37.499Z | 2024-10-26T12:27:56.087Z |
5321014 | 5321014 | 20241018033207_Nb5Fw | UK005R | 2024-10-19T12:06:33.626Z | 2024-10-26T12:27:56.052Z |
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);