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

945 rows where station_code = "DE000V" 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
7962357 7962357 20250925021753_hIBTd DE000V 2025-09-26T12:27:14.488Z 2025-10-03T13:04:19.407Z
7959302 7959302 20250924232629_zeyRy DE000V 2025-09-26T12:22:45.061Z 2025-10-03T13:04:04.221Z
7959299 7959299 20250924232629_IqCzt DE000V 2025-09-26T12:22:44.861Z 2025-10-03T13:04:04.219Z
7957170 7957170 20250924202024_shH3P DE000V 2025-09-26T12:18:48.382Z 2025-10-03T13:03:57.372Z
7956872 7956872 20250924195218_KYXKt DE000V 2025-09-26T12:18:05.030Z 2025-10-03T13:03:56.060Z
7950634 7950634 20250924025831_05dtd DE000V 2025-09-25T12:35:23.723Z 2025-10-02T13:27:59.702Z
7950098 7950098 20250924023238_IoceW DE000V 2025-09-25T12:34:43.254Z 2025-10-02T13:27:48.473Z
7946874 7946874 20250923233158_NgmAD DE000V 2025-09-25T12:29:42.383Z 2025-10-02T13:26:43.827Z
7943507 7943507 20250923195047_XvAWS DE000V 2025-09-25T12:22:59.654Z 2025-10-02T13:26:17.423Z
7937400 7937400 20250924033509_GIrOe DE000V 2025-09-25T12:00:15.026Z 2025-10-03T13:02:24.230Z
7934312 7934312 20250922004450_TXXTI DE000V 2025-09-24T12:51:57.202Z 2025-09-30T13:03:11.168Z
7928518 7928518 20250921195935_EFMoT DE000V 2025-09-24T12:45:57.626Z 2025-09-30T13:02:11.425Z
7927977 7927977 20250921191656_tHe3Q DE000V 2025-09-24T12:45:24.279Z 2025-09-30T13:02:09.230Z
7920755 7920755 20250923013152_xGI3I DE000V 2025-09-24T12:29:08.915Z 2025-10-01T13:24:29.983Z
7905678 7905678 20250921000151_9Iol6 DE000V 2025-09-22T12:35:21.229Z 2025-09-29T13:05:23.373Z
7905589 7905589 20250920235254_kAd0v DE000V 2025-09-22T12:35:17.249Z 2025-09-29T13:05:22.739Z
7897873 7897873 20250921030219_ky99l DE000V 2025-09-22T12:03:50.369Z 2025-09-30T13:00:58.941Z
7897746 7897746 20250921025609_nNkyk DE000V 2025-09-22T12:03:18.395Z 2025-09-30T13:00:57.323Z
7894490 7894490 20250919224027_O9LCw DE000V 2025-09-21T12:37:14.274Z 2025-09-28T12:54:35.230Z
7894027 7894027 20250919221113_8PXp7 DE000V 2025-09-21T12:36:21.162Z 2025-09-28T12:54:32.618Z
7893463 7893463 20250919212703_SfoKG DE000V 2025-09-21T12:35:23.221Z 2025-09-28T12:54:27.772Z
7892604 7892604 20250919201349_UpF0U DE000V 2025-09-21T12:34:13.144Z 2025-09-28T12:54:18.883Z
7892321 7892321 20250919194924_iPNaB DE000V 2025-09-21T12:33:37.540Z 2025-09-28T12:54:17.873Z
7891682 7891682 20250919183534_2BE7N DE000V 2025-09-21T12:32:08.494Z 2025-09-28T12:54:12.397Z
7884378 7884378 20250920022754_GPV1h DE000V 2025-09-21T12:03:41.434Z 2025-09-29T13:02:48.457Z
7863804 7863804 20250916224432_G7RmC DE000V 2025-09-18T12:35:36.377Z 2025-09-24T13:17:43.052Z
7863802 7863802 20250916224432_0ZOSI DE000V 2025-09-18T12:35:35.835Z 2025-09-24T13:17:43.024Z
7857334 7857334 20250917021911_w7B9M DE000V 2025-09-18T12:05:32.963Z 2025-09-25T13:10:41.461Z
7857267 7857267 20250917020530_R646v DE000V 2025-09-18T12:05:13.502Z 2025-09-25T13:10:39.501Z
7857123 7857123 20250917014755_jedFp DE000V 2025-09-18T12:04:32.023Z 2025-09-25T13:10:37.499Z
7856632 7856632 20250917003808_j04x3 DE000V 2025-09-18T12:01:53.612Z 2025-09-25T13:10:31.108Z
7856627 7856627 20250917003629_suEg9 DE000V 2025-09-18T12:01:42.551Z 2025-09-25T13:10:31.100Z
7856443 7856443 20250917000628_xhsfw DE000V 2025-09-18T12:00:51.089Z 2025-09-25T13:10:28.903Z
7855376 7855376 20250915213620_y3xIs DE000V 2025-09-17T12:36:20.857Z 2025-09-22T13:05:51.276Z
7853999 7853999 20250915192148_Y6rxp DE000V 2025-09-17T12:34:09.135Z 2025-09-22T13:05:25.512Z
7843776 7843776 20250915232026_oJoJ6 DE000V 2025-09-17T12:00:36.069Z 2025-09-24T13:14:55.171Z
7841899 7841899 20250914191634_rL9Gs DE000V 2025-09-16T12:33:27.141Z 2025-09-22T13:09:03.862Z
7829056 7829056 20250913194153_A2V4F DE000V 2025-09-15T12:17:44.596Z 2025-09-21T13:09:54.506Z
7828976 7828976 20250913191059_2H6K3 DE000V 2025-09-15T12:17:20.487Z 2025-09-21T13:09:52.928Z
7828966 7828966 20250913190409_QiLpm DE000V 2025-09-15T12:17:18.472Z 2025-09-21T13:09:52.375Z
7828959 7828959 20250913190058_ADQO2 DE000V 2025-09-15T12:17:17.282Z 2025-09-21T13:09:52.322Z
7824091 7824091 20250912201746_OlUAI DE000V 2025-09-14T12:29:23.000Z 2025-09-20T13:03:08.182Z
7820465 7820465 20250913030517_V2R4m DE000V 2025-09-14T12:08:48.107Z 2025-09-21T13:08:39.345Z
7820373 7820373 20250913025709_IQW1b DE000V 2025-09-14T12:08:31.038Z 2025-09-21T13:08:36.389Z
7820013 7820013 20250913015101_2Haq3 DE000V 2025-09-14T12:06:58.078Z 2025-09-21T13:08:26.834Z
7819772 7819772 20250913010025_A3gTe DE000V 2025-09-14T12:05:51.131Z 2025-09-21T13:08:21.939Z
7819251 7819251 20250912232242_Jp2JE DE000V 2025-09-14T12:03:29.279Z 2025-09-21T13:08:11.424Z
7812675 7812675 20250912025924_4k3QW DE000V 2025-09-13T12:13:42.748Z 2025-09-20T13:01:59.332Z
7812425 7812425 20250912024530_fXC2N DE000V 2025-09-13T12:13:02.701Z 2025-09-20T13:01:56.064Z
7811921 7811921 20250912020313_1HRVh DE000V 2025-09-13T12:11:18.117Z 2025-09-20T13:01:48.814Z
7811257 7811257 20250912010729_bhxc1 DE000V 2025-09-13T12:09:01.140Z 2025-09-20T13:01:37.868Z
7810804 7810804 20250912002242_3hXks DE000V 2025-09-13T12:07:28.369Z 2025-09-20T13:01:33.540Z
7809606 7809606 20250911215641_XFCkr DE000V 2025-09-13T12:02:39.185Z 2025-09-20T13:01:14.610Z
7805605 7805605 20250911023343_q4xcg DE000V 2025-09-12T12:06:48.552Z 2025-09-19T12:56:57.714Z
7805408 7805408 20250911015838_33wt0 DE000V 2025-09-12T12:06:10.545Z 2025-09-19T12:56:55.161Z
7805180 7805180 20250911011011_X9bdL DE000V 2025-09-12T12:05:20.076Z 2025-09-19T12:56:53.330Z
7790134 7790134 20250908004529_eGwc9 DE000V 2025-09-09T12:05:55.834Z 2025-09-16T12:50:59.744Z
7789974 7789974 20250907235633_wZgHs DE000V 2025-09-09T12:05:21.968Z 2025-09-16T12:50:55.450Z
7789543 7789543 20250907212943_jQ1Qm DE000V 2025-09-09T12:03:52.309Z 2025-09-16T12:50:51.175Z
7789052 7789052 20250907192220_9scD2 DE000V 2025-09-09T12:02:04.728Z 2025-09-16T12:50:39.853Z
7780652 7780652 20250906031112_y2KV2 DE000V 2025-09-07T12:13:22.202Z 2025-09-14T12:50:03.775Z
7778365 7778365 20250905223111_M0MDE DE000V 2025-09-07T12:05:09.433Z 2025-09-14T12:48:57.393Z
7777998 7777998 20250905211513_4NtBk DE000V 2025-09-07T12:03:46.628Z 2025-09-14T12:48:53.910Z
7777792 7777792 20250905202311_4pPpX DE000V 2025-09-07T12:03:01.639Z 2025-09-14T12:48:51.722Z
7777654 7777654 20250905195519_06usC DE000V 2025-09-07T12:02:28.968Z 2025-09-14T12:48:50.318Z
7763781 7763781 20250904024714_Qw0ZL DE000V 2025-09-05T12:22:02.615Z 2025-09-12T12:51:05.757Z
7763644 7763644 20250904023748_HyhHr DE000V 2025-09-05T12:21:51.435Z 2025-09-12T12:50:57.357Z
7751249 7751249 20250903021656_d2E8A DE000V 2025-09-04T12:15:51.878Z 2025-09-11T12:43:57.274Z
7750692 7750692 20250903010335_b4qAM DE000V 2025-09-04T12:14:13.085Z 2025-09-11T12:43:46.339Z
7750520 7750520 20250903003355_opt2L DE000V 2025-09-04T12:13:39.056Z 2025-09-11T12:43:45.069Z
7750384 7750384 20250903000242_AUj1N DE000V 2025-09-04T12:13:21.610Z 2025-09-11T12:43:44.153Z
7750215 7750215 20250902233318_PU7E2 DE000V 2025-09-04T12:12:48.785Z 2025-09-11T12:43:40.950Z
7713505 7713505 20250831011458_M0gz9 DE000V 2025-09-01T12:17:07.072Z 2025-09-08T12:52:28.288Z
7706523 7706523 20250830023652_0E2wc DE000V 2025-08-31T12:28:20.858Z 2025-09-07T12:58:45.549Z
7705423 7705423 20250830013810_I5oc3 DE000V 2025-08-31T12:26:21.727Z 2025-09-07T12:58:35.708Z
7704139 7704139 20250830002858_BjHNq DE000V 2025-08-31T12:23:57.419Z 2025-09-07T12:58:24.892Z
7703164 7703164 20250829231546_3LQYu DE000V 2025-08-31T12:21:57.921Z 2025-09-07T12:58:10.433Z
7695162 7695162 20250829002425_ADHtp DE000V 2025-08-30T12:25:22.655Z 2025-09-06T14:13:00.014Z
7658792 7658792 20250825233024_gKjO7 DE000V 2025-08-27T12:20:54.738Z 2025-09-03T12:52:39.928Z
7656030 7656030 20250825203208_ohPJu DE000V 2025-08-27T12:14:10.361Z 2025-09-03T12:52:08.988Z
7636619 7636619 20250824015022_r2lOp DE000V 2025-08-25T12:28:06.731Z 2025-09-01T12:56:10.586Z
7635337 7635337 20250824003526_W0ben DE000V 2025-08-25T12:25:46.341Z 2025-09-01T12:56:07.412Z
7633635 7633635 20250823224051_yimGa DE000V 2025-08-25T12:21:29.195Z 2025-09-01T12:56:03.205Z
7633362 7633362 20250823221557_296au DE000V 2025-08-25T12:20:49.224Z 2025-09-01T12:56:02.261Z
7624435 7624435 20250822235329_1urpx DE000V 2025-08-24T12:24:09.890Z 2025-08-31T12:54:07.124Z
7613638 7613638 20250822020955_1LYXd DE000V 2025-08-23T12:26:11.017Z 2025-08-30T12:59:39.496Z
7613290 7613290 20250822014512_MErNe DE000V 2025-08-23T12:25:27.515Z 2025-08-30T12:59:37.604Z
7612782 7612782 20250822011047_ADmMd DE000V 2025-08-23T12:24:38.041Z 2025-08-30T12:59:35.556Z
7602231 7602231 20250821023337_sUzeA DE000V 2025-08-22T12:26:44.002Z 2025-08-29T12:56:52.921Z
7601643 7601643 20250821011830_tbGVA DE000V 2025-08-22T12:25:39.365Z 2025-08-29T12:56:48.186Z
7601089 7601089 20250821002538_IueEo DE000V 2025-08-22T12:24:34.636Z 2025-08-29T12:56:45.476Z
7600100 7600100 20250820224142_X2POV DE000V 2025-08-22T12:23:06.220Z 2025-08-29T12:56:34.445Z
7600076 7600076 20250820223855_7WkVf DE000V 2025-08-22T12:22:55.763Z 2025-08-29T12:56:34.436Z
7599944 7599944 20250820222458_6OLxX DE000V 2025-08-22T12:22:27.493Z 2025-08-29T12:56:33.635Z
7599914 7599914 20250820222135_Ke7vz DE000V 2025-08-22T12:22:25.900Z 2025-08-29T12:56:33.601Z
7598887 7598887 20250820201840_PVnWf DE000V 2025-08-22T12:20:23.331Z 2025-08-29T12:56:25.542Z
7590920 7590920 20250819013436_2x2lb DE000V 2025-08-21T12:37:29.034Z 2025-08-27T13:16:17.231Z
7590667 7590667 20250819012502_2zjGV DE000V 2025-08-21T12:37:24.273Z 2025-08-27T13:16:06.060Z
7590099 7590099 20250819005606_iZ4Em DE000V 2025-08-21T12:37:10.137Z 2025-08-27T13:15:58.395Z
7587063 7587063 20250818215321_nlhSc DE000V 2025-08-21T12:36:03.502Z 2025-08-27T13:14:39.315Z

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