participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
289 rows where station_code = "UK00A7" 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 |
---|---|---|---|---|---|
5132837 | 5132837 | 20240916022115_23bbU | UK00A7 | 2024-09-19T12:16:34.353Z | 2024-09-19T12:16:34.353Z |
5132379 | 5132379 | 20240916005506_0KAa7 | UK00A7 | 2024-09-19T12:16:09.937Z | 2024-09-19T12:16:09.937Z |
5087724 | 5087724 | 20240912234114_LEKWl | UK00A7 | 2024-09-16T12:07:19.543Z | 2024-09-19T12:20:35.619Z |
5069912 | 5069912 | 20240910221435_EPSls | UK00A7 | 2024-09-14T12:20:09.354Z | 2024-09-19T12:21:35.444Z |
5064220 | 5064220 | 20240910002537_rUBcB | UK00A7 | 2024-09-14T12:15:05.464Z | 2024-09-18T12:15:15.868Z |
5031364 | 5031364 | 20240906213336_C4ADd | UK00A7 | 2024-09-12T12:04:37.260Z | 2024-09-15T12:21:22.100Z |
5019311 | 5019311 | 20240904222830_MD1G7 | UK00A7 | 2024-09-10T12:12:35.719Z | 2024-09-13T12:19:51.357Z |
4990353 | 4990353 | 20240901000453_psmab | UK00A7 | 2024-09-07T12:10:25.959Z | 2024-09-09T12:26:17.371Z |
4990076 | 4990076 | 20240831232107_Y35JD | UK00A7 | 2024-09-07T12:09:58.911Z | 2024-09-09T12:26:10.011Z |
4990000 | 4990000 | 20240831231424_QEMsx | UK00A7 | 2024-09-07T12:09:54.499Z | 2024-09-09T12:26:08.499Z |
4989836 | 4989836 | 20240831224436_Ad4Ga | UK00A7 | 2024-09-07T12:09:39.613Z | 2024-09-09T12:25:56.522Z |
4989793 | 4989793 | 20240831223314_JZO31 | UK00A7 | 2024-09-07T12:09:33.778Z | 2024-09-09T12:25:49.890Z |
4927572 | 4927572 | 20240810021600_JT1Ht | UK00A7 | 2024-08-31T12:20:43.964Z | 2024-09-02T12:28:42.456Z |
4921636 | 4921636 | 20240810010104_rck3E | UK00A7 | 2024-08-30T12:14:17.835Z | 2024-09-02T12:27:09.762Z |
4916173 | 4916173 | 20240809230835_e62os | UK00A7 | 2024-08-30T12:10:39.901Z | 2024-09-02T12:24:17.871Z |
4915867 | 4915867 | 20240809225938_tZdO0 | UK00A7 | 2024-08-30T12:10:19.203Z | 2024-09-02T12:24:05.884Z |
4915607 | 4915607 | 20240809225312_YNt2G | UK00A7 | 2024-08-30T12:10:06.225Z | 2024-09-02T12:23:58.682Z |
4915205 | 4915205 | 20240809224151_eae6l | UK00A7 | 2024-08-30T12:09:45.960Z | 2024-09-02T12:23:52.025Z |
4914850 | 4914850 | 20240809223056_WqVpq | UK00A7 | 2024-08-30T12:09:33.395Z | 2024-09-02T12:23:46.259Z |
4881857 | 4881857 | 20240807015508_1si2a | UK00A7 | 2024-08-20T12:14:21.834Z | 2024-08-27T12:15:22.876Z |
4878558 | 4878558 | 20240807003112_BnclB | UK00A7 | 2024-08-19T12:14:16.032Z | 2024-08-27T12:13:45.414Z |
4878224 | 4878224 | 20240807002258_97QcQ | UK00A7 | 2024-08-19T12:14:07.020Z | 2024-08-27T12:13:37.926Z |
4876345 | 4876345 | 20240806233805_jN4rx | UK00A7 | 2024-08-19T12:12:51.291Z | 2024-08-27T12:12:41.055Z |
4875513 | 4875513 | 20240806231648_Lk8wa | UK00A7 | 2024-08-19T12:12:11.681Z | 2024-08-27T12:12:17.609Z |
4825542 | 4825542 | 20240804012053_3NFds | UK00A7 | 2024-08-14T12:20:12.580Z | 2024-08-15T12:25:54.499Z |
4825255 | 4825255 | 20240804005643_UZJAn | UK00A7 | 2024-08-14T12:20:00.670Z | 2024-08-15T12:25:48.034Z |
4824801 | 4824801 | 20240804001843_Fs4Nv | UK00A7 | 2024-08-14T12:19:31.533Z | 2024-08-15T12:25:37.011Z |
4824675 | 4824675 | 20240804000801_VkJsT | UK00A7 | 2024-08-14T12:19:20.942Z | 2024-08-15T12:25:33.549Z |
4824537 | 4824537 | 20240804000029_mIIyq | UK00A7 | 2024-08-14T12:19:15.437Z | 2024-08-15T12:25:29.330Z |
4824335 | 4824335 | 20240803234700_aazxg | UK00A7 | 2024-08-14T12:19:02.035Z | 2024-08-15T12:25:23.502Z |
4823466 | 4823466 | 20240803225211_tFXSh | UK00A7 | 2024-08-14T12:18:17.007Z | 2024-08-15T12:24:59.501Z |
4714707 | 4714707 | 20240728004436_1YAAc | UK00A7 | 2024-07-30T12:05:23.721Z | 2024-08-05T12:19:41.084Z |
4275674 | 4275674 | 20240502234909_ek2pY | UK00A7 | 2024-05-05T12:11:24.357Z | 2024-05-11T12:28:12.486Z |
4275667 | 4275667 | 20240502234057_1qr73 | UK00A7 | 2024-05-05T12:11:23.070Z | 2024-05-11T12:28:12.019Z |
4275647 | 4275647 | 20240502231017_7TBPF | UK00A7 | 2024-05-05T12:11:18.986Z | 2024-05-11T12:28:10.895Z |
4275618 | 4275618 | 20240502220926_U3o3O | UK00A7 | 2024-05-05T12:11:11.541Z | 2024-05-11T12:28:08.132Z |
4266621 | 4266621 | 20240502014821_jxecz | UK00A7 | 2024-05-03T12:08:23.512Z | 2024-05-10T12:23:48.641Z |
4247743 | 4247743 | 20240428014654_Bqaq2 | UK00A7 | 2024-04-29T12:09:35.086Z | 2024-05-06T12:21:12.713Z |
4247455 | 4247455 | 20240427224430_SWlJZ | UK00A7 | 2024-04-29T12:08:54.599Z | 2024-05-06T12:21:09.468Z |
4243442 | 4243442 | 20240427023213_dUyA3 | UK00A7 | 2024-04-28T12:09:13.448Z | 2024-05-05T12:21:46.344Z |
4243429 | 4243429 | 20240427015216_Nhhtj | UK00A7 | 2024-04-28T12:09:11.830Z | 2024-05-05T12:21:46.115Z |
4243232 | 4243232 | 20240426232714_sBl2r | UK00A7 | 2024-04-28T12:08:49.495Z | 2024-05-05T12:21:43.778Z |
4240351 | 4240351 | 20240425011254_bwvYR | UK00A7 | 2024-04-27T12:10:33.670Z | 2024-05-03T12:19:30.955Z |
4240246 | 4240246 | 20240424230531_1wnog | UK00A7 | 2024-04-27T12:10:19.962Z | 2024-05-03T12:19:30.005Z |
4239739 | 4239739 | 20240425232207_pPOgj | UK00A7 | 2024-04-27T12:07:06.424Z | 2024-05-04T12:21:22.324Z |
4239710 | 4239710 | 20240425230234_1ye7P | UK00A7 | 2024-04-27T12:07:03.301Z | 2024-05-04T12:21:22.081Z |
4239677 | 4239677 | 20240425221955_iIwpi | UK00A7 | 2024-04-27T12:06:59.865Z | 2024-05-04T12:21:21.794Z |
4237470 | 4237470 | 20240422233606_IuU67 | UK00A7 | 2024-04-26T12:11:53.256Z | 2024-04-30T12:17:56.082Z |
4235488 | 4235488 | 20240423023156_7ha3s | UK00A7 | 2024-04-26T12:04:34.414Z | 2024-05-02T12:22:25.328Z |
4235061 | 4235061 | 20240423002330_lgi8p | UK00A7 | 2024-04-26T12:03:25.956Z | 2024-05-02T12:22:20.610Z |
4190449 | 4190449 | 20240415003459_ZAatd | UK00A7 | 2024-04-16T12:03:46.026Z | 2024-04-23T12:24:46.679Z |
4185867 | 4185867 | 20240414022123_21ZYa | UK00A7 | 2024-04-15T12:05:20.285Z | 2024-04-22T12:22:23.002Z |
4180159 | 4180159 | 20240413023835_EIeN6 | UK00A7 | 2024-04-14T12:04:09.764Z | 2024-04-21T12:21:41.626Z |
4179917 | 4179917 | 20240413012842_sMiBj | UK00A7 | 2024-04-14T12:03:22.432Z | 2024-04-21T12:21:37.897Z |
4179493 | 4179493 | 20240412222151_P5Mq3 | UK00A7 | 2024-04-14T12:01:52.102Z | 2024-04-21T12:21:29.343Z |
4171648 | 4171648 | 20240410024729_DK1jY | UK00A7 | 2024-04-12T12:07:57.538Z | 2024-04-18T12:21:19.239Z |
4165511 | 4165511 | 20240409205602_ViVTm | UK00A7 | 2024-04-11T12:03:35.446Z | 2024-04-18T12:21:01.640Z |
4157789 | 4157789 | 20240408034541_3cqa1 | UK00A7 | 2024-04-09T12:05:50.307Z | 2024-04-16T12:20:20.255Z |
4157075 | 4157075 | 20240407212959_dpYf4 | UK00A7 | 2024-04-09T12:03:37.828Z | 2024-04-16T12:20:13.286Z |
4157031 | 4157031 | 20240407211406_4VnlS | UK00A7 | 2024-04-09T12:03:30.886Z | 2024-04-16T12:20:13.116Z |
4154832 | 4154832 | 20240407030059_zTZTa | UK00A7 | 2024-04-08T12:07:15.640Z | 2024-04-15T12:19:17.326Z |
4132714 | 4132714 | 20240331202751_KyHrD | UK00A7 | 2024-04-02T12:03:01.065Z | 2024-04-09T12:21:10.063Z |
4124521 | 4124521 | 20240330033148_d9rVz | UK00A7 | 2024-03-31T12:08:15.187Z | 2024-04-07T12:24:25.030Z |
4123872 | 4123872 | 20240330012949_yH8Oi | UK00A7 | 2024-03-31T12:07:20.375Z | 2024-04-07T12:24:21.820Z |
4105175 | 4105175 | 20240322044243_afAmz | UK00A7 | 2024-03-23T12:08:03.140Z | 2024-03-30T12:18:10.339Z |
4094607 | 4094607 | 20240319041239_8VkCN | UK00A7 | 2024-03-21T12:10:01.720Z | 2024-03-27T12:19:18.903Z |
4078324 | 4078324 | 20240316045600_TNMSE | UK00A7 | 2024-03-17T12:09:27.134Z | 2024-03-24T12:20:57.172Z |
4077968 | 4077968 | 20240316040541_1wCmQ | UK00A7 | 2024-03-17T12:09:11.796Z | 2024-03-24T12:20:54.508Z |
4077583 | 4077583 | 20240316032008_vMfn9 | UK00A7 | 2024-03-17T12:08:41.849Z | 2024-03-24T12:20:51.700Z |
4067707 | 4067707 | 20240313213154_uvq1v | UK00A7 | 2024-03-15T12:04:55.197Z | 2024-03-22T12:17:34.120Z |
4031448 | 4031448 | 20240305034609_MrcwA | UK00A7 | 2024-03-06T14:09:12.317Z | 2024-03-13T12:20:56.557Z |
4027123 | 4027123 | 20240304050220_DwSm3 | UK00A7 | 2024-03-05T14:08:57.227Z | 2024-03-12T12:15:34.990Z |
4000665 | 4000665 | 20240223194926_A353f | UK00A7 | 2024-02-25T14:01:29.250Z | 2024-03-03T14:17:22.663Z |
3999631 | 3999631 | 20240223014009_h7Dif | UK00A7 | 2024-02-24T14:05:25.345Z | 2024-03-02T14:20:33.724Z |
3995229 | 3995229 | 20240221031331_Lu2Hp | UK00A7 | 2024-02-22T14:06:11.281Z | 2024-02-29T14:14:45.737Z |
3995208 | 3995208 | 20240221024905_IPaTg | UK00A7 | 2024-02-22T14:06:08.863Z | 2024-02-29T14:14:43.936Z |
3995156 | 3995156 | 20240221005020_6MOrO | UK00A7 | 2024-02-22T14:05:59.928Z | 2024-02-29T14:14:40.714Z |
3966217 | 3966217 | 20240214054846_C5bmq | UK00A7 | 2024-02-15T14:08:44.416Z | 2024-02-22T14:24:20.746Z |
3966165 | 3966165 | 20240214051814_Ay927 | UK00A7 | 2024-02-15T14:08:30.307Z | 2024-02-22T14:24:18.427Z |
3965623 | 3965623 | 20240214014104_VSDEl | UK00A7 | 2024-02-15T14:07:14.465Z | 2024-02-22T14:23:53.906Z |
3965535 | 3965535 | 20240214004751_ubddM | UK00A7 | 2024-02-15T14:07:04.069Z | 2024-02-22T14:23:50.488Z |
3965487 | 3965487 | 20240214003213_YbqIJ | UK00A7 | 2024-02-15T14:06:50.000Z | 2024-02-22T14:23:49.067Z |
3965412 | 3965412 | 20240213235739_Xa2cs | UK00A7 | 2024-02-15T14:06:35.248Z | 2024-02-22T14:23:45.906Z |
3964811 | 3964811 | 20240213191638_kY3JF | UK00A7 | 2024-02-15T14:05:11.465Z | 2024-02-22T14:23:25.495Z |
3954428 | 3954428 | 20240212054402_fc1vR | UK00A7 | 2024-02-13T14:08:57.228Z | 2024-02-20T14:26:06.857Z |
3954356 | 3954356 | 20240212053140_0Stlr | UK00A7 | 2024-02-13T14:08:54.407Z | 2024-02-20T14:26:06.502Z |
3938981 | 3938981 | 20240208202540_9gWfU | UK00A7 | 2024-02-10T14:04:56.883Z | 2024-02-17T14:26:09.163Z |
3936260 | 3936260 | 20240208060115_Jqqit | UK00A7 | 2024-02-09T14:06:52.927Z | 2024-02-16T14:18:33.929Z |
3935664 | 3935664 | 20240207211914_isRKk | UK00A7 | 2024-02-09T14:05:16.201Z | 2024-02-16T14:18:28.496Z |
3930947 | 3930947 | 20240206200254_UrluE | UK00A7 | 2024-02-08T14:03:04.431Z | 2024-02-15T14:18:30.603Z |
3930553 | 3930553 | 20240206181055_VUrX1 | UK00A7 | 2024-02-08T14:01:56.064Z | 2024-02-15T14:18:28.609Z |
3911741 | 3911741 | 20240202205513_LnwDs | UK00A7 | 2024-02-04T14:01:23.462Z | 2024-02-11T14:22:40.767Z |
3911513 | 3911513 | 20240202180142_HsiG8 | UK00A7 | 2024-02-04T14:00:27.554Z | 2024-02-11T14:22:31.336Z |
3906507 | 3906507 | 20240201051448_Hlr2A | UK00A7 | 2024-02-02T14:05:54.182Z | 2024-02-09T14:20:24.223Z |
3900294 | 3900294 | 20240129181016_7W2WL | UK00A7 | 2024-01-31T14:11:51.709Z | 2024-02-06T14:21:06.799Z |
3897681 | 3897681 | 20240130031440_NKIDO | UK00A7 | 2024-01-31T14:03:28.122Z | 2024-02-07T14:22:11.918Z |
3897036 | 3897036 | 20240129194721_0SoWD | UK00A7 | 2024-01-31T14:00:59.420Z | 2024-02-07T14:22:01.971Z |
3886212 | 3886212 | 20240124201031_uDL6q | UK00A7 | 2024-01-26T14:07:29.198Z | 2024-02-01T14:18:19.188Z |
3883657 | 3883657 | 20240125001459_crJVi | UK00A7 | 2024-01-26T14:00:54.580Z | 2024-02-02T14:19:13.929Z |
3789612 | 3789612 | 20240109202701_zEWr3 | UK00A7 | 2024-01-12T14:10:57.361Z | 2024-01-18T14:25:51.945Z |
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);