participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
156 rows where station_code = "BG000H" 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 |
---|---|---|---|---|---|
5599422 | 5599422 | 20241124011817_3UJsM | BG000H | 2024-11-25T14:17:02.851Z | 2024-11-25T14:17:38.621Z |
5599353 | 5599353 | 20241124005647_u6VBa | BG000H | 2024-11-25T14:16:59.358Z | 2024-11-25T14:17:38.603Z |
5598960 | 5598960 | 20241123224917_OL69V | BG000H | 2024-11-25T14:16:30.168Z | 2024-11-25T14:17:38.499Z |
5580174 | 5580174 | 20241122001345_jw2gm | BG000H | 2024-11-23T14:19:09.302Z | 2024-11-25T14:20:29.255Z |
5556571 | 5556571 | 20241118233920_jcy2z | BG000H | 2024-11-20T14:10:45.812Z | 2024-11-25T14:22:16.869Z |
5556505 | 5556505 | 20241118224338_7TyLu | BG000H | 2024-11-20T14:10:38.360Z | 2024-11-25T14:22:16.672Z |
5552657 | 5552657 | 20241117195120_gH081 | BG000H | 2024-11-19T14:08:51.857Z | 2024-11-25T14:22:27.987Z |
5552567 | 5552567 | 20241117184447_ZHJhl | BG000H | 2024-11-19T14:08:40.007Z | 2024-11-25T14:22:27.074Z |
5552483 | 5552483 | 20241117171809_8c3zF | BG000H | 2024-11-19T14:08:11.123Z | 2024-11-25T14:22:26.211Z |
5490547 | 5490547 | 20241105231950_g2S7j | BG000H | 2024-11-07T14:14:11.226Z | 2024-11-14T14:23:20.807Z |
5490417 | 5490417 | 20241105223839_lHwVz | BG000H | 2024-11-07T14:13:59.612Z | 2024-11-14T14:23:19.515Z |
5462415 | 5462415 | 20241102001451_rhla9 | BG000H | 2024-11-03T14:17:24.733Z | 2024-11-10T14:26:32.448Z |
5403487 | 5403487 | 20241026220351_z9Cc2 | BG000H | 2024-10-29T12:09:36.951Z | 2024-11-04T14:28:48.985Z |
5396442 | 5396442 | 20241026000510_nRIQD | BG000H | 2024-10-28T12:17:43.208Z | 2024-11-03T14:27:29.833Z |
5386596 | 5386596 | 20241025010457_uSHHk | BG000H | 2024-10-27T12:20:11.450Z | 2024-11-02T12:28:31.377Z |
5386203 | 5386203 | 20241025001328_x1KiS | BG000H | 2024-10-27T12:19:54.758Z | 2024-11-02T12:28:30.836Z |
5311862 | 5311862 | 20241015021446_JnlHp | BG000H | 2024-10-16T12:09:43.916Z | 2024-10-23T12:24:46.039Z |
5275497 | 5275497 | 20241010022523_eyvY2 | BG000H | 2024-10-11T12:16:00.459Z | 2024-10-18T12:22:18.215Z |
5275222 | 5275222 | 20241010013139_qADcA | BG000H | 2024-10-11T12:15:32.476Z | 2024-10-18T12:22:14.847Z |
5275008 | 5275008 | 20241010004340_MiGAa | BG000H | 2024-10-11T12:15:07.904Z | 2024-10-18T12:22:12.660Z |
5262668 | 5262668 | 20241008020654_KN2ok | BG000H | 2024-10-09T12:16:05.413Z | 2024-10-16T12:21:19.567Z |
5262355 | 5262355 | 20241008011042_pReyI | BG000H | 2024-10-09T12:15:36.942Z | 2024-10-16T12:21:18.393Z |
5261884 | 5261884 | 20241007225721_FRkW3 | BG000H | 2024-10-09T12:14:47.797Z | 2024-10-16T12:21:16.716Z |
5216548 | 5216548 | 20241003010720_K8KSE | BG000H | 2024-10-04T12:13:27.657Z | 2024-10-11T12:23:37.336Z |
5211868 | 5211868 | 20241003022039_p247v | BG000H | 2024-10-04T12:01:37.260Z | 2024-10-12T12:24:53.958Z |
5177120 | 5177120 | 20240928011924_pMP2G | BG000H | 2024-09-29T12:03:43.789Z | 2024-10-06T12:27:54.234Z |
5088237 | 5088237 | 20240913000216_9GFsD | BG000H | 2024-09-16T12:07:49.015Z | 2024-09-21T12:16:17.719Z |
5053487 | 5053487 | 20240908004350_LM6SC | BG000H | 2024-09-13T12:16:05.826Z | 2024-09-16T12:21:11.578Z |
5053141 | 5053141 | 20240907233348_wuVys | BG000H | 2024-09-13T12:15:49.581Z | 2024-09-16T12:21:09.733Z |
5051510 | 5051510 | 20240907173810_1T7oV | BG000H | 2024-09-13T12:14:21.397Z | 2024-09-16T12:21:00.641Z |
5046884 | 5046884 | 20240909014420_Dhvh0 | BG000H | 2024-09-13T12:07:51.516Z | 2024-09-17T12:19:00.547Z |
5046787 | 5046787 | 20240909012150_fL1tZ | BG000H | 2024-09-13T12:07:31.211Z | 2024-09-17T12:19:00.321Z |
4995999 | 4995999 | 20240902182529_zvtDq | BG000H | 2024-09-08T12:04:16.669Z | 2024-09-11T12:20:50.158Z |
4981547 | 4981547 | 20240812002324_vv2xC | BG000H | 2024-09-06T12:14:33.138Z | 2024-09-06T12:14:33.138Z |
4980786 | 4980786 | 20240812001545_QbSFM | BG000H | 2024-09-06T12:14:16.979Z | 2024-09-06T12:14:16.979Z |
4979153 | 4979153 | 20240811235943_n4hEl | BG000H | 2024-09-06T12:13:00.191Z | 2024-09-06T12:13:00.191Z |
4977160 | 4977160 | 20240811233642_6EQ3n | BG000H | 2024-09-06T12:12:05.656Z | 2024-09-06T12:12:05.656Z |
4975779 | 4975779 | 20240811232150_8sL7n | BG000H | 2024-09-06T12:10:49.248Z | 2024-09-06T12:10:49.248Z |
4972488 | 4972488 | 20240811224635_rUKHK | BG000H | 2024-09-05T12:10:25.989Z | 2024-09-06T12:09:14.884Z |
4971716 | 4971716 | 20240811223857_92Fgc | BG000H | 2024-09-05T12:09:56.038Z | 2024-09-06T12:08:56.980Z |
4970819 | 4970819 | 20240811222842_hmUEQ | BG000H | 2024-09-05T12:09:32.472Z | 2024-09-06T12:08:44.972Z |
4970202 | 4970202 | 20240811222219_n7AhC | BG000H | 2024-09-05T12:09:21.272Z | 2024-09-06T12:08:29.547Z |
4969747 | 4969747 | 20240811221545_wZ9rl | BG000H | 2024-09-05T12:08:58.726Z | 2024-09-06T12:08:01.579Z |
4969640 | 4969640 | 20240811221353_vaM6E | BG000H | 2024-09-05T12:08:50.425Z | 2024-09-06T12:07:56.459Z |
4969268 | 4969268 | 20240811220854_idv0h | BG000H | 2024-09-05T12:08:39.030Z | 2024-09-06T12:07:47.839Z |
4966351 | 4966351 | 20240811212802_GFWa9 | BG000H | 2024-09-04T12:07:24.972Z | 2024-09-06T12:06:25.698Z |
4965082 | 4965082 | 20240811210842_y3hAp | BG000H | 2024-09-04T12:06:47.659Z | 2024-09-06T12:05:47.399Z |
4964158 | 4964158 | 20240811204739_HvLL3 | BG000H | 2024-09-04T12:06:10.306Z | 2024-09-06T12:05:12.720Z |
4963866 | 4963866 | 20240811203834_aaeMN | BG000H | 2024-09-04T12:05:58.645Z | 2024-09-06T12:05:02.027Z |
4963429 | 4963429 | 20240811201015_3Gx0s | BG000H | 2024-09-04T12:05:33.994Z | 2024-09-06T12:04:38.744Z |
4963155 | 4963155 | 20240811194721_PUENf | BG000H | 2024-09-04T12:05:16.113Z | 2024-09-06T12:04:20.352Z |
4963067 | 4963067 | 20240811194102_r0fUy | BG000H | 2024-09-04T12:05:08.910Z | 2024-09-06T12:04:16.847Z |
4950336 | 4950336 | 20240811020525_Xeg46 | BG000H | 2024-09-02T12:16:22.791Z | 2024-09-06T12:27:43.330Z |
4949394 | 4949394 | 20240811014836_Fim32 | BG000H | 2024-09-02T12:15:44.604Z | 2024-09-06T12:27:32.633Z |
4949185 | 4949185 | 20240811014628_dvb2m | BG000H | 2024-09-02T12:15:39.935Z | 2024-09-06T12:27:30.630Z |
4947250 | 4947250 | 20240811011511_cj3Xt | BG000H | 2024-09-02T12:14:20.597Z | 2024-09-06T12:26:47.906Z |
4942400 | 4942400 | 20240810235128_DGu7W | BG000H | 2024-09-02T12:11:11.315Z | 2024-09-06T12:24:15.222Z |
4942017 | 4942017 | 20240810234351_VEuo2 | BG000H | 2024-09-02T12:10:59.786Z | 2024-09-06T12:24:02.749Z |
4940934 | 4940934 | 20240810232202_BzwwO | BG000H | 2024-09-01T12:10:46.473Z | 2024-09-06T12:23:41.324Z |
4939784 | 4939784 | 20240810225634_x2Fo2 | BG000H | 2024-09-01T12:10:08.679Z | 2024-09-06T12:23:27.324Z |
4938726 | 4938726 | 20240810222653_m4s5f | BG000H | 2024-09-01T12:09:18.134Z | 2024-09-06T12:23:01.449Z |
4936719 | 4936719 | 20240810212841_NAU3H | BG000H | 2024-09-01T12:07:42.481Z | 2024-09-06T12:21:44.758Z |
4936272 | 4936272 | 20240810210858_TQ2FL | BG000H | 2024-09-01T12:07:22.816Z | 2024-09-06T12:21:24.812Z |
4935526 | 4935526 | 20240810202513_CRvOe | BG000H | 2024-09-01T12:06:34.864Z | 2024-09-06T12:20:44.000Z |
4935486 | 4935486 | 20240810202236_nHlpN | BG000H | 2024-09-01T12:06:32.563Z | 2024-09-06T12:20:41.414Z |
4934729 | 4934729 | 20240810185254_nAP6X | BG000H | 2024-09-01T12:05:44.175Z | 2024-09-06T12:20:19.272Z |
4934581 | 4934581 | 20240810183442_eBY3R | BG000H | 2024-09-01T12:05:32.292Z | 2024-09-06T12:20:15.337Z |
4901751 | 4901751 | 20240808014519_AK3fU | BG000H | 2024-08-28T12:18:49.927Z | 2024-08-28T12:18:49.927Z |
4899856 | 4899856 | 20240807232613_DXAL4 | BG000H | 2024-08-28T12:17:30.945Z | 2024-08-28T12:17:30.945Z |
4898931 | 4898931 | 20240807222023_24RV2 | BG000H | 2024-08-28T12:16:58.524Z | 2024-08-28T12:16:58.524Z |
4898885 | 4898885 | 20240807221659_CFv2n | BG000H | 2024-08-28T12:16:55.759Z | 2024-08-28T12:16:55.759Z |
4898626 | 4898626 | 20240807215303_fXmmZ | BG000H | 2024-08-28T12:16:44.467Z | 2024-08-28T12:16:44.467Z |
4898230 | 4898230 | 20240807211319_pmkqu | BG000H | 2024-08-28T12:16:21.750Z | 2024-08-28T12:16:21.750Z |
4897987 | 4897987 | 20240807202452_A5Otn | BG000H | 2024-08-28T12:16:08.379Z | 2024-08-28T12:16:08.379Z |
4891927 | 4891927 | 20240809014843_N7rLB | BG000H | 2024-08-28T12:09:38.500Z | 2024-08-30T12:21:32.882Z |
4891892 | 4891892 | 20240809014603_gbN62 | BG000H | 2024-08-28T12:09:36.715Z | 2024-08-30T12:21:30.757Z |
4891729 | 4891729 | 20240809013240_sRhdp | BG000H | 2024-08-28T12:09:19.399Z | 2024-08-30T12:21:23.336Z |
4891545 | 4891545 | 20240809011140_1YhTw | BG000H | 2024-08-28T12:09:09.516Z | 2024-08-30T12:21:17.598Z |
4891346 | 4891346 | 20240809005040_IfRmD | BG000H | 2024-08-28T12:08:54.158Z | 2024-08-30T12:21:10.220Z |
4891181 | 4891181 | 20240809003319_gZtfq | BG000H | 2024-08-28T12:08:41.167Z | 2024-08-30T12:21:01.557Z |
4891110 | 4891110 | 20240809002658_pw7j6 | BG000H | 2024-08-28T12:08:36.765Z | 2024-08-30T12:20:57.357Z |
4891054 | 4891054 | 20240809002033_kbMw6 | BG000H | 2024-08-28T12:08:32.345Z | 2024-08-30T12:20:52.361Z |
4891044 | 4891044 | 20240809001945_dHWfV | BG000H | 2024-08-28T12:08:31.596Z | 2024-08-30T12:20:51.842Z |
4890980 | 4890980 | 20240809001322_JQeRd | BG000H | 2024-08-28T12:08:24.053Z | 2024-08-30T12:20:45.430Z |
4890830 | 4890830 | 20240808235511_b2e7W | BG000H | 2024-08-28T12:08:12.710Z | 2024-08-30T12:20:33.158Z |
4890532 | 4890532 | 20240808232020_kA0Tr | BG000H | 2024-08-28T12:07:51.065Z | 2024-08-30T12:20:18.987Z |
4890427 | 4890427 | 20240808230910_mBGfh | BG000H | 2024-08-28T12:07:41.878Z | 2024-08-30T12:20:15.725Z |
4890421 | 4890421 | 20240808230832_2XsBj | BG000H | 2024-08-28T12:07:41.206Z | 2024-08-30T12:20:15.359Z |
4890223 | 4890223 | 20240808224642_UU0GA | BG000H | 2024-08-28T12:07:25.035Z | 2024-08-30T12:20:08.677Z |
4882023 | 4882023 | 20240807015906_4oZtp | BG000H | 2024-08-20T12:14:24.468Z | 2024-08-27T12:15:25.294Z |
4882008 | 4882008 | 20240807015835_1HbvZ | BG000H | 2024-08-20T12:14:24.177Z | 2024-08-27T12:15:25.025Z |
4881127 | 4881127 | 20240807013720_xJWJm | BG000H | 2024-08-20T12:13:47.327Z | 2024-08-27T12:15:02.039Z |
4880514 | 4880514 | 20240807012217_pzRZT | BG000H | 2024-08-20T12:13:28.241Z | 2024-08-27T12:14:45.415Z |
4879354 | 4879354 | 20240807005201_DN2cU | BG000H | 2024-08-20T12:12:49.209Z | 2024-08-27T12:14:11.093Z |
4879031 | 4879031 | 20240807004546_obtuT | BG000H | 2024-08-19T12:14:35.394Z | 2024-08-27T12:14:04.456Z |
4878744 | 4878744 | 20240807003452_zkwiz | BG000H | 2024-08-19T12:14:20.406Z | 2024-08-27T12:13:48.192Z |
4877739 | 4877739 | 20240807001106_2rHo1 | BG000H | 2024-08-19T12:13:50.477Z | 2024-08-27T12:13:18.111Z |
4874573 | 4874573 | 20240806225255_UN92r | BG000H | 2024-08-19T12:11:30.752Z | 2024-08-27T12:11:48.630Z |
4871431 | 4871431 | 20240806202809_NXcax | BG000H | 2024-08-19T12:09:05.122Z | 2024-08-27T12:09:44.671Z |
4856199 | 4856199 | 20240806012236_whfvM | BG000H | 2024-08-17T12:20:57.653Z | 2024-08-19T12:27:15.846Z |
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);