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

713 rows where station_code = "BE001B" 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
9611397 9611397 20260405014804_VmDWK BE001B 2026-04-06T12:14:29.089Z 2026-04-06T12:16:14.794Z
9611369 9611369 20260405013835_q1h3j BE001B 2026-04-06T12:14:08.522Z 2026-04-06T12:16:14.787Z
9611191 9611191 20260405004416_pZiY7 BE001B 2026-04-06T12:13:25.963Z 2026-04-06T12:16:14.751Z
9611145 9611145 20260405003109_JWMwv BE001B 2026-04-06T12:13:11.277Z 2026-04-06T12:16:14.742Z
9610928 9610928 20260404225413_OEHen BE001B 2026-04-06T12:12:03.884Z 2026-04-06T12:16:14.692Z
9610925 9610925 20260404225320_JrE3d BE001B 2026-04-06T12:12:03.337Z 2026-04-06T12:16:14.692Z
9610863 9610863 20260404223401_DqrXp BE001B 2026-04-06T12:11:43.545Z 2026-04-06T12:16:14.678Z
9610853 9610853 20260404222955_JijGm BE001B 2026-04-06T12:11:41.436Z 2026-04-06T12:16:14.676Z
9610788 9610788 20260404214812_jtPCB BE001B 2026-04-06T12:11:23.368Z 2026-04-06T12:16:14.661Z
9610780 9610780 20260404214435_AuyjK BE001B 2026-04-06T12:11:20.676Z 2026-04-06T12:16:14.660Z
9610747 9610747 20260404213021_3h6ah BE001B 2026-04-06T12:11:02.954Z 2026-04-06T12:16:14.650Z
9610739 9610739 20260404212646_5rge1 BE001B 2026-04-06T12:11:00.880Z 2026-04-06T12:16:14.648Z
9609134 9609134 20260405034309_NHBpf BE001B 2026-04-06T12:00:24.403Z 2026-04-06T12:00:24.403Z
9606832 9606832 20260402220243_0LbsE BE001B 2026-04-04T12:11:52.689Z 2026-04-06T12:23:47.561Z
9606800 9606800 20260402212946_ChNQt BE001B 2026-04-04T12:11:45.910Z 2026-04-06T12:23:45.496Z
9604575 9604575 20260401210705_KCghz BE001B 2026-04-03T12:10:33.571Z 2026-04-06T12:26:02.745Z
9598734 9598734 20260331040801_ckP21 BE001B 2026-04-01T12:00:47.109Z 2026-04-06T12:26:54.326Z
9598678 9598678 20260331024529_MB5DS BE001B 2026-04-01T12:00:29.545Z 2026-04-06T12:26:46.212Z
9585953 9585953 20260327031558_Hja56 BE001B 2026-03-28T12:01:51.124Z 2026-04-05T12:32:54.436Z
9585951 9585951 20260327031554_nKtbV BE001B 2026-03-28T12:01:50.402Z 2026-04-05T12:32:54.342Z
9585890 9585890 20260327030205_6Bc5e BE001B 2026-03-28T12:01:39.926Z 2026-04-05T12:32:51.641Z
9585767 9585767 20260327022506_EKDPz BE001B 2026-03-28T12:01:15.140Z 2026-04-05T12:32:44.221Z
9585759 9585759 20260327022353_A8rKN BE001B 2026-03-28T12:01:13.676Z 2026-04-05T12:32:40.387Z
9585713 9585713 20260327021452_5NWob BE001B 2026-03-28T12:01:05.974Z 2026-04-05T12:32:36.021Z
9585695 9585695 20260327020731_4fyLg BE001B 2026-03-28T12:01:02.384Z 2026-04-05T12:32:35.130Z
9585672 9585672 20260327020452_03P9O BE001B 2026-03-28T12:00:58.635Z 2026-04-05T12:32:33.994Z
9585533 9585533 20260327013042_UpOJ3 BE001B 2026-03-28T12:00:34.915Z 2026-04-05T12:32:25.670Z
9585466 9585466 20260327010757_AYhNJ BE001B 2026-03-28T12:00:25.382Z 2026-04-05T12:32:22.588Z
9585375 9585375 20260324234219_7sdbG BE001B 2026-03-27T12:21:15.740Z 2026-04-02T12:37:37.676Z
9585374 9585374 20260324224758_L1Ot7 BE001B 2026-03-27T12:21:05.920Z 2026-04-02T12:37:29.351Z
9580213 9580213 20260322222724_YHyVr BE001B 2026-03-26T12:24:45.898Z 2026-03-30T12:30:47.426Z
9575658 9575658 20260322015507_IJ7mD BE001B 2026-03-25T12:22:33.784Z 2026-03-30T12:27:49.587Z
9575621 9575621 20260323234948_3G2gM BE001B 2026-03-25T12:21:31.809Z 2026-03-31T12:29:03.372Z
9575554 9575554 20260323231922_NYp61 BE001B 2026-03-25T12:21:23.751Z 2026-03-31T12:29:01.802Z
9575535 9575535 20260323230400_GJNZp BE001B 2026-03-25T12:21:21.771Z 2026-03-31T12:29:01.379Z
9571621 9571621 20260324031640_n7kiv BE001B 2026-03-25T12:02:08.372Z 2026-04-02T12:34:35.092Z
9571594 9571594 20260324030449_cJKT8 BE001B 2026-03-25T12:02:02.047Z 2026-04-02T12:34:33.575Z
9571306 9571306 20260324010345_n2dOl BE001B 2026-03-25T12:00:55.931Z 2026-04-02T12:34:19.145Z
9571046 9571046 20260322234111_guI2E BE001B 2026-03-24T12:24:14.309Z 2026-03-30T12:30:54.460Z
9570950 9570950 20260322232115_OmonY BE001B 2026-03-24T12:24:04.268Z 2026-03-30T12:30:52.624Z
9570528 9570528 20260322215239_geaVZ BE001B 2026-03-24T12:23:24.657Z 2026-03-30T12:30:44.781Z
9570418 9570418 20260322211640_Q1k0t BE001B 2026-03-24T12:23:14.381Z 2026-03-30T12:30:42.419Z
9570156 9570156 20260322193317_gudli BE001B 2026-03-24T12:22:39.778Z 2026-03-30T12:30:28.729Z
9562673 9562673 20260323025909_nrLKt BE001B 2026-03-24T12:03:43.879Z 2026-03-31T12:26:17.075Z
9562652 9562652 20260323025556_x7VVs BE001B 2026-03-24T12:03:40.310Z 2026-03-31T12:26:16.714Z
9562622 9562622 20260323024853_3K7sT BE001B 2026-03-24T12:03:35.157Z 2026-03-31T12:26:15.929Z
9562556 9562556 20260323023257_fe1ov BE001B 2026-03-24T12:03:24.963Z 2026-03-31T12:26:14.089Z
9562543 9562543 20260323023135_HSwXH BE001B 2026-03-24T12:03:22.456Z 2026-03-31T12:26:13.788Z
9562434 9562434 20260323022107_BMdcS BE001B 2026-03-24T12:03:07.185Z 2026-03-31T12:26:10.366Z
9562166 9562166 20260323014017_afURT BE001B 2026-03-24T12:02:20.663Z 2026-03-31T12:26:02.696Z
9561972 9561972 20260323010352_XPNvV BE001B 2026-03-24T12:01:44.067Z 2026-03-31T12:25:57.771Z
9561951 9561951 20260323010105_Lzw4Y BE001B 2026-03-24T12:01:40.586Z 2026-03-31T12:25:57.282Z
9561752 9561752 20260323003802_EDgej BE001B 2026-03-24T12:01:11.544Z 2026-03-31T12:25:52.843Z
9561743 9561743 20260323003711_CKj29 BE001B 2026-03-24T12:01:09.471Z 2026-03-31T12:25:52.525Z
9561726 9561726 20260323003545_MMbQ2 BE001B 2026-03-24T12:01:05.912Z 2026-03-31T12:25:52.112Z
9561665 9561665 20260323002038_C2sE9 BE001B 2026-03-24T12:00:52.065Z 2026-03-31T12:25:50.068Z
9561492 9561492 20260320224622_0fkhz BE001B 2026-03-23T12:15:29.184Z 2026-03-28T12:37:06.230Z
9561435 9561435 20260321233225_2L4zw BE001B 2026-03-23T12:12:19.020Z 2026-03-29T12:21:07.247Z
9561301 9561301 20260321231916_bsJHW BE001B 2026-03-23T12:12:15.950Z 2026-03-29T12:21:06.243Z
9561042 9561042 20260321225002_FZzsI BE001B 2026-03-23T12:12:10.438Z 2026-03-29T12:21:04.822Z
9560926 9560926 20260321223631_CzK9p BE001B 2026-03-23T12:12:07.770Z 2026-03-29T12:21:03.983Z
9560859 9560859 20260321222846_ZCG9T BE001B 2026-03-23T12:12:05.731Z 2026-03-29T12:21:03.435Z
9560733 9560733 20260321220747_Pm7UK BE001B 2026-03-23T12:12:02.000Z 2026-03-29T12:21:02.403Z
9560583 9560583 20260321214440_fqb0G BE001B 2026-03-23T12:11:56.839Z 2026-03-29T12:21:01.595Z
9560325 9560325 20260321210229_dWeie BE001B 2026-03-23T12:11:42.886Z 2026-03-29T12:20:59.305Z
9559935 9559935 20260321201215_4qrAf BE001B 2026-03-23T12:11:34.101Z 2026-03-29T12:20:56.698Z
9559728 9559728 20260321193418_fCMrk BE001B 2026-03-23T12:11:28.225Z 2026-03-29T12:20:47.255Z
9555104 9555104 20260322040506_CklZB BE001B 2026-03-23T12:03:10.218Z 2026-03-30T12:28:14.474Z
9554803 9554803 20260322033614_BbCge BE001B 2026-03-23T12:02:51.664Z 2026-03-30T12:28:09.153Z
9554608 9554608 20260322032023_aa3EO BE001B 2026-03-23T12:02:42.980Z 2026-03-30T12:28:06.372Z
9554353 9554353 20260322030138_s2LF6 BE001B 2026-03-23T12:02:28.160Z 2026-03-30T12:28:02.775Z
9554185 9554185 20260322024725_2nsNV BE001B 2026-03-23T12:02:19.001Z 2026-03-30T12:28:00.093Z
9554088 9554088 20260322023822_09ikE BE001B 2026-03-23T12:02:13.390Z 2026-03-30T12:27:58.187Z
9553784 9553784 20260322021348_2Dt8A BE001B 2026-03-23T12:01:51.712Z 2026-03-30T12:27:52.524Z
9553768 9553768 20260322021239_VUNFK BE001B 2026-03-23T12:01:51.056Z 2026-03-30T12:27:52.321Z
9553616 9553616 20260322020130_JQ8Zv BE001B 2026-03-23T12:01:43.408Z 2026-03-30T12:27:50.260Z
9553565 9553565 20260322015358_cSn56 BE001B 2026-03-23T12:01:40.593Z 2026-03-30T12:27:49.330Z
9553563 9553563 20260322015208_xrSbN BE001B 2026-03-23T12:01:40.334Z 2026-03-30T12:27:49.289Z
9553136 9553136 20260322011642_5dLfg BE001B 2026-03-23T12:01:14.919Z 2026-03-30T12:27:35.526Z
9553086 9553086 20260322010950_KBBor BE001B 2026-03-23T12:01:12.458Z 2026-03-30T12:27:34.698Z
9553076 9553076 20260322010909_48JmO BE001B 2026-03-23T12:01:11.783Z 2026-03-30T12:27:34.496Z
9553039 9553039 20260322010443_EYr2U BE001B 2026-03-23T12:01:09.990Z 2026-03-30T12:27:33.897Z
9552962 9552962 20260322010039_HuRq3 BE001B 2026-03-23T12:01:04.186Z 2026-03-30T12:27:33.039Z
9552674 9552674 20260322002943_UQ9MV BE001B 2026-03-23T12:00:41.908Z 2026-03-24T12:24:26.877Z
9552658 9552658 20260322002844_aPrn4 BE001B 2026-03-23T12:00:41.036Z 2026-03-30T12:27:27.704Z
9552547 9552547 20260322001903_3Q3a3 BE001B 2026-03-23T12:00:32.024Z 2026-03-30T12:27:25.997Z
9551974 9551974 20260320222805_JmJdx BE001B 2026-03-22T12:27:20.627Z 2026-03-28T12:37:05.210Z
9551892 9551892 20260320220552_Y21AU BE001B 2026-03-22T12:27:15.943Z 2026-03-28T12:37:03.721Z
9551868 9551868 20260320220118_iwe3u BE001B 2026-03-22T12:27:14.095Z 2026-03-28T12:37:03.336Z
9551730 9551730 20260320211547_jeTrn BE001B 2026-03-22T12:26:59.313Z 2026-03-28T12:37:01.235Z
9551662 9551662 20260320204737_mFw7Q BE001B 2026-03-22T12:26:54.662Z 2026-03-28T12:36:59.567Z
9543513 9543513 20260321040749_XrC02 BE001B 2026-03-22T12:04:02.345Z 2026-03-29T12:19:08.427Z
9543466 9543466 20260321035905_7kua9 BE001B 2026-03-22T12:03:53.964Z 2026-03-29T12:19:07.883Z
9543393 9543393 20260321034318_Pvhka BE001B 2026-03-22T12:03:40.881Z 2026-03-29T12:19:07.116Z
9542881 9542881 20260321014146_aIkh9 BE001B 2026-03-22T12:01:52.124Z 2026-03-29T12:18:59.413Z
9542585 9542585 20260321001643_xaUWW BE001B 2026-03-22T12:00:51.456Z 2026-03-29T12:18:46.074Z
9542559 9542559 20260321001345_hEjC0 BE001B 2026-03-22T12:00:46.794Z 2026-03-29T12:18:45.644Z
9542221 9542221 20260319230233_jbvvC BE001B 2026-03-21T12:29:52.096Z 2026-03-27T12:42:50.230Z
9542146 9542146 20260319225227_PBICW BE001B 2026-03-21T12:29:42.918Z 2026-03-27T12:42:45.968Z
9542114 9542114 20260319224816_HMt9q BE001B 2026-03-21T12:29:40.228Z 2026-03-27T12:42:45.174Z

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