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,048 rows where station_code = "BE0011" 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
9610585 9610585 20260404204519_G17m3 BE0011 2026-04-06T12:10:14.402Z 2026-04-06T12:16:14.612Z
9610551 9610551 20260404202408_5Hztl BE0011 2026-04-06T12:10:06.760Z 2026-04-06T12:16:14.600Z
9607040 9607040 20260404031741_f2rK6 BE0011 2026-04-05T12:00:13.477Z 2026-04-06T12:16:14.348Z
9595322 9595322 20260330033039_oBquB BE0011 2026-03-31T12:01:08.361Z 2026-04-06T12:29:57.886Z
9595103 9595103 20260330022311_NPZW6 BE0011 2026-03-31T12:00:29.181Z 2026-04-06T12:29:40.638Z
9592760 9592760 20260329031908_fSKk3 BE0011 2026-03-30T12:01:52.282Z 2026-04-06T12:34:27.140Z
9592744 9592744 20260329031221_kHbs6 BE0011 2026-03-30T12:01:49.024Z 2026-04-06T12:34:25.909Z
9588634 9588634 20260327001351_EhDnr BE0011 2026-03-28T12:11:30.059Z 2026-04-04T12:42:23.339Z
9585388 9585388 20260327004412_IB9Up BE0011 2026-03-28T12:00:10.881Z 2026-04-05T12:32:18.912Z
9585267 9585267 20260326000508_kTyNj BE0011 2026-03-27T12:17:02.921Z 2026-04-03T12:39:53.635Z
9582044 9582044 20260326042319_7aZCk BE0011 2026-03-27T12:04:27.764Z 2026-04-04T12:39:35.724Z
9581901 9581901 20260326041031_apVh6 BE0011 2026-03-27T12:04:06.325Z 2026-04-04T12:39:30.785Z
9579607 9579607 20260324215638_aOKKH BE0011 2026-03-26T12:14:04.509Z 2026-04-02T12:37:17.786Z
9579462 9579462 20260324204321_WI4u5 BE0011 2026-03-26T12:13:44.784Z 2026-04-02T12:37:11.054Z
9577166 9577166 20260325040629_bk3OO BE0011 2026-03-26T12:04:17.659Z 2026-04-03T12:36:36.886Z
9576308 9576308 20260325015101_FJoM6 BE0011 2026-03-26T12:01:53.738Z 2026-04-03T12:35:52.707Z
9576187 9576187 20260325013217_UBco7 BE0011 2026-03-26T12:01:31.057Z 2026-04-03T12:35:47.775Z
9575765 9575765 20260320205448_q5vne BE0011 2026-03-25T12:35:55.694Z 2026-03-28T12:37:00.140Z
9575755 9575755 20260321223922_Wp48H BE0011 2026-03-25T12:31:49.392Z 2026-03-29T12:21:04.223Z
9575709 9575709 20260321030724_ExeTv BE0011 2026-03-25T12:28:01.469Z 2026-03-29T12:19:04.673Z
9575705 9575705 20260321023018_eYd2j BE0011 2026-03-25T12:27:55.659Z 2026-03-29T12:19:02.527Z
9575686 9575686 20260322214059_np1eK BE0011 2026-03-25T12:26:58.869Z 2026-03-30T12:30:44.302Z
9575679 9575679 20260322204538_DHHN9 BE0011 2026-03-25T12:26:52.937Z 2026-03-30T12:30:40.790Z
9575672 9575672 20260322200811_KEKp3 BE0011 2026-03-25T12:26:46.891Z 2026-03-30T12:30:37.657Z
9575665 9575665 20260322030427_4bGYg BE0011 2026-03-25T12:23:01.861Z 2026-03-30T12:28:03.087Z
9575659 9575659 20260322020432_NjxxC BE0011 2026-03-25T12:22:36.267Z 2026-03-30T12:27:50.628Z
9575657 9575657 20260322015507_IJ7mD BE0011 2026-03-25T12:22:33.784Z 2026-03-30T12:27:49.587Z
9575651 9575651 20260322011155_ZtiI8 BE0011 2026-03-25T12:22:11.573Z 2026-03-30T12:27:34.943Z
9571231 9571231 20260324004327_dxpdd BE0011 2026-03-25T12:00:33.718Z 2026-04-02T12:34:14.615Z
9517199 9517199 20260317225314_2jrsu BE0011 2026-03-19T12:27:18.865Z 2026-03-25T12:43:09.309Z
9517174 9517174 20260317224942_HQPfM BE0011 2026-03-19T12:27:16.578Z 2026-03-25T12:43:09.093Z
9516482 9516482 20260317205833_iQQ3C BE0011 2026-03-19T12:26:16.317Z 2026-03-25T12:42:59.813Z
9516296 9516296 20260317202620_dXCX4 BE0011 2026-03-19T12:25:54.769Z 2026-03-25T12:42:53.352Z
9516123 9516123 20260317200550_4Zi5O BE0011 2026-03-19T12:25:42.289Z 2026-03-25T12:42:49.130Z
9512084 9512084 20260318044122_LUQSM BE0011 2026-03-19T12:11:40.738Z 2026-03-26T12:37:42.204Z
9512056 9512056 20260318043910_zdiyN BE0011 2026-03-19T12:11:37.559Z 2026-03-26T12:37:42.027Z
9511844 9511844 20260318042330_sZkcf BE0011 2026-03-19T12:11:09.985Z 2026-03-26T12:37:40.130Z
9511541 9511541 20260318040048_o3TRo BE0011 2026-03-19T12:10:25.576Z 2026-03-26T12:37:37.752Z
9511522 9511522 20260318035835_hi4RW BE0011 2026-03-19T12:10:23.551Z 2026-03-26T12:37:37.642Z
9511505 9511505 20260318035718_qpObw BE0011 2026-03-19T12:10:21.434Z 2026-03-26T12:37:37.483Z
9511457 9511457 20260318035504_ocqz4 BE0011 2026-03-19T12:10:15.933Z 2026-03-26T12:37:37.106Z
9511394 9511394 20260318034907_hSh2P BE0011 2026-03-19T12:10:05.716Z 2026-03-26T12:37:36.558Z
9511130 9511130 20260318033709_HMFpI BE0011 2026-03-19T12:09:31.954Z 2026-03-26T12:37:23.902Z
9511127 9511127 20260318033709_MXT8K BE0011 2026-03-19T12:09:31.473Z 2026-03-26T12:37:23.557Z
9510942 9510942 20260318032435_UYUnA BE0011 2026-03-19T12:09:03.145Z 2026-03-26T12:37:18.124Z
9510652 9510652 20260318030544_VbF3F BE0011 2026-03-19T12:08:12.682Z 2026-03-26T12:37:15.251Z
9510502 9510502 20260318025611_s20Fh BE0011 2026-03-19T12:07:48.540Z 2026-03-26T12:37:12.995Z
9509172 9509172 20260318012927_HcFrY BE0011 2026-03-19T12:04:41.144Z 2026-03-26T12:37:03.634Z
9509165 9509165 20260318012853_P3lih BE0011 2026-03-19T12:04:40.463Z 2026-03-26T12:37:03.596Z
9507849 9507849 20260317234907_G7d1M BE0011 2026-03-19T12:01:28.429Z 2026-03-26T12:36:53.967Z
9493117 9493117 20260314224616_QAS4P BE0011 2026-03-16T12:29:27.721Z 2026-03-22T12:42:56.850Z
9493103 9493103 20260314224314_kkqtq BE0011 2026-03-16T12:29:27.218Z 2026-03-22T12:42:56.817Z
9492891 9492891 20260314221134_dixCC BE0011 2026-03-16T12:29:08.772Z 2026-03-22T12:42:55.613Z
9492814 9492814 20260314220005_UJ4uO BE0011 2026-03-16T12:29:04.348Z 2026-03-22T12:42:54.742Z
9492731 9492731 20260314215038_X7oq3 BE0011 2026-03-16T12:29:00.031Z 2026-03-22T12:42:54.184Z
9492720 9492720 20260314214534_ZdB48 BE0011 2026-03-16T12:28:58.942Z 2026-03-22T12:42:54.134Z
9492717 9492717 20260314214533_q35X2 BE0011 2026-03-16T12:28:58.688Z 2026-03-22T12:42:54.109Z
9492558 9492558 20260314211925_CCLeN BE0011 2026-03-16T12:28:43.901Z 2026-03-22T12:42:53.118Z
9492239 9492239 20260314194843_F39wn BE0011 2026-03-16T12:28:10.988Z 2026-03-22T12:42:51.078Z
9492070 9492070 20260314190617_xMFsq BE0011 2026-03-16T12:27:59.867Z 2026-03-22T12:42:49.979Z
9492064 9492064 20260314190505_LAL9f BE0011 2026-03-16T12:27:59.167Z 2026-03-22T12:42:49.923Z
9486127 9486127 20260315045838_nUbgn BE0011 2026-03-16T12:08:45.915Z 2026-03-23T12:21:55.505Z
9485990 9485990 20260315042558_4LaMb BE0011 2026-03-16T12:08:15.400Z 2026-03-23T12:21:54.787Z
9485761 9485761 20260315035108_GPm9r BE0011 2026-03-16T12:07:32.452Z 2026-03-23T12:21:53.798Z
9485705 9485705 20260315034244_XamsA BE0011 2026-03-16T12:07:20.352Z 2026-03-23T12:21:53.562Z
9485609 9485609 20260315032314_L3Dkx BE0011 2026-03-16T12:06:57.273Z 2026-03-23T12:21:53.093Z
9485274 9485274 20260315024524_MUwuG BE0011 2026-03-16T12:05:53.065Z 2026-03-23T12:21:50.724Z
9485154 9485154 20260315023432_O9uQu BE0011 2026-03-16T12:05:27.787Z 2026-03-23T12:21:50.195Z
9485100 9485100 20260315022701_lEkj7 BE0011 2026-03-16T12:05:17.175Z 2026-03-23T12:21:49.999Z
9485006 9485006 20260315021326_lDQSi BE0011 2026-03-16T12:04:55.685Z 2026-03-23T12:21:49.523Z
9484994 9484994 20260315021109_NXu4F BE0011 2026-03-16T12:04:52.521Z 2026-03-23T12:21:49.463Z
9484965 9484965 20260315020655_oPuZP BE0011 2026-03-16T12:04:46.763Z 2026-03-23T12:21:49.197Z
9484900 9484900 20260315015428_bYysz BE0011 2026-03-16T12:04:33.349Z 2026-03-23T12:21:48.893Z
9484808 9484808 20260315014303_MMvn3 BE0011 2026-03-16T12:04:12.054Z 2026-03-23T12:21:48.463Z
9484520 9484520 20260315005350_3eRRt BE0011 2026-03-16T12:03:10.476Z 2026-03-23T12:21:47.166Z
9484377 9484377 20260315003011_Ps2jV BE0011 2026-03-16T12:02:38.007Z 2026-03-23T12:21:46.517Z
9468698 9468698 20260313002037_R7YHI BE0011 2026-03-14T12:01:26.231Z 2026-03-21T12:48:27.970Z
9467702 9467702 20260311223528_f3f0x BE0011 2026-03-13T12:19:42.567Z 2026-03-19T12:45:54.332Z
9467216 9467216 20260311205140_FWMuK BE0011 2026-03-13T12:18:45.397Z 2026-03-19T12:45:50.445Z
9467099 9467099 20260311200430_Vtqiu BE0011 2026-03-13T12:18:19.076Z 2026-03-19T12:45:48.138Z
9464354 9464354 20260312043435_60lNU BE0011 2026-03-13T12:07:03.122Z 2026-03-20T12:36:38.171Z
9464263 9464263 20260312040601_wswFX BE0011 2026-03-13T12:06:44.306Z 2026-03-20T12:36:34.892Z
9464248 9464248 20260312040455_lIvsp BE0011 2026-03-13T12:06:42.473Z 2026-03-20T12:36:34.424Z
9463340 9463340 20260312013549_XZb66 BE0011 2026-03-13T12:03:53.835Z 2026-03-20T12:36:22.008Z
9462893 9462893 20260312003120_P3WlF BE0011 2026-03-13T12:02:30.601Z 2026-03-20T12:36:18.752Z
9456502 9456502 20260310234420_daouB BE0011 2026-03-12T12:00:54.376Z 2026-03-19T12:44:17.752Z
9456492 9456492 20260310234323_urnuT BE0011 2026-03-12T12:00:52.933Z 2026-03-19T12:44:17.628Z
9456042 9456042 20260309213119_HuaAn BE0011 2026-03-11T12:15:32.737Z 2026-03-17T12:42:48.876Z
9455809 9455809 20260309203147_vuxU3 BE0011 2026-03-11T12:15:04.828Z 2026-03-17T12:42:39.448Z
9455664 9455664 20260309193518_WVQld BE0011 2026-03-11T12:14:44.640Z 2026-03-17T12:42:37.268Z
9455645 9455645 20260309193122_BCNAX BE0011 2026-03-11T12:14:43.103Z 2026-03-17T12:42:37.047Z
9455582 9455582 20260309185540_Jh3vH BE0011 2026-03-11T12:14:36.842Z 2026-03-17T12:42:35.972Z
9446238 9446238 20260309003349_vHVU7 BE0011 2026-03-10T12:01:37.972Z 2026-03-17T12:41:35.040Z
9446232 9446232 20260309003241_GU6yk BE0011 2026-03-10T12:01:35.335Z 2026-03-17T12:41:34.976Z
9446182 9446182 20260309001928_YwoL3 BE0011 2026-03-10T12:01:22.200Z 2026-03-17T12:41:34.411Z
9430515 9430515 20260304193043_s4YYk BE0011 2026-03-06T14:23:21.229Z 2026-03-12T12:33:37.424Z
9430488 9430488 20260304192140_TPNJ7 BE0011 2026-03-06T14:23:11.521Z 2026-03-12T12:33:36.323Z
9426414 9426414 20260305032622_NM528 BE0011 2026-03-06T14:04:45.338Z 2026-03-13T12:34:46.106Z
9426395 9426395 20260305032354_ergaE BE0011 2026-03-06T14:04:39.913Z 2026-03-13T12:34:45.901Z
9426208 9426208 20260305023445_wUVDO BE0011 2026-03-06T14:03:44.017Z 2026-03-13T12:34:43.633Z

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