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

6,910 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
8691420 8691420 20251205052456_0TfUU BE0007 2025-12-06T14:17:42.938Z 2025-12-06T14:18:01.110Z
8691417 8691417 20251205052056_RCgDz BE0007 2025-12-06T14:17:42.209Z 2025-12-06T14:18:01.108Z
8666122 8666122 20251201043939_C8RsS BE0007 2025-12-02T14:25:17.081Z 2025-12-06T14:42:12.246Z
8665931 8665931 20251201041145_J12w3 BE0007 2025-12-02T14:24:56.223Z 2025-12-06T14:42:07.219Z
8665625 8665625 20251201034421_mXlfq BE0007 2025-12-02T14:24:13.827Z 2025-12-06T14:41:43.490Z
8665578 8665578 20251201033748_1PZDZ BE0007 2025-12-02T14:23:56.233Z 2025-12-06T14:41:40.964Z
8665503 8665503 20251201032932_W2yoW BE0007 2025-12-02T14:23:47.938Z 2025-12-06T14:41:39.116Z
8665417 8665417 20251201031909_z81OE BE0007 2025-12-02T14:23:39.883Z 2025-12-06T14:41:37.270Z
8665404 8665404 20251201031634_PlSs1 BE0007 2025-12-02T14:23:38.496Z 2025-12-06T14:41:36.954Z
8665369 8665369 20251201031247_QfgkW BE0007 2025-12-02T14:23:35.567Z 2025-12-06T14:41:36.174Z
8665002 8665002 20251201021548_UjnEt BE0007 2025-12-02T14:22:35.434Z 2025-12-06T14:41:05.188Z
8664944 8664944 20251201020718_ENvOg BE0007 2025-12-02T14:22:29.979Z 2025-12-06T14:41:03.643Z
8664658 8664658 20251201011903_DAwPc BE0007 2025-12-02T14:21:44.398Z 2025-12-06T14:40:54.095Z
8664518 8664518 20251201004614_dtk9j BE0007 2025-12-02T14:21:15.011Z 2025-12-06T14:40:49.319Z
8664480 8664480 20251201004011_R5sYk BE0007 2025-12-02T14:21:11.034Z 2025-12-06T14:40:48.129Z
8664447 8664447 20251201003112_Qd35r BE0007 2025-12-02T14:21:05.948Z 2025-12-06T14:40:47.237Z
8664413 8664413 20251201002240_Pm2IL BE0007 2025-12-02T14:21:01.898Z 2025-12-06T14:40:46.257Z
8664249 8664249 20251130235131_G0yMU BE0007 2025-12-02T14:20:34.697Z 2025-12-06T14:40:42.572Z
8664243 8664243 20251130235040_FaNdk BE0007 2025-12-02T14:20:34.099Z 2025-12-06T14:40:42.306Z
8664211 8664211 20251130234421_8KOfs BE0007 2025-12-02T14:20:30.104Z 2025-12-06T14:40:41.575Z
8664192 8664192 20251130233824_jRXQN BE0007 2025-12-02T14:20:18.385Z 2025-12-06T14:40:41.257Z
8664029 8664029 20251130230503_V07Rq BE0007 2025-12-02T14:19:58.045Z 2025-12-06T14:40:20.174Z
8663951 8663951 20251130224920_0PAs1 BE0007 2025-12-02T14:19:40.680Z 2025-12-06T14:40:17.248Z
8663910 8663910 20251130223158_6teAv BE0007 2025-12-02T14:19:34.612Z 2025-12-06T14:40:16.128Z
8645739 8645739 20251128234347_KkA89 BE0007 2025-11-30T14:24:28.373Z 2025-12-06T14:55:04.750Z
8645589 8645589 20251128230211_WlGIN BE0007 2025-11-30T14:24:14.599Z 2025-12-06T14:55:00.676Z
8645575 8645575 20251128225918_cgK3P BE0007 2025-11-30T14:24:13.503Z 2025-12-06T14:55:00.426Z
8645542 8645542 20251128224341_kKPRd BE0007 2025-11-30T14:23:57.117Z 2025-12-06T14:54:59.919Z
8623254 8623254 20251126233635_LMWjn BE0007 2025-11-28T14:21:24.106Z 2025-12-05T15:03:40.949Z
8622678 8622678 20251126204143_8X7Zn BE0007 2025-11-28T14:19:40.878Z 2025-12-05T15:03:04.894Z
8622069 8622069 20251126174344_NgqNG BE0007 2025-11-28T14:17:36.547Z 2025-12-05T15:02:51.497Z
8591769 8591769 20251124045354_78b30 BE0007 2025-11-25T14:25:06.578Z 2025-12-02T15:13:00.419Z
8591670 8591670 20251124044354_byNSg BE0007 2025-11-25T14:24:43.649Z 2025-12-02T15:12:59.883Z
8590766 8590766 20251124030851_E52wd BE0007 2025-11-25T14:22:40.701Z 2025-12-02T15:12:55.346Z
8590682 8590682 20251124030321_bpPzk BE0007 2025-11-25T14:22:22.676Z 2025-12-02T15:12:54.201Z
8581534 8581534 20251123004629_ooa3u BE0007 2025-11-24T14:31:44.183Z 2025-12-01T15:20:53.745Z
8581509 8581509 20251123002548_o4wTY BE0007 2025-11-24T14:31:42.227Z 2025-12-01T15:20:48.164Z
8581464 8581464 20251123000326_gP27T BE0007 2025-11-24T14:31:37.019Z 2025-12-01T15:20:35.047Z
8581461 8581461 20251123000041_QG3YQ BE0007 2025-11-24T14:31:36.288Z 2025-12-01T15:20:34.539Z
8581454 8581454 20251122235902_2UhTY BE0007 2025-11-24T14:31:35.903Z 2025-12-01T15:20:32.179Z
8581425 8581425 20251122235045_lmUIy BE0007 2025-11-24T14:31:33.969Z 2025-12-01T15:20:28.523Z
8581378 8581378 20251122232929_1F8C1 BE0007 2025-11-24T14:31:30.344Z 2025-12-01T15:20:17.691Z
8581295 8581295 20251122225816_OrVt3 BE0007 2025-11-24T14:31:24.327Z 2025-12-01T15:20:11.708Z
8581270 8581270 20251122224333_oeAJL BE0007 2025-11-24T14:31:23.121Z 2025-12-01T15:20:07.578Z
8581252 8581252 20251122223003_fVs1p BE0007 2025-11-24T14:31:22.128Z 2025-12-01T15:20:05.016Z
8579089 8579089 20251122222155_2ZrYP BE0007 2025-11-24T14:13:29.741Z 2025-12-01T15:20:02.703Z
8578933 8578933 20251122215250_gkG1r BE0007 2025-11-24T14:13:08.019Z 2025-12-01T15:19:56.092Z
8578817 8578817 20251122212917_dFDtB BE0007 2025-11-24T14:12:46.150Z 2025-12-01T15:19:53.318Z
8578584 8578584 20251122205851_hc32B BE0007 2025-11-24T14:12:09.440Z 2025-12-01T15:19:48.695Z
8578550 8578550 20251122205206_pIeAJ BE0007 2025-11-24T14:12:04.894Z 2025-12-01T15:19:48.039Z
8578166 8578166 20251122195215_Nvuu2 BE0007 2025-11-24T14:11:00.226Z 2025-12-01T15:19:18.263Z
8577750 8577750 20251122185252_356TL BE0007 2025-11-24T14:09:34.935Z 2025-12-01T15:18:57.203Z
8577672 8577672 20251122184537_1cQyk BE0007 2025-11-24T14:09:21.202Z 2025-12-01T15:18:56.119Z
8577587 8577587 20251122183420_7wjDf BE0007 2025-11-24T14:09:06.769Z 2025-12-01T15:18:54.674Z
8577516 8577516 20251122181855_MWXjW BE0007 2025-11-24T14:08:56.069Z 2025-12-01T15:18:52.371Z
8577357 8577357 20251122175859_B3iMz BE0007 2025-11-24T14:08:28.083Z 2025-12-01T15:18:48.154Z
8577285 8577285 20251122175149_4vKr4 BE0007 2025-11-24T14:08:11.788Z 2025-12-01T15:18:46.540Z
8577247 8577247 20251122174215_AywiS BE0007 2025-11-24T14:08:05.308Z 2025-12-01T15:18:45.464Z
8577224 8577224 20251122173640_YJIbQ BE0007 2025-11-24T14:08:01.123Z 2025-12-01T15:18:45.067Z
8577195 8577195 20251122172943_q4p2Q BE0007 2025-11-24T14:07:55.541Z 2025-12-01T15:18:44.662Z
8577140 8577140 20251122172421_CfaWK BE0007 2025-11-24T14:07:48.260Z 2025-12-01T15:18:44.080Z
8540977 8540977 20251120014705_D4g1e BE0007 2025-11-21T14:37:04.289Z 2025-11-21T14:37:04.289Z
8515738 8515738 20251118045935_0vXff BE0007 2025-11-19T14:39:55.990Z 2025-11-26T15:08:03.851Z
8515644 8515644 20251118045004_XheTH BE0007 2025-11-19T14:39:52.400Z 2025-11-26T15:08:02.206Z
8515178 8515178 20251118035338_AwXma BE0007 2025-11-19T14:38:59.941Z 2025-11-26T15:07:59.487Z
8514482 8514482 20251118022543_65PMu BE0007 2025-11-19T14:38:16.905Z 2025-11-26T15:07:54.755Z
8514444 8514444 20251118022025_3shu2 BE0007 2025-11-19T14:38:12.324Z 2025-11-26T15:07:54.520Z
8514360 8514360 20251118021201_drgI8 BE0007 2025-11-19T14:37:58.395Z 2025-11-26T15:07:54.141Z
8514277 8514277 20251118020330_NZYvd BE0007 2025-11-19T14:37:46.201Z 2025-11-26T15:07:53.750Z
8514234 8514234 20251118015510_7wPM5 BE0007 2025-11-19T14:37:30.654Z 2025-11-26T15:07:53.366Z
8514169 8514169 20251118015249_mKgek BE0007 2025-11-19T14:37:22.168Z 2025-11-26T15:07:53.170Z
8514045 8514045 20251118013352_zFafL BE0007 2025-11-19T14:36:53.137Z 2025-11-26T15:07:52.174Z
8514033 8514033 20251118013023_GwaZP BE0007 2025-11-19T14:36:51.191Z 2025-11-26T15:07:52.020Z
8513259 8513259 20251118001016_32pFK BE0007 2025-11-19T14:36:12.096Z 2025-11-26T15:07:48.343Z
8513227 8513227 20251118000620_2dkQV BE0007 2025-11-19T14:36:07.284Z 2025-11-26T15:07:48.221Z
8512620 8512620 20251117224251_jV1XL BE0007 2025-11-19T14:34:47.634Z 2025-11-26T15:07:44.871Z
8512495 8512495 20251117222716_biLom BE0007 2025-11-19T14:34:42.033Z 2025-11-26T15:07:44.138Z
8512301 8512301 20251117215712_CYs1T BE0007 2025-11-19T14:34:36.283Z 2025-11-26T15:07:42.828Z
8511752 8511752 20251117200830_w2VZq BE0007 2025-11-19T14:33:55.391Z 2025-11-26T15:07:38.188Z
8511534 8511534 20251117193515_0txvm BE0007 2025-11-19T14:33:24.339Z 2025-11-26T15:07:35.538Z
8511385 8511385 20251117190214_t9NsR BE0007 2025-11-19T14:33:14.557Z 2025-11-26T15:07:25.806Z
8511300 8511300 20251117184004_N0NKF BE0007 2025-11-19T14:32:54.316Z 2025-11-26T15:07:15.412Z
8511155 8511155 20251117181852_bRRVt BE0007 2025-11-19T14:32:35.352Z 2025-11-26T15:07:05.859Z
8510962 8510962 20251117172546_6vkqa BE0007 2025-11-19T14:32:10.385Z 2025-11-26T15:06:28.269Z
8495121 8495121 20251117033123_iNzxT BE0007 2025-11-18T14:25:34.038Z 2025-11-25T15:09:47.221Z
8494915 8494915 20251117031935_ofKUT BE0007 2025-11-18T14:25:17.796Z 2025-11-25T15:09:42.408Z
8494913 8494913 20251117031933_9zOCJ BE0007 2025-11-18T14:25:17.508Z 2025-11-25T15:09:42.407Z
8491492 8491492 20251116224012_bvHvI BE0007 2025-11-18T14:17:34.969Z 2025-11-25T15:08:39.560Z
8491389 8491389 20251116222553_oHRiN BE0007 2025-11-18T14:17:16.501Z 2025-11-25T15:08:37.283Z
8449387 8449387 20251113020119_Dh8O2 BE0007 2025-11-14T14:20:20.070Z 2025-11-21T15:11:59.228Z
8449357 8449357 20251113015618_HZnuR BE0007 2025-11-14T14:20:16.032Z 2025-11-21T15:11:58.851Z
8449215 8449215 20251113013236_TAd7t BE0007 2025-11-14T14:19:44.993Z 2025-11-21T15:11:56.314Z
8449168 8449168 20251113012553_LSMpP BE0007 2025-11-14T14:19:37.757Z 2025-11-21T15:11:54.264Z
8449036 8449036 20251113010741_UewAK BE0007 2025-11-14T14:19:16.670Z 2025-11-21T15:11:46.189Z
8448960 8448960 20251113005533_DHORW BE0007 2025-11-14T14:18:59.258Z 2025-11-21T15:11:43.138Z
8442568 8442568 20251111040751_J1MIE BE0007 2025-11-13T14:47:36.794Z 2025-11-19T15:17:43.850Z
8439440 8439440 20251112034845_m5k9d BE0007 2025-11-13T14:26:34.238Z 2025-11-20T15:25:24.684Z
8438645 8438645 20251112022242_LX2rq BE0007 2025-11-13T14:24:25.676Z 2025-11-20T15:24:44.782Z
8438492 8438492 20251112020541_RcGMw BE0007 2025-11-13T14:23:53.621Z 2025-11-20T15:24:36.909Z
8438414 8438414 20251112015344_2ou4j BE0007 2025-11-13T14:23:44.655Z 2025-11-20T15:24:33.165Z

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