home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,461 rows where station_code = "BE0017" sorted by created_at descending

✎ View and edit SQL

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
9606759 9606759 20260402203805_mE32p BE0017 2026-04-04T12:11:29.567Z 2026-04-06T12:23:39.422Z
9600442 9600442 20260330215929_WBBmS BE0017 2026-04-01T12:10:47.422Z 2026-04-06T12:33:26.002Z
9600401 9600401 20260330211323_gO17m BE0017 2026-04-01T12:10:37.181Z 2026-04-06T12:33:23.333Z
9598545 9598545 20260330010419_1M0lZ BE0017 2026-03-31T12:10:53.459Z 2026-04-06T12:36:45.216Z
9595110 9595110 20260330022335_QH0YE BE0017 2026-03-31T12:00:30.128Z 2026-04-06T12:29:40.895Z
9592461 9592461 20260329021216_v64kh BE0017 2026-03-30T12:01:01.952Z 2026-04-06T12:34:11.220Z
9592320 9592320 20260329015233_KoO2g BE0017 2026-03-30T12:00:40.707Z 2026-04-06T12:34:00.511Z
9588392 9588392 20260326222216_mX9Iv BE0017 2026-03-28T12:11:01.281Z 2026-04-04T12:42:04.102Z
9588378 9588378 20260326221348_5P3IE BE0017 2026-03-28T12:10:59.214Z 2026-04-04T12:42:02.539Z
9588336 9588336 20260326214915_wNeN2 BE0017 2026-03-28T12:10:53.996Z 2026-04-04T12:41:59.267Z
9588319 9588319 20260326213306_tQygn BE0017 2026-03-28T12:10:52.029Z 2026-04-04T12:41:58.106Z
9588302 9588302 20260326211254_mj8BW BE0017 2026-03-28T12:10:49.604Z 2026-04-04T12:41:56.594Z
9588247 9588247 20260326194758_ubu3K BE0017 2026-03-28T12:10:36.513Z 2026-04-04T12:41:50.905Z
9580341 9580341 20260326003545_jke0g BE0017 2026-03-27T12:00:13.625Z 2026-04-04T12:38:06.767Z
9579390 9579390 20260324194023_UwEQO BE0017 2026-03-26T12:13:32.197Z 2026-04-02T12:37:07.514Z
9576344 9576344 20260325015548_TXDyV BE0017 2026-03-26T12:01:59.611Z 2026-04-03T12:35:53.988Z
9576238 9576238 20260325014358_SIin5 BE0017 2026-03-26T12:01:40.471Z 2026-04-03T12:35:49.756Z
9575749 9575749 20260321212626_nGcsT BE0017 2026-03-25T12:31:40.664Z 2026-03-29T12:21:00.421Z
9575699 9575699 20260321013514_Zxba3 BE0017 2026-03-25T12:27:46.897Z 2026-03-29T12:18:59.033Z
9574643 9574643 20260323040630_R1MZZ BE0017 2026-03-25T12:12:46.457Z 2026-03-31T12:26:30.575Z
9561216 9561216 20260321230906_ybUYw BE0017 2026-03-23T12:12:13.918Z 2026-03-29T12:21:05.724Z
9560991 9560991 20260321224257_liCI6 BE0017 2026-03-23T12:12:08.978Z 2026-03-29T12:21:04.459Z
9560543 9560543 20260321213751_X9vQp BE0017 2026-03-23T12:11:51.258Z 2026-03-29T12:21:01.221Z
9559972 9559972 20260321201429_pfg9w BE0017 2026-03-23T12:11:35.025Z 2026-03-29T12:20:57.009Z
9555077 9555077 20260322040226_STb4T BE0017 2026-03-23T12:03:09.239Z 2026-03-30T12:28:14.203Z
9554436 9554436 20260322030711_QLUy9 BE0017 2026-03-23T12:02:31.812Z 2026-03-30T12:28:03.741Z
9553792 9553792 20260322021507_iMi6m BE0017 2026-03-23T12:01:52.347Z 2026-03-30T12:27:52.713Z
9552168 9552168 20260320230938_lrMQr BE0017 2026-03-22T12:27:30.704Z 2026-03-28T12:37:07.569Z
9552094 9552094 20260320225629_YZFPy BE0017 2026-03-22T12:27:26.943Z 2026-03-28T12:37:06.825Z
9551846 9551846 20260320215354_IauaW BE0017 2026-03-22T12:27:06.344Z 2026-03-28T12:37:02.787Z
9551760 9551760 20260320212607_tGuOs BE0017 2026-03-22T12:27:01.211Z 2026-03-28T12:37:01.732Z
9551672 9551672 20260320205130_uwnMS BE0017 2026-03-22T12:26:55.274Z 2026-03-28T12:36:59.809Z
9551561 9551561 20260320201954_tnU2z BE0017 2026-03-22T12:26:48.035Z 2026-03-28T12:36:58.100Z
9551335 9551335 20260320192557_swzyp BE0017 2026-03-22T12:26:26.394Z 2026-03-28T12:36:45.141Z
9542848 9542848 20260321013514_ZM4U5 BE0017 2026-03-22T12:01:46.992Z 2026-03-24T12:25:05.355Z
9541861 9541861 20260319215929_tUCUn BE0017 2026-03-21T12:29:26.769Z 2026-03-27T12:42:42.586Z
9533281 9533281 20260320022149_rqbRN BE0017 2026-03-21T12:05:03.060Z 2026-03-28T12:33:51.481Z
9532392 9532392 20260320005033_S4eCj BE0017 2026-03-21T12:02:34.333Z 2026-03-28T12:33:29.339Z
9532155 9532155 20260320002340_dhJM9 BE0017 2026-03-21T12:01:51.544Z 2026-03-28T12:33:24.979Z
9531906 9531906 20260320000003_7B3uI BE0017 2026-03-21T12:01:09.763Z 2026-03-28T12:33:22.677Z
9531200 9531200 20260318224122_spQLP BE0017 2026-03-20T12:25:01.378Z 2026-03-26T12:39:17.994Z
9531195 9531195 20260318224114_VtRQ9 BE0017 2026-03-20T12:25:01.189Z 2026-03-26T12:39:17.978Z
9530936 9530936 20260318220159_AGlE1 BE0017 2026-03-20T12:24:51.863Z 2026-03-26T12:39:16.604Z
9530930 9530930 20260318220158_HMqVx BE0017 2026-03-20T12:24:51.706Z 2026-03-26T12:39:16.584Z
9530781 9530781 20260318214149_SQTnp BE0017 2026-03-20T12:24:46.215Z 2026-03-26T12:39:15.430Z
9530695 9530695 20260318212539_2FDsu BE0017 2026-03-20T12:24:35.961Z 2026-03-26T12:39:14.838Z
9530527 9530527 20260318210453_Z3gli BE0017 2026-03-20T12:24:27.935Z 2026-03-26T12:39:13.352Z
9529913 9529913 20260318194204_iwbvE BE0017 2026-03-20T12:23:49.031Z 2026-03-26T12:39:07.421Z
9521736 9521736 20260319044027_ln2a4 BE0017 2026-03-20T12:08:29.224Z 2026-03-27T12:41:10.003Z
9521495 9521495 20260319042114_TZwOX BE0017 2026-03-20T12:08:07.995Z 2026-03-27T12:40:55.231Z
9520366 9520366 20260319031211_2R65J BE0017 2026-03-20T12:06:16.861Z 2026-03-27T12:40:42.352Z
9520107 9520107 20260319025355_3bWPA BE0017 2026-03-20T12:05:44.635Z 2026-03-27T12:40:39.040Z
9518605 9518605 20260319011306_GiZiH BE0017 2026-03-20T12:02:57.690Z 2026-03-27T12:40:11.779Z
9518480 9518480 20260319010338_y2uvB BE0017 2026-03-20T12:02:40.574Z 2026-03-27T12:40:10.368Z
9518472 9518472 20260319010307_SXWCU BE0017 2026-03-20T12:02:39.599Z 2026-03-27T12:40:10.196Z
9518148 9518148 20260319003428_x2qq5 BE0017 2026-03-20T12:01:58.569Z 2026-03-27T12:40:06.690Z
9517810 9517810 20260319000458_vsYSO BE0017 2026-03-20T12:01:20.839Z 2026-03-27T12:40:03.609Z
9517698 9517698 20260318235455_s7hCt BE0017 2026-03-20T12:01:02.969Z 2026-03-27T12:40:02.465Z
9517107 9517107 20260317224145_FFVFN BE0017 2026-03-19T12:27:11.607Z 2026-03-25T12:43:08.712Z
9516836 9516836 20260317220329_lSuQz BE0017 2026-03-19T12:26:49.837Z 2026-03-25T12:43:07.230Z
9516728 9516728 20260317214438_qJtNE BE0017 2026-03-19T12:26:42.001Z 2026-03-25T12:43:06.339Z
9516594 9516594 20260317211431_5XZsY BE0017 2026-03-19T12:26:31.755Z 2026-03-25T12:43:03.716Z
9516488 9516488 20260317205847_kwh1s BE0017 2026-03-19T12:26:16.689Z 2026-03-25T12:42:59.880Z
9516033 9516033 20260317194513_XFXZx BE0017 2026-03-19T12:25:32.923Z 2026-03-25T12:42:46.368Z
9511921 9511921 20260318042914_lTj65 BE0017 2026-03-19T12:11:20.342Z 2026-03-26T12:37:40.823Z
9511901 9511901 20260318042758_VZahA BE0017 2026-03-19T12:11:17.896Z 2026-03-26T12:37:40.684Z
9511718 9511718 20260318041239_5Igkq BE0017 2026-03-19T12:10:49.729Z 2026-03-26T12:37:39.119Z
9511078 9511078 20260318033523_zaw1A BE0017 2026-03-19T12:09:25.077Z 2026-03-26T12:37:19.299Z
9510592 9510592 20260318030039_EWzhe BE0017 2026-03-19T12:08:02.958Z 2026-03-26T12:37:14.585Z
9510319 9510319 20260318024434_57guO BE0017 2026-03-19T12:07:21.586Z 2026-03-26T12:37:11.531Z
9510290 9510290 20260318024229_jSG1a BE0017 2026-03-19T12:07:17.393Z 2026-03-26T12:37:11.341Z
9509953 9509953 20260318022320_Sy7sz BE0017 2026-03-19T12:06:31.781Z 2026-03-26T12:37:08.768Z
9509696 9509696 20260318020735_FKD5R BE0017 2026-03-19T12:05:59.036Z 2026-03-26T12:37:07.083Z
9509691 9509691 20260318020735_Lta28 BE0017 2026-03-19T12:05:58.798Z 2026-03-26T12:37:07.065Z
9509658 9509658 20260318020522_r6Dke BE0017 2026-03-19T12:05:52.597Z 2026-03-26T12:37:06.830Z
9509206 9509206 20260318013251_Rax3n BE0017 2026-03-19T12:04:46.252Z 2026-03-26T12:37:03.868Z
9508247 9508247 20260318003628_w4QEI BE0017 2026-03-19T12:02:43.176Z 2026-03-26T12:36:57.260Z
9507954 9507954 20260317235753_lnzc9 BE0017 2026-03-19T12:01:47.125Z 2026-03-26T12:36:54.673Z
9507773 9507773 20260317234224_iRRL7 BE0017 2026-03-19T12:01:14.010Z 2026-03-26T12:36:53.344Z
9507549 9507549 20260317231739_tyh7C BE0017 2026-03-19T12:00:30.858Z 2026-03-26T12:36:40.647Z
9493018 9493018 20260314223136_tAkvk BE0017 2026-03-16T12:29:16.996Z 2026-03-22T12:42:56.357Z
9492886 9492886 20260314221040_v4h1W BE0017 2026-03-16T12:29:08.401Z 2026-03-22T12:42:55.587Z
9492382 9492382 20260314203954_8JWVu BE0017 2026-03-16T12:28:30.248Z 2026-03-22T12:42:52.041Z
9492266 9492266 20260314195856_C6Km3 BE0017 2026-03-16T12:28:14.812Z 2026-03-22T12:42:51.415Z
9486121 9486121 20260315045535_JXAKc BE0017 2026-03-16T12:08:44.047Z 2026-03-23T12:21:55.443Z
9486028 9486028 20260315043440_OkqFs BE0017 2026-03-16T12:08:23.713Z 2026-03-23T12:21:55.028Z
9485837 9485837 20260315040011_zgTCP BE0017 2026-03-16T12:07:48.582Z 2026-03-23T12:21:54.277Z
9485825 9485825 20260315035951_POuJf BE0017 2026-03-16T12:07:47.052Z 2026-03-23T12:21:54.253Z
9485695 9485695 20260315034150_Io7o2 BE0017 2026-03-16T12:07:18.379Z 2026-03-23T12:21:53.513Z
9485668 9485668 20260315033753_bPtGA BE0017 2026-03-16T12:07:11.102Z 2026-03-23T12:21:53.372Z
9485371 9485371 20260315025709_lKfw0 BE0017 2026-03-16T12:06:11.771Z 2026-03-23T12:21:51.561Z
9485297 9485297 20260315024743_yBEFu BE0017 2026-03-16T12:05:57.996Z 2026-03-23T12:21:50.873Z
9485256 9485256 20260315024206_AfvbA BE0017 2026-03-16T12:05:47.674Z 2026-03-23T12:21:50.608Z
9485204 9485204 20260315023946_pWbB9 BE0017 2026-03-16T12:05:36.673Z 2026-03-23T12:21:50.453Z
9485189 9485189 20260315023831_P217v BE0017 2026-03-16T12:05:34.141Z 2026-03-23T12:21:50.417Z
9485082 9485082 20260315022426_zKLxB BE0017 2026-03-16T12:05:12.933Z 2026-03-23T12:21:49.940Z
9485075 9485075 20260315022213_3wRIe BE0017 2026-03-16T12:05:11.009Z 2026-03-23T12:21:49.883Z
9485025 9485025 20260315021554_wK3WZ BE0017 2026-03-16T12:04:59.111Z 2026-03-23T12:21:49.621Z
9484795 9484795 20260315014218_lvjny BE0017 2026-03-16T12:04:09.664Z 2026-03-23T12:21:48.415Z
9484706 9484706 20260315013143_uKE0H BE0017 2026-03-16T12:03:50.960Z 2026-03-23T12:21:48.030Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network