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,282 rows where station_code = "BE0010" 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
9606949 9606949 20260403004519_POV2J BE0010 2026-04-04T12:12:26.861Z 2026-04-06T12:23:58.418Z
9606873 9606873 20260402224543_lc3TH BE0010 2026-04-04T12:12:07.510Z 2026-04-06T12:23:53.336Z
9606758 9606758 20260402203805_mE32p BE0010 2026-04-04T12:11:29.566Z 2026-04-06T12:23:39.422Z
9600508 9600508 20260330225035_g62ng BE0010 2026-04-01T12:10:59.590Z 2026-04-06T12:33:31.088Z
9600479 9600479 20260330223855_n9Rxg BE0010 2026-04-01T12:10:53.229Z 2026-04-06T12:33:27.800Z
9600457 9600457 20260330222527_tT455 BE0010 2026-04-01T12:10:50.227Z 2026-04-06T12:33:26.717Z
9595324 9595324 20260330033211_3o2C2 BE0010 2026-03-31T12:01:08.681Z 2026-04-06T12:29:58.037Z
9595168 9595168 20260330024555_WNa0B BE0010 2026-03-31T12:00:40.983Z 2026-04-06T12:29:44.157Z
9595109 9595109 20260330022335_QH0YE BE0010 2026-03-31T12:00:30.128Z 2026-04-06T12:29:40.895Z
9595068 9595068 20260330021320_3kXh3 BE0010 2026-03-31T12:00:23.074Z 2026-04-06T12:29:39.003Z
9594989 9594989 20260329011329_G13Tw BE0010 2026-03-30T12:10:43.813Z 2026-04-06T12:40:22.515Z
9594609 9594609 20260328233349_FEm94 BE0010 2026-03-30T12:09:58.933Z 2026-04-06T12:40:01.547Z
9594250 9594250 20260328203944_C06JJ BE0010 2026-03-30T12:09:05.289Z 2026-04-06T12:39:44.805Z
9594218 9594218 20260328201854_Ar9TY BE0010 2026-03-30T12:09:00.421Z 2026-04-06T12:39:43.590Z
9592900 9592900 20260329035115_xPpP9 BE0010 2026-03-30T12:02:16.090Z 2026-04-06T12:34:39.689Z
9592759 9592759 20260329031908_fSKk3 BE0010 2026-03-30T12:01:52.282Z 2026-04-06T12:34:27.140Z
9592533 9592533 20260329022358_Yn43g BE0010 2026-03-30T12:01:13.305Z 2026-04-06T12:34:14.279Z
9592330 9592330 20260329015328_QfR4J BE0010 2026-03-30T12:00:42.093Z 2026-04-06T12:34:00.966Z
9588683 9588683 20260327003259_IyBCU BE0010 2026-03-28T12:11:38.818Z 2026-04-04T12:42:26.627Z
9588517 9588517 20260326233457_QmycH BE0010 2026-03-28T12:11:18.443Z 2026-04-04T12:42:17.424Z
9588481 9588481 20260326231747_empAZ BE0010 2026-03-28T12:11:14.833Z 2026-04-04T12:42:10.280Z
9588387 9588387 20260326221924_afjZx BE0010 2026-03-28T12:11:00.873Z 2026-04-04T12:42:03.876Z
9588377 9588377 20260326221348_5P3IE BE0010 2026-03-28T12:10:59.214Z 2026-04-04T12:42:02.539Z
9588335 9588335 20260326214915_wNeN2 BE0010 2026-03-28T12:10:53.996Z 2026-04-04T12:41:59.267Z
9588269 9588269 20260326201724_1uUkj BE0010 2026-03-28T12:10:44.223Z 2026-04-04T12:41:53.469Z
9588232 9588232 20260326191509_IeKsC BE0010 2026-03-28T12:10:31.807Z 2026-04-04T12:41:47.828Z
9585387 9585387 20260327004412_IB9Up BE0010 2026-03-28T12:00:10.880Z 2026-04-05T12:32:18.912Z
9581491 9581491 20260326031826_8xMQt BE0010 2026-03-27T12:03:16.575Z 2026-04-04T12:39:08.403Z
9580157 9580157 20260323002037_F2U4O BE0010 2026-03-26T12:15:32.566Z 2026-03-31T12:25:49.868Z
9579630 9579630 20260324220103_vpYV0 BE0010 2026-03-26T12:14:06.387Z 2026-04-02T12:37:18.504Z
9577178 9577178 20260325040752_wYx01 BE0010 2026-03-26T12:04:19.387Z 2026-04-03T12:36:37.350Z
9577126 9577126 20260325040014_BcmuM BE0010 2026-03-26T12:04:13.297Z 2026-04-03T12:36:35.672Z
9576921 9576921 20260325032538_Jr93c BE0010 2026-03-26T12:03:40.857Z 2026-04-03T12:36:25.780Z
9576307 9576307 20260325015101_FJoM6 BE0010 2026-03-26T12:01:53.706Z 2026-04-03T12:35:52.707Z
9575767 9575767 20260320212600_t422i BE0010 2026-03-25T12:36:06.825Z 2026-03-28T12:37:01.708Z
9575759 9575759 20260320190618_cevIE BE0010 2026-03-25T12:35:47.108Z 2026-03-28T12:36:41.742Z
9575751 9575751 20260321215314_5xbfo BE0010 2026-03-25T12:31:43.931Z 2026-03-29T12:21:01.865Z
9575703 9575703 20260321022746_hDyHs BE0010 2026-03-25T12:27:54.923Z 2026-03-29T12:19:02.337Z
9575688 9575688 20260322221428_9WAPx BE0010 2026-03-25T12:27:03.056Z 2026-03-30T12:30:46.473Z
9575685 9575685 20260322214059_np1eK BE0010 2026-03-25T12:26:58.869Z 2026-03-30T12:30:44.302Z
9575683 9575683 20260322212141_dnTaz BE0010 2026-03-25T12:26:56.590Z 2026-03-30T12:30:42.979Z
9575667 9575667 20260322033310_XBNv3 BE0010 2026-03-25T12:23:14.397Z 2026-03-30T12:28:08.300Z
9575661 9575661 20260322022710_t1YhO BE0010 2026-03-25T12:22:47.675Z 2026-03-30T12:27:55.814Z
9575656 9575656 20260322014534_8phJt BE0010 2026-03-25T12:22:30.982Z 2026-03-30T12:27:42.179Z
9575646 9575646 20260322010454_fYFoN BE0010 2026-03-25T12:22:08.839Z 2026-03-30T12:27:33.936Z
9517198 9517198 20260317225314_2jrsu BE0010 2026-03-19T12:27:18.865Z 2026-03-25T12:43:09.309Z
9517052 9517052 20260317223127_i1L1M BE0010 2026-03-19T12:27:08.041Z 2026-03-25T12:43:08.316Z
9516487 9516487 20260317205847_kwh1s BE0010 2026-03-19T12:26:16.689Z 2026-03-25T12:42:59.880Z
9516481 9516481 20260317205833_iQQ3C BE0010 2026-03-19T12:26:16.317Z 2026-03-25T12:42:59.813Z
9516211 9516211 20260317201247_z3H9d BE0010 2026-03-19T12:25:46.903Z 2026-03-25T12:42:51.475Z
9516035 9516035 20260317194649_DwdBF BE0010 2026-03-19T12:25:33.250Z 2026-03-25T12:42:46.438Z
9515870 9515870 20260317190722_UyZHO BE0010 2026-03-19T12:25:09.853Z 2026-03-25T12:42:40.542Z
9512041 9512041 20260318043652_0Ywti BE0010 2026-03-19T12:11:32.476Z 2026-03-26T12:37:41.787Z
9511975 9511975 20260318043147_y3xTd BE0010 2026-03-19T12:11:24.815Z 2026-03-26T12:37:41.237Z
9511877 9511877 20260318042637_DS9cV BE0010 2026-03-19T12:11:14.463Z 2026-03-26T12:37:40.495Z
9511521 9511521 20260318035835_hi4RW BE0010 2026-03-19T12:10:23.551Z 2026-03-26T12:37:37.642Z
9511192 9511192 20260318033958_5PYwU BE0010 2026-03-19T12:09:38.236Z 2026-03-26T12:37:26.662Z
9511186 9511186 20260318033919_OWkoZ BE0010 2026-03-19T12:09:36.710Z 2026-03-26T12:37:25.729Z
9510941 9510941 20260318032435_UYUnA BE0010 2026-03-19T12:09:03.145Z 2026-03-26T12:37:18.124Z
9510661 9510661 20260318030654_lbqOp BE0010 2026-03-19T12:08:14.074Z 2026-03-26T12:37:15.311Z
9510618 9510618 20260318030410_OWVFE BE0010 2026-03-19T12:08:07.783Z 2026-03-26T12:37:14.970Z
9510289 9510289 20260318024229_jSG1a BE0010 2026-03-19T12:07:17.393Z 2026-03-26T12:37:11.341Z
9509657 9509657 20260318020522_r6Dke BE0010 2026-03-19T12:05:52.597Z 2026-03-26T12:37:06.830Z
9509171 9509171 20260318012927_HcFrY BE0010 2026-03-19T12:04:41.143Z 2026-03-26T12:37:03.634Z
9508455 9508455 20260318005545_59Aef BE0010 2026-03-19T12:03:07.601Z 2026-03-26T12:36:58.555Z
9507700 9507700 20260317233546_q2Akl BE0010 2026-03-19T12:01:01.955Z 2026-03-26T12:36:52.666Z
9493116 9493116 20260314224616_QAS4P BE0010 2026-03-16T12:29:27.721Z 2026-03-22T12:42:56.850Z
9493096 9493096 20260314224050_lGaS6 BE0010 2026-03-16T12:29:26.409Z 2026-03-22T12:42:56.766Z
9492890 9492890 20260314221134_dixCC BE0010 2026-03-16T12:29:08.772Z 2026-03-22T12:42:55.613Z
9492652 9492652 20260314213200_gUPfZ BE0010 2026-03-16T12:28:54.451Z 2026-03-22T12:42:53.755Z
9492238 9492238 20260314194843_F39wn BE0010 2026-03-16T12:28:10.988Z 2026-03-22T12:42:51.078Z
9492194 9492194 20260314193134_5YMSp BE0010 2026-03-16T12:28:06.756Z 2026-03-22T12:42:50.642Z
9492063 9492063 20260314190505_LAL9f BE0010 2026-03-16T12:27:59.167Z 2026-03-22T12:42:49.923Z
9485989 9485989 20260315042558_4LaMb BE0010 2026-03-16T12:08:15.400Z 2026-03-23T12:21:54.787Z
9485944 9485944 20260315041547_UwXSW BE0010 2026-03-16T12:08:07.934Z 2026-03-23T12:21:54.629Z
9485836 9485836 20260315040011_zgTCP BE0010 2026-03-16T12:07:48.582Z 2026-03-23T12:21:54.277Z
9485765 9485765 20260315035112_SnASN BE0010 2026-03-16T12:07:33.107Z 2026-03-23T12:21:53.815Z
9485760 9485760 20260315035108_GPm9r BE0010 2026-03-16T12:07:32.452Z 2026-03-23T12:21:53.798Z
9485662 9485662 20260315033753_oGuhu BE0010 2026-03-16T12:07:10.602Z 2026-03-23T12:21:53.360Z
9485236 9485236 20260315024148_LjQtg BE0010 2026-03-16T12:05:43.785Z 2026-03-23T12:21:50.560Z
9484993 9484993 20260315021109_NXu4F BE0010 2026-03-16T12:04:52.521Z 2026-03-23T12:21:49.463Z
9484807 9484807 20260315014303_MMvn3 BE0010 2026-03-16T12:04:12.054Z 2026-03-23T12:21:48.463Z
9484794 9484794 20260315014218_lvjny BE0010 2026-03-16T12:04:09.664Z 2026-03-23T12:21:48.415Z
9484473 9484473 20260315004525_iZ2k3 BE0010 2026-03-16T12:03:00.878Z 2026-03-16T12:29:32.259Z
9484429 9484429 20260315003836_R92kO BE0010 2026-03-16T12:02:51.317Z 2026-03-23T12:21:46.708Z
9484422 9484422 20260315003823_JBS58 BE0010 2026-03-16T12:02:49.840Z 2026-03-23T12:21:46.674Z
9484376 9484376 20260315003011_Ps2jV BE0010 2026-03-16T12:02:38.007Z 2026-03-23T12:21:46.517Z
9484330 9484330 20260315002111_3HgnE BE0010 2026-03-16T12:02:26.843Z 2026-03-23T12:21:46.359Z
9484263 9484263 20260315001215_3uBTx BE0010 2026-03-16T12:02:13.450Z 2026-03-23T12:21:46.066Z
9484082 9484082 20260314234812_01rry BE0010 2026-03-16T12:01:29.258Z 2026-03-23T12:21:45.231Z
9484027 9484027 20260314233835_agPPK BE0010 2026-03-16T12:01:17.016Z 2026-03-23T12:21:44.905Z
9468697 9468697 20260313002037_R7YHI BE0010 2026-03-14T12:01:26.217Z 2026-03-21T12:48:27.970Z
9467276 9467276 20260311210953_33jCE BE0010 2026-03-13T12:18:55.296Z 2026-03-19T12:45:51.225Z
9467031 9467031 20260311194037_Y2b7I BE0010 2026-03-13T12:18:07.628Z 2026-03-19T12:45:47.175Z
9464262 9464262 20260312040601_wswFX BE0010 2026-03-13T12:06:44.306Z 2026-03-20T12:36:34.892Z
9464258 9464258 20260312040544_2336Z BE0010 2026-03-13T12:06:43.694Z 2026-03-20T12:36:34.868Z
9464193 9464193 20260312035327_XrYgI BE0010 2026-03-13T12:06:34.223Z 2026-03-20T12:36:32.664Z
9463534 9463534 20260312020511_ZmRMI BE0010 2026-03-13T12:04:27.771Z 2026-03-20T12:36:23.170Z
9463206 9463206 20260312011420_Mhkrt BE0010 2026-03-13T12:03:28.114Z 2026-03-20T12:36:20.637Z
9463048 9463048 20260312005805_4L5pz BE0010 2026-03-13T12:02:58.644Z 2026-03-20T12:36:19.502Z

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