participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,594 rows where station_code = "UK002V" 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 |
---|---|---|---|---|---|
3906716 | 3906716 | 20240201060749_YG49z | UK002V | 2024-02-02T14:06:25.619Z | 2024-02-09T14:20:28.182Z |
3906693 | 3906693 | 20240201060237_xQ3cs | UK002V | 2024-02-02T14:06:23.251Z | 2024-02-09T14:20:27.791Z |
3906622 | 3906622 | 20240201054821_URCnK | UK002V | 2024-02-02T14:06:10.805Z | 2024-02-09T14:20:26.670Z |
3906505 | 3906505 | 20240201051424_pbzHb | UK002V | 2024-02-02T14:05:53.906Z | 2024-02-09T14:20:24.202Z |
3906492 | 3906492 | 20240201051029_SEI8U | UK002V | 2024-02-02T14:05:52.830Z | 2024-02-09T14:20:24.093Z |
3905382 | 3905382 | 20240131234651_v5DIR | UK002V | 2024-02-02T14:02:53.601Z | 2024-02-09T14:19:59.033Z |
3905379 | 3905379 | 20240131234647_p7A1a | UK002V | 2024-02-02T14:02:52.891Z | 2024-02-09T14:19:58.986Z |
3905368 | 3905368 | 20240131233847_bK4jL | UK002V | 2024-02-02T14:02:49.545Z | 2024-02-09T14:19:58.858Z |
3901497 | 3901497 | 20240131010345_CQHW5 | UK002V | 2024-02-01T14:03:32.784Z | 2024-02-08T14:20:14.141Z |
3901104 | 3901104 | 20240130222805_q39ZP | UK002V | 2024-02-01T14:02:33.298Z | 2024-02-08T14:20:08.689Z |
3891083 | 3891083 | 20240126185914_aXrvk | UK002V | 2024-01-28T14:09:41.500Z | 2024-02-03T14:24:56.733Z |
3891077 | 3891077 | 20240126185913_PqxDw | UK002V | 2024-01-28T14:09:40.538Z | 2024-02-03T14:24:56.388Z |
3878833 | 3878833 | 20240122063944_6CdLI | UK002V | 2024-01-24T14:03:54.359Z | 2024-01-30T14:19:00.685Z |
3878282 | 3878282 | 20240122051451_Sxj6g | UK002V | 2024-01-24T14:03:07.564Z | 2024-01-30T14:18:51.211Z |
3878103 | 3878103 | 20240122043144_2qQJz | UK002V | 2024-01-24T14:02:31.186Z | 2024-01-30T14:18:44.349Z |
3871115 | 3871115 | 20240121051047_0GRt2 | UK002V | 2024-01-23T14:03:39.118Z | 2024-01-29T14:18:16.024Z |
3871053 | 3871053 | 20240121044910_Mw37m | UK002V | 2024-01-23T14:03:26.181Z | 2024-01-29T14:18:13.092Z |
3868092 | 3868092 | 20240119064658_x5KFd | UK002V | 2024-01-22T14:08:06.320Z | 2024-01-27T14:20:33.783Z |
3868050 | 3868050 | 20240119064410_MGtVM | UK002V | 2024-01-22T14:07:59.254Z | 2024-01-27T14:20:31.958Z |
3868037 | 3868037 | 20240119064249_5kTcN | UK002V | 2024-01-22T14:07:57.927Z | 2024-01-27T14:20:31.478Z |
3868002 | 3868002 | 20240119064049_p4v2H | UK002V | 2024-01-22T14:07:56.447Z | 2024-01-27T14:20:30.600Z |
3867995 | 3867995 | 20240119064017_cxTpw | UK002V | 2024-01-22T14:07:56.018Z | 2024-01-27T14:20:30.444Z |
3867942 | 3867942 | 20240119063453_CGAOK | UK002V | 2024-01-22T14:07:51.206Z | 2024-01-27T14:20:29.633Z |
3867808 | 3867808 | 20240119062728_gK0PP | UK002V | 2024-01-22T14:07:44.844Z | 2024-01-27T14:20:26.361Z |
3867469 | 3867469 | 20240119061256_fgwDd | UK002V | 2024-01-22T14:07:35.792Z | 2024-01-27T14:20:23.115Z |
3867370 | 3867370 | 20240119060612_PTHl0 | UK002V | 2024-01-22T14:07:32.902Z | 2024-01-27T14:20:22.395Z |
3867358 | 3867358 | 20240119060324_0MyT3 | UK002V | 2024-01-22T14:07:31.532Z | 2024-01-27T14:20:21.942Z |
3867039 | 3867039 | 20240119054625_jLtEN | UK002V | 2024-01-22T14:07:06.584Z | 2024-01-27T14:20:20.065Z |
3866777 | 3866777 | 20240119052702_Uo6K0 | UK002V | 2024-01-22T14:06:49.717Z | 2024-01-27T14:20:16.349Z |
3866642 | 3866642 | 20240119051959_0naM1 | UK002V | 2024-01-22T14:06:45.709Z | 2024-01-27T14:20:15.533Z |
3866600 | 3866600 | 20240119051744_K9vfK | UK002V | 2024-01-22T14:06:43.481Z | 2024-01-27T14:20:15.166Z |
3866280 | 3866280 | 20240119045830_uv7cN | UK002V | 2024-01-22T14:06:17.561Z | 2024-01-27T14:20:11.455Z |
3865637 | 3865637 | 20240119042730_iEWjW | UK002V | 2024-01-22T14:05:44.046Z | 2024-01-27T14:20:06.612Z |
3865472 | 3865472 | 20240119042306_JE5bE | UK002V | 2024-01-22T14:05:33.384Z | 2024-01-27T14:20:05.806Z |
3865456 | 3865456 | 20240119042113_wQ4sB | UK002V | 2024-01-22T14:05:32.347Z | 2024-01-27T14:20:04.881Z |
3864686 | 3864686 | 20240119034629_f24A1 | UK002V | 2024-01-22T14:04:47.306Z | 2024-01-27T14:19:52.530Z |
3863996 | 3863996 | 20240119031822_AGgX2 | UK002V | 2024-01-22T14:04:13.341Z | 2024-01-27T14:19:40.256Z |
3863598 | 3863598 | 20240119025330_GnlUG | UK002V | 2024-01-22T14:03:46.801Z | 2024-01-27T14:19:31.582Z |
3863451 | 3863451 | 20240119024927_lAzWH | UK002V | 2024-01-22T14:03:39.966Z | 2024-01-27T14:19:29.834Z |
3863314 | 3863314 | 20240119023928_slPKZ | UK002V | 2024-01-22T14:03:26.578Z | 2024-01-27T14:19:27.323Z |
3863259 | 3863259 | 20240119023656_aeYcQ | UK002V | 2024-01-22T14:03:20.466Z | 2024-01-27T14:19:24.973Z |
3862859 | 3862859 | 20240119020723_NcYcc | UK002V | 2024-01-22T14:02:53.488Z | 2024-01-27T14:19:18.285Z |
3862803 | 3862803 | 20240119020103_IZ4bH | UK002V | 2024-01-22T14:02:47.196Z | 2024-01-27T14:19:15.782Z |
3862686 | 3862686 | 20240119015442_VmnEc | UK002V | 2024-01-22T14:02:32.008Z | 2024-01-27T14:19:10.714Z |
3862391 | 3862391 | 20240119011409_W0NUS | UK002V | 2024-01-22T14:01:56.048Z | 2024-01-27T14:18:59.531Z |
3862026 | 3862026 | 20240119003008_JpL2W | UK002V | 2024-01-22T14:01:15.865Z | 2024-01-27T14:18:48.205Z |
3861922 | 3861922 | 20240119001309_Hh8T6 | UK002V | 2024-01-22T14:01:08.283Z | 2024-01-27T14:18:45.272Z |
3861041 | 3861041 | 20240118222103_412Xu | UK002V | 2024-01-21T14:19:01.788Z | 2024-01-26T14:23:02.001Z |
3860736 | 3860736 | 20240118211926_7vLo7 | UK002V | 2024-01-21T14:18:40.073Z | 2024-01-26T14:22:57.404Z |
3860047 | 3860047 | 20240118182108_io7ct | UK002V | 2024-01-21T14:17:41.506Z | 2024-01-26T14:22:43.891Z |
3857101 | 3857101 | 20240118061522_c9XiK | UK002V | 2024-01-21T14:10:34.947Z | 2024-01-26T14:21:34.242Z |
3857040 | 3857040 | 20240118061045_Hdqmn | UK002V | 2024-01-21T14:10:22.988Z | 2024-01-26T14:21:32.235Z |
3856587 | 3856587 | 20240118054811_XT8tV | UK002V | 2024-01-21T14:09:29.521Z | 2024-01-26T14:21:25.616Z |
3856262 | 3856262 | 20240118052855_59BBJ | UK002V | 2024-01-21T14:08:40.079Z | 2024-01-26T14:21:22.035Z |
3855914 | 3855914 | 20240118051141_9aZaW | UK002V | 2024-01-21T14:07:37.614Z | 2024-01-26T14:21:19.524Z |
3855604 | 3855604 | 20240118045908_eqRho | UK002V | 2024-01-21T14:06:47.915Z | 2024-01-26T14:21:16.866Z |
3855480 | 3855480 | 20240118045613_mZCQY | UK002V | 2024-01-21T14:06:29.237Z | 2024-01-26T14:21:16.288Z |
3854202 | 3854202 | 20240117220819_xln63 | UK002V | 2024-01-20T14:14:43.549Z | 2024-01-21T14:21:43.317Z |
3854189 | 3854189 | 20240117215837_lnypM | UK002V | 2024-01-20T14:14:42.812Z | 2024-01-21T14:21:42.918Z |
3853759 | 3853759 | 20240117201127_Y1aQw | UK002V | 2024-01-20T14:14:15.876Z | 2024-01-21T14:21:35.294Z |
3849749 | 3849749 | 20240117023400_u7Hi3 | UK002V | 2024-01-20T14:07:13.484Z | 2024-01-21T14:19:30.221Z |
3849700 | 3849700 | 20240117021253_oxh2k | UK002V | 2024-01-20T14:06:57.742Z | 2024-01-21T14:19:27.465Z |
3849620 | 3849620 | 20240117013942_CLlu3 | UK002V | 2024-01-20T14:06:46.618Z | 2024-01-21T14:19:23.898Z |
3849350 | 3849350 | 20240116235524_QROiU | UK002V | 2024-01-20T14:06:13.223Z | 2024-01-21T14:19:16.782Z |
3849274 | 3849274 | 20240116233653_2Q2cK | UK002V | 2024-01-20T14:06:06.255Z | 2024-01-21T14:19:15.194Z |
3848741 | 3848741 | 20240118033114_cr3XA | UK002V | 2024-01-20T14:05:14.536Z | 2024-01-26T14:21:04.607Z |
3848410 | 3848410 | 20240118030739_2X3QI | UK002V | 2024-01-20T14:04:42.993Z | 2024-01-26T14:21:01.557Z |
3848045 | 3848045 | 20240118025030_m1Jtj | UK002V | 2024-01-20T14:04:15.714Z | 2024-01-26T14:20:59.122Z |
3847332 | 3847332 | 20240118015805_t92lP | UK002V | 2024-01-20T14:03:04.616Z | 2024-01-26T14:20:51.400Z |
3847176 | 3847176 | 20240118013758_S2W2o | UK002V | 2024-01-20T14:02:45.007Z | 2024-01-26T14:20:47.132Z |
3846698 | 3846698 | 20240118010437_QGyUP | UK002V | 2024-01-20T14:02:03.098Z | 2024-01-26T14:20:37.728Z |
3846642 | 3846642 | 20240118010300_DCbIr | UK002V | 2024-01-20T14:01:56.854Z | 2024-01-26T14:20:37.300Z |
3846376 | 3846376 | 20240118004142_DF7Sy | UK002V | 2024-01-20T14:01:25.771Z | 2024-01-26T14:20:32.767Z |
3845928 | 3845928 | 20240117235600_GwZkW | UK002V | 2024-01-20T14:00:45.423Z | 2024-01-26T14:20:25.570Z |
3845451 | 3845451 | 20240116224629_d41Ks | UK002V | 2024-01-19T14:14:06.000Z | 2024-01-25T14:22:35.546Z |
3845205 | 3845205 | 20240116205508_wZ9Hw | UK002V | 2024-01-19T14:13:43.068Z | 2024-01-25T14:22:27.714Z |
3845177 | 3845177 | 20240116203034_uCIJG | UK002V | 2024-01-19T14:13:41.377Z | 2024-01-25T14:22:25.686Z |
3839883 | 3839883 | 20240116060258_sB2PZ | UK002V | 2024-01-19T14:03:58.599Z | 2024-01-25T14:21:26.526Z |
3838162 | 3838162 | 20240115223722_o6KPO | UK002V | 2024-01-18T14:15:08.211Z | 2024-01-24T14:19:18.003Z |
3838086 | 3838086 | 20240115220812_lNE8X | UK002V | 2024-01-18T14:15:06.041Z | 2024-01-24T14:19:17.809Z |
3835936 | 3835936 | 20240115183242_4LW28 | UK002V | 2024-01-18T14:12:54.979Z | 2024-01-24T14:19:06.014Z |
3835691 | 3835691 | 20240115180926_Qf50U | UK002V | 2024-01-18T14:12:28.356Z | 2024-01-24T14:19:04.513Z |
3825277 | 3825277 | 20240115050322_3J2Ih | UK002V | 2024-01-17T14:04:54.472Z | 2024-01-24T14:18:24.172Z |
3825249 | 3825249 | 20240115050243_l5GLA | UK002V | 2024-01-17T14:04:52.974Z | 2024-01-24T14:18:24.124Z |
3825215 | 3825215 | 20240115050151_jm99f | UK002V | 2024-01-17T14:04:52.206Z | 2024-01-24T14:18:24.085Z |
3825057 | 3825057 | 20240115044909_M0H32 | UK002V | 2024-01-17T14:04:28.738Z | 2024-01-24T14:18:22.682Z |
3825028 | 3825028 | 20240115044647_OBDB9 | UK002V | 2024-01-17T14:04:26.846Z | 2024-01-24T14:18:22.609Z |
3824620 | 3824620 | 20240115042003_xoTPk | UK002V | 2024-01-17T14:03:50.244Z | 2024-01-24T14:18:20.247Z |
3824569 | 3824569 | 20240115041758_eqjiL | UK002V | 2024-01-17T14:03:46.423Z | 2024-01-24T14:18:19.994Z |
3824181 | 3824181 | 20240115035223_ZKQ40 | UK002V | 2024-01-17T14:03:24.425Z | 2024-01-24T14:18:18.358Z |
3824095 | 3824095 | 20240115034649_FhDZ4 | UK002V | 2024-01-17T14:03:13.071Z | 2024-01-24T14:18:18.047Z |
3823914 | 3823914 | 20240115033943_w66KT | UK002V | 2024-01-17T14:02:56.550Z | 2024-01-24T14:18:16.387Z |
3823895 | 3823895 | 20240115033801_SgLx2 | UK002V | 2024-01-17T14:02:54.786Z | 2024-01-24T14:18:16.285Z |
3823685 | 3823685 | 20240115030738_x07Uq | UK002V | 2024-01-17T14:02:30.690Z | 2024-01-24T14:18:14.546Z |
3823541 | 3823541 | 20240115025547_eWG0S | UK002V | 2024-01-17T14:02:17.370Z | 2024-01-24T14:18:14.103Z |
3820805 | 3820805 | 20240113183446_JY1My | UK002V | 2024-01-16T14:12:08.274Z | 2024-01-22T14:23:06.578Z |
3807584 | 3807584 | 20240109212548_ecpSQ | UK002V | 2024-01-14T14:19:32.384Z | 2024-01-18T14:25:55.482Z |
3788928 | 3788928 | 20240109184847_aFfFR | UK002V | 2024-01-12T14:09:49.902Z | 2024-01-18T14:25:46.773Z |
3788526 | 3788526 | 20240109175515_L2lgn | UK002V | 2024-01-12T14:09:11.638Z | 2024-01-18T14:25:43.194Z |
3785664 | 3785664 | 20240108024845_B4tY1 | UK002V | 2024-01-11T14:20:17.029Z | 2024-01-16T14:27:36.681Z |
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);