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

5,693 rows where station_code = "BE000A" 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
9606777 9606777 20260402205821_Ngu6M BE000A 2026-04-04T12:11:39.633Z 2026-04-06T12:23:43.241Z
9592893 9592893 20260329034906_pJjtf BE000A 2026-03-30T12:02:14.910Z 2026-04-06T12:34:39.379Z
9588623 9588623 20260327001020_ElTCY BE000A 2026-03-28T12:11:29.088Z 2026-04-04T12:42:22.540Z
9585696 9585696 20260327020805_7VWQH BE000A 2026-03-28T12:01:02.866Z 2026-04-05T12:32:35.308Z
9585657 9585657 20260327020309_styAQ BE000A 2026-03-28T12:00:57.047Z 2026-04-05T12:32:33.621Z
9585507 9585507 20260327012307_kSCfi BE000A 2026-03-28T12:00:32.084Z 2026-04-05T12:32:24.457Z
9571060 9571060 20260322234215_1C6OQ BE000A 2026-03-24T12:24:17.866Z 2026-03-30T12:30:54.604Z
9570893 9570893 20260322230942_Fv4GF BE000A 2026-03-24T12:23:59.104Z 2026-03-30T12:30:51.442Z
9561396 9561396 20260321232925_9dULx BE000A 2026-03-23T12:12:18.187Z 2026-03-29T12:21:06.969Z
9561105 9561105 20260321230118_YmuKo BE000A 2026-03-23T12:12:11.765Z 2026-03-29T12:21:05.202Z
9560168 9560168 20260321203958_k2CdF BE000A 2026-03-23T12:11:39.441Z 2026-03-29T12:20:58.345Z
9554556 9554556 20260322031713_IUZ6s BE000A 2026-03-23T12:02:40.511Z 2026-03-30T12:28:05.552Z
9553066 9553066 20260322010853_PBRag BE000A 2026-03-23T12:01:11.431Z 2026-03-30T12:27:34.310Z
9551877 9551877 20260320220231_rDIMF BE000A 2026-03-22T12:27:15.160Z 2026-03-28T12:37:03.543Z
9542904 9542904 20260321014903_3Rap2 BE000A 2026-03-22T12:01:58.627Z 2026-03-29T12:18:59.870Z
9534461 9534461 20260320035120_ZIbZU BE000A 2026-03-21T12:08:03.879Z 2026-03-28T12:34:18.545Z
9533231 9533231 20260320021724_N3SaY BE000A 2026-03-21T12:04:52.712Z 2026-03-28T12:33:50.786Z
9533063 9533063 20260320015653_NXQwW BE000A 2026-03-21T12:04:20.944Z 2026-03-28T12:33:48.280Z
9532886 9532886 20260320013559_2VctK BE000A 2026-03-21T12:03:54.227Z 2026-03-28T12:33:45.900Z
9531247 9531247 20260318224910_XrSM8 BE000A 2026-03-20T12:25:03.048Z 2026-03-26T12:39:18.312Z
9521691 9521691 20260319043430_3aEL7 BE000A 2026-03-20T12:08:23.991Z 2026-03-27T12:41:03.757Z
9519933 9519933 20260319024404_dJrbq BE000A 2026-03-20T12:05:24.214Z 2026-03-27T12:40:37.175Z
9519543 9519543 20260319021617_vpqvz BE000A 2026-03-20T12:04:37.300Z 2026-03-27T12:40:32.280Z
9518274 9518274 20260319004735_0efLD BE000A 2026-03-20T12:02:15.115Z 2026-03-27T12:40:08.157Z
9517225 9517225 20260317225759_DPyzu BE000A 2026-03-19T12:27:21.162Z 2026-03-25T12:43:09.507Z
9516918 9516918 20260317221534_98YwW BE000A 2026-03-19T12:26:54.825Z 2026-03-25T12:43:07.563Z
9516900 9516900 20260317221223_vEvKW BE000A 2026-03-19T12:26:53.751Z 2026-03-25T12:43:07.474Z
9516888 9516888 20260317221222_DN0JX BE000A 2026-03-19T12:26:53.527Z 2026-03-25T12:43:07.466Z
9516694 9516694 20260317213754_fuhTp BE000A 2026-03-19T12:26:39.773Z 2026-03-25T12:43:06.195Z
9516131 9516131 20260317200603_2uCaZ BE000A 2026-03-19T12:25:42.950Z 2026-03-25T12:42:49.310Z
9515957 9515957 20260317193730_LeeC0 BE000A 2026-03-19T12:25:23.903Z 2026-03-25T12:42:44.598Z
9511992 9511992 20260318043318_FAd7k BE000A 2026-03-19T12:11:27.628Z 2026-03-26T12:37:41.399Z
9511664 9511664 20260318040822_5TBwO BE000A 2026-03-19T12:10:42.012Z 2026-03-26T12:37:38.578Z
9511488 9511488 20260318035620_4wD0B BE000A 2026-03-19T12:10:19.738Z 2026-03-26T12:37:37.342Z
9510796 9510796 20260318031611_mK2Mx BE000A 2026-03-19T12:08:42.206Z 2026-03-26T12:37:16.747Z
9510792 9510792 20260318031610_A63qS BE000A 2026-03-19T12:08:41.963Z 2026-03-26T12:37:16.733Z
9510570 9510570 20260318030009_QTKCd BE000A 2026-03-19T12:08:00.205Z 2026-03-26T12:37:14.471Z
9510559 9510559 20260318030009_FyQjZ BE000A 2026-03-19T12:07:59.906Z 2026-03-26T12:37:14.467Z
9510387 9510387 20260318024840_NAjC1 BE000A 2026-03-19T12:07:31.251Z 2026-03-26T12:37:12.102Z
9510332 9510332 20260318024552_VMMb1 BE000A 2026-03-19T12:07:24.968Z 2026-03-26T12:37:11.702Z
9510153 9510153 20260318023547_mSRs9 BE000A 2026-03-19T12:07:01.433Z 2026-03-26T12:37:10.553Z
9510145 9510145 20260318023547_9iGZu BE000A 2026-03-19T12:07:01.000Z 2026-03-26T12:37:10.514Z
9509575 9509575 20260318015830_X2r9c BE000A 2026-03-19T12:05:41.751Z 2026-03-26T12:37:06.491Z
9509563 9509563 20260318015830_jISfc BE000A 2026-03-19T12:05:40.315Z 2026-03-26T12:37:06.422Z
9509253 9509253 20260318013751_iNRaT BE000A 2026-03-19T12:04:53.951Z 2026-03-26T12:37:04.231Z
9509245 9509245 20260318013751_RDKe8 BE000A 2026-03-19T12:04:53.645Z 2026-03-26T12:37:04.205Z
9508779 9508779 20260318011041_Kc4Tz BE000A 2026-03-19T12:03:47.120Z 2026-03-26T12:37:00.847Z
9508768 9508768 20260318011041_h3eZj BE000A 2026-03-19T12:03:46.942Z 2026-03-26T12:37:00.813Z
9508566 9508566 20260318010319_9IkBy BE000A 2026-03-19T12:03:21.305Z 2026-03-26T12:36:59.351Z
9508304 9508304 20260318004339_Ik2CA BE000A 2026-03-19T12:02:51.158Z 2026-03-26T12:36:57.688Z
9508147 9508147 20260318002537_MzJsQ BE000A 2026-03-19T12:02:24.647Z 2026-03-26T12:36:56.291Z
9508043 9508043 20260318000934_Lghfh BE000A 2026-03-19T12:02:01.258Z 2026-03-26T12:36:55.283Z
9507568 9507568 20260317232325_NOpg7 BE000A 2026-03-19T12:00:38.930Z 2026-03-26T12:36:42.517Z
9493139 9493139 20260314225049_5mRrk BE000A 2026-03-16T12:29:29.075Z 2026-03-22T12:42:56.928Z
9492632 9492632 20260314212858_jlw3H BE000A 2026-03-16T12:28:52.757Z 2026-03-22T12:42:53.551Z
9492387 9492387 20260314204132_PMHbQ BE000A 2026-03-16T12:28:31.229Z 2026-03-22T12:42:52.099Z
9486037 9486037 20260315043658_nPJJR BE000A 2026-03-16T12:08:27.238Z 2026-03-23T12:21:55.079Z
9485800 9485800 20260315035638_yMtM7 BE000A 2026-03-16T12:07:42.321Z 2026-03-23T12:21:54.072Z
9485790 9485790 20260315035620_2PHf8 BE000A 2026-03-16T12:07:40.650Z 2026-03-23T12:21:54.039Z
9485735 9485735 20260315034900_w3uRE BE000A 2026-03-16T12:07:28.025Z 2026-03-23T12:21:53.708Z
9484762 9484762 20260315013638_x6h3h BE000A 2026-03-16T12:04:03.438Z 2026-03-23T12:21:48.265Z
9484533 9484533 20260315005551_SLBtd BE000A 2026-03-16T12:03:14.681Z 2026-03-23T12:21:47.223Z
9484479 9484479 20260315004530_z7SeJ BE000A 2026-03-16T12:03:01.791Z 2026-03-23T12:21:46.970Z
9484084 9484084 20260314234828_Kjojt BE000A 2026-03-16T12:01:29.993Z 2026-03-23T12:21:45.254Z
9474134 9474134 20260312205807_5FlyD BE000A 2026-03-14T12:22:09.404Z 2026-03-20T12:37:16.263Z
9467537 9467537 20260311220629_MUnP7 BE000A 2026-03-13T12:19:24.227Z 2026-03-19T12:45:53.059Z
9462418 9462418 20260311231431_dXpOs BE000A 2026-03-13T12:00:56.325Z 2026-03-20T12:36:15.879Z
9462317 9462317 20260311225334_9DpJS BE000A 2026-03-13T12:00:30.065Z 2026-03-20T12:36:15.081Z
9456853 9456853 20260311012041_sFPf6 BE000A 2026-03-12T12:02:00.332Z 2026-03-19T12:44:22.862Z
9455636 9455636 20260309193057_69L5E BE000A 2026-03-11T12:14:42.441Z 2026-03-17T12:42:37.026Z
9430903 9430903 20260304215211_Gu5vH BE000A 2026-03-06T14:24:48.239Z 2026-03-12T12:33:43.836Z
9430595 9430595 20260304200345_cIPbg BE000A 2026-03-06T14:23:39.894Z 2026-03-12T12:33:38.766Z
9426794 9426794 20260305044550_kbmni BE000A 2026-03-06T14:06:23.640Z 2026-03-13T12:34:51.156Z
9426571 9426571 20260305035329_PCbQE BE000A 2026-03-06T14:05:27.438Z 2026-03-13T12:34:48.077Z
9426014 9426014 20260305014106_RItOk BE000A 2026-03-06T14:02:50.487Z 2026-03-13T12:34:41.260Z
9425983 9425983 20260305013017_3KXla BE000A 2026-03-06T14:02:39.987Z 2026-03-13T12:34:40.854Z
9420631 9420631 20260302222357_xxIfN BE000A 2026-03-04T14:05:13.258Z 2026-03-10T12:36:56.925Z
9420581 9420581 20260302214519_ZTuvj BE000A 2026-03-04T14:05:09.192Z 2026-03-10T12:36:56.165Z
9415486 9415486 20260301231855_qD0X5 BE000A 2026-03-03T14:00:22.535Z 2026-03-10T12:35:42.537Z
9415398 9415398 20260228224031_YhEr7 BE000A 2026-03-02T14:07:50.784Z 2026-03-08T12:43:12.786Z
9415246 9415246 20260228210245_5sJLh BE000A 2026-03-02T14:07:37.791Z 2026-03-08T12:43:07.484Z
9415178 9415178 20260228203905_iSTKc BE000A 2026-03-02T14:07:31.184Z 2026-03-08T12:43:04.667Z
9412764 9412764 20260301052535_zWV0w BE000A 2026-03-02T14:02:01.959Z 2026-03-09T12:39:49.735Z
9412743 9412743 20260301051851_EPEq1 BE000A 2026-03-02T14:02:00.430Z 2026-03-09T12:39:49.216Z
9412656 9412656 20260301044448_ylDBz BE000A 2026-03-02T14:01:51.179Z 2026-03-09T12:39:46.572Z
9412625 9412625 20260301043833_UeCSg BE000A 2026-03-02T14:01:47.464Z 2026-03-09T12:39:45.505Z
9412075 9412075 20260301000002_i3SmJ BE000A 2026-03-02T14:00:26.384Z 2026-03-09T12:39:18.472Z
9411992 9411992 20260228231513_v6yDv BE000A 2026-03-02T14:00:12.793Z 2026-03-09T12:39:15.687Z
9402802 9402802 20260227043940_zegEU BE000A 2026-02-28T14:06:08.287Z 2026-03-07T14:47:09.447Z
9402244 9402244 20260227032029_2ibXR BE000A 2026-02-28T14:04:09.462Z 2026-03-07T14:46:36.077Z
9400805 9400805 20260225204235_mLLCm BE000A 2026-02-27T14:15:43.208Z 2026-03-05T14:38:49.526Z
9400469 9400469 20260225041316_0D2zy BE000A 2026-02-27T14:12:24.313Z 2026-03-05T14:36:55.634Z
9399144 9399144 20260226050537_22rNy BE000A 2026-02-27T14:07:04.794Z 2026-03-06T14:44:11.026Z
9399080 9399080 20260226045018_glwpf BE000A 2026-02-27T14:06:54.176Z 2026-03-06T14:44:09.592Z
9398471 9398471 20260226034155_eP5jq BE000A 2026-02-27T14:05:23.896Z 2026-03-06T14:43:44.999Z
9392485 9392485 20260225043125_j4Y60 BE000A 2026-02-26T14:07:28.152Z 2026-03-05T14:36:58.983Z
9392179 9392179 20260225035009_i309d BE000A 2026-02-26T14:06:41.854Z 2026-03-05T14:36:50.961Z
9392017 9392017 20260225033604_feTHN BE000A 2026-02-26T14:06:12.518Z 2026-03-05T14:36:41.357Z
9391259 9391259 20260225022033_6BbSL BE000A 2026-02-26T14:03:53.296Z 2026-03-05T14:36:15.934Z
9390918 9390918 20260225013934_IuIri BE000A 2026-02-26T14:02:55.437Z 2026-03-05T14:35:59.729Z

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