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

7,591 rows where station_code = "BE0007" 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
9610781 9610781 20260404214457_L4T8E BE0007 2026-04-06T12:11:22.514Z 2026-04-06T12:16:14.660Z
9604932 9604932 20260402020512_VVLE3 BE0007 2026-04-03T12:12:20.903Z 2026-04-06T12:26:33.278Z
9604926 9604926 20260402020345_9Zjd3 BE0007 2026-04-03T12:12:19.675Z 2026-04-06T12:26:32.809Z
9602774 9602774 20260402031518_dO3bc BE0007 2026-04-03T12:00:33.303Z 2026-04-06T12:21:11.224Z
9602755 9602755 20260402030000_elcDT BE0007 2026-04-03T12:00:28.398Z 2026-04-06T12:21:08.208Z
9602655 9602655 20260401015312_rFJVT BE0007 2026-04-02T12:09:44.370Z 2026-04-06T12:29:31.084Z
9600698 9600698 20260331011912_FXW9K BE0007 2026-04-01T12:11:34.936Z 2026-04-06T12:33:46.603Z
9600669 9600669 20260331004116_f82B4 BE0007 2026-04-01T12:11:28.666Z 2026-04-06T12:33:44.779Z
9598730 9598730 20260331035235_YJPsk BE0007 2026-04-01T12:00:46.142Z 2026-04-06T12:26:54.001Z
9598661 9598661 20260331023332_c0uFZ BE0007 2026-04-01T12:00:23.721Z 2026-04-06T12:26:44.808Z
9598642 9598642 20260331020613_zmAeU BE0007 2026-04-01T12:00:18.088Z 2026-04-06T12:26:41.289Z
9588605 9588605 20260327000637_wybYs BE0007 2026-03-28T12:11:27.865Z 2026-04-04T12:42:21.562Z
9588469 9588469 20260326231423_cw9Ja BE0007 2026-03-28T12:11:13.434Z 2026-04-04T12:42:09.700Z
9585717 9585717 20260327021503_2lW8N BE0007 2026-03-28T12:01:06.446Z 2026-04-05T12:32:36.132Z
9585446 9585446 20260327010224_Bit28 BE0007 2026-03-28T12:00:22.428Z 2026-04-05T12:32:21.707Z
9585094 9585094 20260325232537_HbvJb BE0007 2026-03-27T12:16:43.498Z 2026-04-03T12:39:49.360Z
9579733 9579733 20260324223335_JrUoz BE0007 2026-03-26T12:14:18.311Z 2026-04-02T12:37:27.816Z
9579616 9579616 20260324215830_BzACQ BE0007 2026-03-26T12:14:05.157Z 2026-04-02T12:37:18.002Z
9579434 9579434 20260324202848_EGBRA BE0007 2026-03-26T12:13:40.588Z 2026-04-02T12:37:09.796Z
9575557 9575557 20260323231926_DpbCr BE0007 2026-03-25T12:21:24.203Z 2026-03-31T12:29:01.855Z
9575448 9575448 20260323221119_GbtkV BE0007 2026-03-25T12:21:10.102Z 2026-03-31T12:28:57.832Z
9575436 9575436 20260323220741_93zCz BE0007 2026-03-25T12:21:05.235Z 2026-03-31T12:28:57.483Z
9571521 9571521 20260324024500_02FU3 BE0007 2026-03-25T12:01:48.049Z 2026-04-02T12:34:30.487Z
9570713 9570713 20260322223445_wVKa5 BE0007 2026-03-24T12:23:40.510Z 2026-03-30T12:30:48.266Z
9570699 9570699 20260322223213_PSoDo BE0007 2026-03-24T12:23:39.145Z 2026-03-30T12:30:48.032Z
9570613 9570613 20260322221515_8gYjM BE0007 2026-03-24T12:23:32.521Z 2026-03-30T12:30:46.595Z
9570585 9570585 20260322221013_uieox BE0007 2026-03-24T12:23:30.263Z 2026-03-30T12:30:46.077Z
9570572 9570572 20260322220414_GrUiP BE0007 2026-03-24T12:23:28.985Z 2026-03-30T12:30:45.722Z
9570416 9570416 20260322211640_Q1k0t BE0007 2026-03-24T12:23:14.380Z 2026-03-30T12:30:42.419Z
9562653 9562653 20260323025603_VWPZ1 BE0007 2026-03-24T12:03:40.923Z 2026-03-31T12:26:16.774Z
9562628 9562628 20260323025141_wL4Xq BE0007 2026-03-24T12:03:36.195Z 2026-03-31T12:26:16.101Z
9562203 9562203 20260323014921_IDav2 BE0007 2026-03-24T12:02:27.096Z 2026-03-31T12:26:03.705Z
9562113 9562113 20260323013348_2GEHc BE0007 2026-03-24T12:02:11.032Z 2026-03-31T12:26:01.577Z
9561928 9561928 20260323005834_2Aa4m BE0007 2026-03-24T12:01:38.138Z 2026-03-31T12:25:56.898Z
9561739 9561739 20260323003645_Zz1U3 BE0007 2026-03-24T12:01:08.843Z 2026-03-31T12:25:52.406Z
9561731 9561731 20260323003553_VUYVu BE0007 2026-03-24T12:01:07.189Z 2026-03-31T12:25:52.247Z
9561569 9561569 20260323000457_lFAdp BE0007 2026-03-24T12:00:30.512Z 2026-03-31T12:25:47.298Z
9561229 9561229 20260321231058_qI8jC BE0007 2026-03-23T12:12:14.572Z 2026-03-29T12:21:05.862Z
9560585 9560585 20260321214608_1nNJS BE0007 2026-03-23T12:11:58.353Z 2026-03-29T12:21:01.595Z
9560507 9560507 20260321213414_31L8o BE0007 2026-03-23T12:11:49.623Z 2026-03-29T12:21:00.859Z
9560487 9560487 20260321213227_dkuXo BE0007 2026-03-23T12:11:49.007Z 2026-03-29T12:21:00.707Z
9560055 9560055 20260321202747_5GT6f BE0007 2026-03-23T12:11:36.831Z 2026-03-29T12:20:57.553Z
9559983 9559983 20260321201802_A2NJI BE0007 2026-03-23T12:11:35.514Z 2026-03-29T12:20:57.162Z
9559682 9559682 20260321192650_ItQ4o BE0007 2026-03-23T12:11:27.059Z 2026-03-29T12:20:46.287Z
9555055 9555055 20260322040139_G4p5R BE0007 2026-03-23T12:03:08.058Z 2026-03-30T12:28:13.833Z
9554222 9554222 20260322025051_WScPb BE0007 2026-03-23T12:02:21.421Z 2026-03-30T12:28:00.937Z
9553080 9553080 20260322010930_mWB3n BE0007 2026-03-23T12:01:12.207Z 2026-03-30T12:27:34.638Z
9552870 9552870 20260322005029_GBjsL BE0007 2026-03-23T12:00:57.899Z 2026-03-30T12:27:31.661Z
9552657 9552657 20260322002844_aPrn4 BE0007 2026-03-23T12:00:41.008Z 2026-03-30T12:27:27.704Z
9543482 9543482 20260321040156_7mhK0 BE0007 2026-03-22T12:03:56.945Z 2026-03-29T12:19:08.163Z
9543351 9543351 20260321033612_qpUDD BE0007 2026-03-22T12:03:32.451Z 2026-03-29T12:19:06.488Z
9543167 9543167 20260321025447_BemmT BE0007 2026-03-22T12:02:54.534Z 2026-03-29T12:19:03.899Z
9542997 9542997 20260321021424_2aG85 BE0007 2026-03-22T12:02:18.393Z 2026-03-29T12:19:01.041Z
9542936 9542936 20260321015717_t9Kba BE0007 2026-03-22T12:02:07.830Z 2026-03-29T12:19:00.482Z
9542669 9542669 20260321004410_n7sSB BE0007 2026-03-22T12:01:11.672Z 2026-03-29T12:18:56.840Z
9542581 9542581 20260321001642_mhcTc BE0007 2026-03-22T12:00:51.007Z 2026-03-29T12:18:45.978Z
9542074 9542074 20260319224728_rHNHV BE0007 2026-03-21T12:29:39.249Z 2026-03-27T12:42:45.044Z
9534814 9534814 20260320042729_KSXNL BE0007 2026-03-21T12:08:58.589Z 2026-03-28T12:34:22.567Z
9534634 9534634 20260320041009_qyrJN BE0007 2026-03-21T12:08:32.484Z 2026-03-28T12:34:20.455Z
9534121 9534121 20260320032825_4dk2Y BE0007 2026-03-21T12:07:12.613Z 2026-03-28T12:34:14.430Z
9533651 9533651 20260320024845_A7XQC BE0007 2026-03-21T12:05:56.747Z 2026-03-28T12:33:57.495Z
9533597 9533597 20260320024552_NZy2f BE0007 2026-03-21T12:05:52.203Z 2026-03-28T12:33:56.899Z
9533312 9533312 20260320022359_wbm8C BE0007 2026-03-21T12:05:08.661Z 2026-03-28T12:33:51.864Z
9532706 9532706 20260320011957_6Mear BE0007 2026-03-21T12:03:26.383Z 2026-03-28T12:33:35.408Z
9532603 9532603 20260320011014_8toPZ BE0007 2026-03-21T12:03:09.050Z 2026-03-28T12:33:34.459Z
9532148 9532148 20260320002250_T3Ge5 BE0007 2026-03-21T12:01:50.927Z 2026-03-28T12:33:24.944Z
9532117 9532117 20260320002035_htqt3 BE0007 2026-03-21T12:01:45.783Z 2026-03-28T12:33:24.748Z
9531633 9531633 20260319233043_ublfA BE0007 2026-03-21T12:00:24.468Z 2026-03-28T12:33:19.647Z
9531475 9531475 20260318231451_OspPc BE0007 2026-03-20T12:25:20.012Z 2026-03-26T12:39:19.666Z
9531458 9531458 20260318231344_LdE6p BE0007 2026-03-20T12:25:19.161Z 2026-03-26T12:39:19.568Z
9531333 9531333 20260318225820_C1hvJ BE0007 2026-03-20T12:25:07.030Z 2026-03-26T12:39:18.866Z
9531231 9531231 20260318224809_2VpZk BE0007 2026-03-20T12:25:02.763Z 2026-03-26T12:39:18.275Z
9530589 9530589 20260318211428_baHdY BE0007 2026-03-20T12:24:30.996Z 2026-03-26T12:39:14.123Z
9521476 9521476 20260319041913_5WqW9 BE0007 2026-03-20T12:08:04.309Z 2026-03-27T12:40:55.141Z
9521130 9521130 20260319035504_ZrGXO BE0007 2026-03-20T12:07:33.992Z 2026-03-27T12:40:51.954Z
9520894 9520894 20260319034415_q2Jnj BE0007 2026-03-20T12:07:13.039Z 2026-03-27T12:40:48.903Z
9520615 9520615 20260319032816_500lq BE0007 2026-03-20T12:06:42.138Z 2026-03-27T12:40:45.553Z
9520184 9520184 20260319030119_eotnl BE0007 2026-03-20T12:05:55.473Z 2026-03-27T12:40:40.253Z
9520138 9520138 20260319025534_HJHCm BE0007 2026-03-20T12:05:48.750Z 2026-03-27T12:40:39.475Z
9519966 9519966 20260319024554_QVhet BE0007 2026-03-20T12:05:27.194Z 2026-03-27T12:40:37.407Z
9519630 9519630 20260319022359_3IcOx BE0007 2026-03-20T12:04:48.156Z 2026-03-27T12:40:33.574Z
9519427 9519427 20260319020958_01Kzk BE0007 2026-03-20T12:04:27.648Z 2026-03-27T12:40:31.015Z
9519143 9519143 20260319015325_I7tVN BE0007 2026-03-20T12:04:01.185Z 2026-03-27T12:40:18.662Z
9518579 9518579 20260319011140_ral4O BE0007 2026-03-20T12:02:54.217Z 2026-03-27T12:40:11.647Z
9518253 9518253 20260319004629_g40In BE0007 2026-03-20T12:02:12.829Z 2026-03-27T12:40:07.966Z
9517594 9517594 20260318234325_zJESm BE0007 2026-03-20T12:00:47.375Z 2026-03-27T12:40:01.219Z
9516383 9516383 20260317204140_Yscse BE0007 2026-03-19T12:26:06.165Z 2026-03-25T12:42:55.312Z
9512028 9512028 20260318043522_yHS2H BE0007 2026-03-19T12:11:30.881Z 2026-03-26T12:37:41.677Z
9510712 9510712 20260318031004_b5T3D BE0007 2026-03-19T12:08:25.241Z 2026-03-26T12:37:15.797Z
9510701 9510701 20260318030946_aOLDi BE0007 2026-03-19T12:08:23.656Z 2026-03-26T12:37:15.700Z
9510698 9510698 20260318030946_Mby4X BE0007 2026-03-19T12:08:23.231Z 2026-03-26T12:37:15.690Z
9510552 9510552 20260318025953_FRFyJ BE0007 2026-03-19T12:07:58.521Z 2026-03-26T12:37:14.441Z
9510547 9510547 20260318025952_TNqP1 BE0007 2026-03-19T12:07:58.215Z 2026-03-26T12:37:14.428Z
9509435 9509435 20260318014837_66K5g BE0007 2026-03-19T12:05:18.659Z 2026-03-26T12:37:05.463Z
9508931 9508931 20260318011557_enkwb BE0007 2026-03-19T12:04:05.935Z 2026-03-26T12:37:01.813Z
9508286 9508286 20260318004125_bnB1v BE0007 2026-03-19T12:02:49.547Z 2026-03-26T12:36:57.576Z
9508194 9508194 20260318003340_X1dJE BE0007 2026-03-19T12:02:35.464Z 2026-03-26T12:36:56.931Z
9507746 9507746 20260317233831_XeeN5 BE0007 2026-03-19T12:01:08.950Z 2026-03-26T12:36:53.074Z
9507393 9507393 20260316215428_1KiO9 BE0007 2026-03-18T12:20:23.493Z 2026-03-24T12:41:47.018Z
9492645 9492645 20260314213145_81u1M BE0007 2026-03-16T12:28:53.865Z 2026-03-22T12:42:53.675Z

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