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,544 rows where station_code = "DE0013" 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
9610914 9610914 20260404225053_kSjJn DE0013 2026-04-06T12:12:01.824Z 2026-04-06T12:16:14.690Z
9610709 9610709 20260404211606_BNFVF DE0013 2026-04-06T12:10:49.208Z 2026-04-06T12:16:14.640Z
9610460 9610460 20260404193401_kuFxJ DE0013 2026-04-06T12:09:37.583Z 2026-04-06T12:16:14.570Z
9604963 9604963 20260402021936_NvteE DE0013 2026-04-03T12:12:26.880Z 2026-04-06T12:26:35.231Z
9604938 9604938 20260402020614_nh0qH DE0013 2026-04-03T12:12:21.859Z 2026-04-06T12:26:33.596Z
9604877 9604877 20260402013247_3Q2JG DE0013 2026-04-03T12:12:01.062Z 2026-04-06T12:26:29.136Z
9604835 9604835 20260402011055_Z9kr3 DE0013 2026-04-03T12:11:51.377Z 2026-04-06T12:26:21.749Z
9604791 9604791 20260402004120_8WHdf DE0013 2026-04-03T12:11:33.212Z 2026-04-06T12:26:19.337Z
9604779 9604779 20260402003348_YSmzj DE0013 2026-04-03T12:11:31.322Z 2026-04-06T12:26:18.633Z
9604737 9604737 20260402001151_8Nr3L DE0013 2026-04-03T12:11:23.601Z 2026-04-06T12:26:14.774Z
9604637 9604637 20260401225036_RdvV8 DE0013 2026-04-03T12:10:56.812Z 2026-04-06T12:26:08.485Z
9604542 9604542 20260401200430_6kkzX DE0013 2026-04-03T12:10:17.701Z 2026-04-06T12:25:54.144Z
9602878 9602878 20260402034514_NVrRJ DE0013 2026-04-03T12:01:02.075Z 2026-04-06T12:21:18.228Z
9600831 9600831 20260401033624_FIYhn DE0013 2026-04-02T12:00:30.919Z 2026-04-06T12:24:12.402Z
9600768 9600768 20260401022947_goTWU DE0013 2026-04-02T12:00:11.782Z 2026-04-06T12:24:06.312Z
9600703 9600703 20260331011928_ptMGM DE0013 2026-04-01T12:11:35.759Z 2026-04-06T12:33:46.924Z
9600658 9600658 20260331003526_NLeSm DE0013 2026-04-01T12:11:26.341Z 2026-04-06T12:33:44.519Z
9600635 9600635 20260331002827_jT6np DE0013 2026-04-01T12:11:23.812Z 2026-04-06T12:33:43.591Z
9600559 9600559 20260330233303_4xy0y DE0013 2026-04-01T12:11:10.740Z 2026-04-06T12:33:34.418Z
9600553 9600553 20260330232811_4536b DE0013 2026-04-01T12:11:09.805Z 2026-04-06T12:33:34.112Z
9600362 9600362 20260330204423_sR2Lj DE0013 2026-04-01T12:10:26.166Z 2026-04-06T12:33:19.725Z
9594297 9594297 20260328210729_3vhZA DE0013 2026-03-30T12:09:14.521Z 2026-04-06T12:39:46.867Z
9592474 9592474 20260329021403_F6y2Y DE0013 2026-03-30T12:01:04.474Z 2026-04-06T12:34:11.927Z
9588577 9588577 20260326235948_9MaIy DE0013 2026-03-28T12:11:25.124Z 2026-04-04T12:42:20.079Z
9588506 9588506 20260326233120_vAKvo DE0013 2026-03-28T12:11:17.908Z 2026-04-04T12:42:17.224Z
9588443 9588443 20260326230205_812xx DE0013 2026-03-28T12:11:10.890Z 2026-04-04T12:42:08.718Z
9588412 9588412 20260326223743_hNcX5 DE0013 2026-03-28T12:11:07.575Z 2026-04-04T12:42:07.088Z
9588236 9588236 20260326192318_amkoB DE0013 2026-03-28T12:10:32.750Z 2026-04-04T12:41:49.355Z
9588226 9588226 20260326191418_m3GcJ DE0013 2026-03-28T12:10:31.367Z 2026-04-04T12:41:44.182Z
9586035 9586035 20260327033936_Qd1zD DE0013 2026-03-28T12:02:01.487Z 2026-04-05T12:32:57.607Z
9585992 9585992 20260327032608_DuYDC DE0013 2026-03-28T12:01:55.828Z 2026-04-05T12:32:55.903Z
9585733 9585733 20260327021758_IMZG3 DE0013 2026-03-28T12:01:09.805Z 2026-04-05T12:32:36.811Z
9585515 9585515 20260327012552_uYmTC DE0013 2026-03-28T12:00:33.448Z 2026-04-05T12:32:24.898Z
9585481 9585481 20260327011548_8xbae DE0013 2026-03-28T12:00:29.134Z 2026-04-05T12:32:23.526Z
9585393 9585393 20260327004703_j2nJ2 DE0013 2026-03-28T12:00:12.341Z 2026-04-05T12:32:19.214Z
9581644 9581644 20260326033758_T26bI DE0013 2026-03-27T12:03:32.612Z 2026-04-04T12:39:13.052Z
9581409 9581409 20260326030858_Rvjjc DE0013 2026-03-27T12:03:02.120Z 2026-04-04T12:39:03.846Z
9581371 9581371 20260326030056_y7mw6 DE0013 2026-03-27T12:02:53.354Z 2026-04-04T12:38:54.602Z
9581344 9581344 20260326025549_CEFk9 DE0013 2026-03-27T12:02:48.605Z 2026-04-04T12:38:53.603Z
9579738 9579738 20260324223829_N4T3s DE0013 2026-03-26T12:14:18.775Z 2026-04-02T12:37:27.958Z
9575603 9575603 20260323233956_ziz2B DE0013 2026-03-25T12:21:29.248Z 2026-03-31T12:29:02.843Z
9575564 9575564 20260323232119_zZbI2 DE0013 2026-03-25T12:21:24.523Z 2026-03-31T12:29:01.939Z
9575507 9575507 20260323225308_Agoos DE0013 2026-03-25T12:21:17.654Z 2026-03-31T12:29:00.495Z
9575495 9575495 20260323224923_rsav4 DE0013 2026-03-25T12:21:16.315Z 2026-03-31T12:29:00.207Z
9575354 9575354 20260323211737_Svf46 DE0013 2026-03-25T12:20:54.199Z 2026-03-31T12:28:55.470Z
9571088 9571088 20260322234338_vq7sp DE0013 2026-03-24T12:24:19.498Z 2026-03-30T12:30:54.993Z
9571058 9571058 20260322234138_6KNcU DE0013 2026-03-24T12:24:17.579Z 2026-03-30T12:30:54.548Z
9571006 9571006 20260322233159_brfrj DE0013 2026-03-24T12:24:08.533Z 2026-03-30T12:30:53.526Z
9570995 9570995 20260322233158_8Afrm DE0013 2026-03-24T12:24:08.161Z 2026-03-30T12:30:53.433Z
9562323 9562323 20260323020825_hNMfZ DE0013 2026-03-24T12:02:49.496Z 2026-03-31T12:26:07.760Z
9561707 9561707 20260323002948_p3tNT DE0013 2026-03-24T12:01:00.915Z 2026-03-31T12:25:51.416Z
9559969 9559969 20260321201412_MEcwd DE0013 2026-03-23T12:11:34.858Z 2026-03-29T12:20:56.948Z
9554784 9554784 20260322033436_d6Bsa DE0013 2026-03-23T12:02:50.903Z 2026-03-30T12:28:08.885Z
9553417 9553417 20260322014115_1OJQo DE0013 2026-03-23T12:01:28.833Z 2026-03-30T12:27:40.646Z
9552852 9552852 20260322004749_bopSJ DE0013 2026-03-23T12:00:56.181Z 2026-03-30T12:27:31.314Z
9552161 9552161 20260320230819_xwxmP DE0013 2026-03-22T12:27:30.412Z 2026-03-28T12:37:07.532Z
9552032 9552032 20260320224041_waCoV DE0013 2026-03-22T12:27:23.572Z 2026-03-28T12:37:05.710Z
9551947 9551947 20260320221745_I5O2S DE0013 2026-03-22T12:27:18.998Z 2026-03-28T12:37:04.763Z
9551871 9551871 20260320220152_n2n3P DE0013 2026-03-22T12:27:14.565Z 2026-03-28T12:37:03.405Z
9551847 9551847 20260320215354_IauaW DE0013 2026-03-22T12:27:06.344Z 2026-03-28T12:37:02.787Z
9543322 9543322 20260321033155_8gNEz DE0013 2026-03-22T12:03:26.857Z 2026-03-29T12:19:06.214Z
9543259 9543259 20260321031842_HsiDi DE0013 2026-03-22T12:03:12.293Z 2026-03-29T12:19:05.213Z
9543237 9543237 20260321031019_DKDmI DE0013 2026-03-22T12:03:07.394Z 2026-03-29T12:19:04.818Z
9542476 9542476 20260320234738_5ea9Y DE0013 2026-03-22T12:00:22.670Z 2026-03-29T12:18:44.459Z
9541977 9541977 20260319222116_t0Xbd DE0013 2026-03-21T12:29:33.056Z 2026-03-27T12:42:43.687Z
9541127 9541127 20260319193504_uztRY DE0013 2026-03-21T12:28:37.970Z 2026-03-27T12:42:34.332Z
9534722 9534722 20260320041502_IsFSl DE0013 2026-03-21T12:08:42.986Z 2026-03-28T12:34:21.343Z
9534611 9534611 20260320040419_ekWGB DE0013 2026-03-21T12:08:26.552Z 2026-03-28T12:34:19.959Z
9534569 9534569 20260320035957_CAQ2R DE0013 2026-03-21T12:08:16.893Z 2026-03-28T12:34:19.355Z
9534200 9534200 20260320033520_XrUDi DE0013 2026-03-21T12:07:25.806Z 2026-03-28T12:34:15.969Z
9533788 9533788 20260320025822_WGqox DE0013 2026-03-21T12:06:17.002Z 2026-03-28T12:34:00.503Z
9533412 9533412 20260320022905_6l2pq DE0013 2026-03-21T12:05:23.215Z 2026-03-28T12:33:52.924Z
9533316 9533316 20260320022426_TIswN DE0013 2026-03-21T12:05:09.866Z 2026-03-28T12:33:51.973Z
9532543 9532543 20260320010629_XxqYn DE0013 2026-03-21T12:03:02.115Z 2026-03-28T12:33:33.791Z
9532409 9532409 20260320005303_bXuvr DE0013 2026-03-21T12:02:38.283Z 2026-03-28T12:33:29.974Z
9532395 9532395 20260320005034_3i6f1 DE0013 2026-03-21T12:02:34.724Z 2026-03-28T12:33:29.431Z
9532213 9532213 20260320003814_kNBSE DE0013 2026-03-21T12:02:05.017Z 2026-03-28T12:33:25.886Z
9532124 9532124 20260320002124_DvXkE DE0013 2026-03-21T12:01:46.551Z 2026-03-28T12:33:24.777Z
9531436 9531436 20260318231007_rV0hY DE0013 2026-03-20T12:25:10.605Z 2026-03-26T12:39:19.373Z
9530789 9530789 20260318214330_UfbAk DE0013 2026-03-20T12:24:46.703Z 2026-03-26T12:39:15.553Z
9530519 9530519 20260318210453_vIcmK DE0013 2026-03-20T12:24:27.785Z 2026-03-26T12:39:13.329Z
9530444 9530444 20260318205445_JClmV DE0013 2026-03-20T12:24:24.033Z 2026-03-26T12:39:12.380Z
9529589 9529589 20260318185757_cFbOQ DE0013 2026-03-20T12:23:20.391Z 2026-03-26T12:39:04.698Z
9521295 9521295 20260319040321_XOVNn DE0013 2026-03-20T12:07:49.528Z 2026-03-27T12:40:53.646Z
9521114 9521114 20260319035420_P0a93 DE0013 2026-03-20T12:07:32.749Z 2026-03-27T12:40:51.803Z
9520592 9520592 20260319032707_rhzKQ DE0013 2026-03-20T12:06:37.303Z 2026-03-27T12:40:45.298Z
9520009 9520009 20260319024751_4FwtH DE0013 2026-03-20T12:05:32.334Z 2026-03-27T12:40:38.007Z
9520001 9520001 20260319024731_toRC2 DE0013 2026-03-20T12:05:31.453Z 2026-03-27T12:40:37.885Z
9519007 9519007 20260319014102_FQWMo DE0013 2026-03-20T12:03:46.342Z 2026-03-27T12:40:17.248Z
9518736 9518736 20260319012142_o0TIi DE0013 2026-03-20T12:03:12.510Z 2026-03-27T12:40:13.096Z
9518667 9518667 20260319011643_dDceF DE0013 2026-03-20T12:03:05.031Z 2026-03-27T12:40:12.481Z
9518620 9518620 20260319011406_2opwi DE0013 2026-03-20T12:03:00.770Z 2026-03-27T12:40:12.061Z
9518457 9518457 20260319010227_0Uk7V DE0013 2026-03-20T12:02:37.630Z 2026-03-27T12:40:10.072Z
9518257 9518257 20260319004717_oYrHC DE0013 2026-03-20T12:02:13.489Z 2026-03-27T12:40:07.993Z
9518018 9518018 20260319002217_w0veS DE0013 2026-03-20T12:01:43.896Z 2026-03-27T12:40:05.500Z
9517049 9517049 20260317223126_Swtmd DE0013 2026-03-19T12:27:07.709Z 2026-03-25T12:43:08.276Z
9516066 9516066 20260317195012_x1JKN DE0013 2026-03-19T12:25:35.816Z 2026-03-25T12:42:47.493Z
9515936 9515936 20260317192924_3mrsB DE0013 2026-03-19T12:25:20.239Z 2026-03-25T12:42:43.918Z
9515837 9515837 20260317190036_vda2c DE0013 2026-03-19T12:25:02.740Z 2026-03-25T12:42:40.025Z
9512025 9512025 20260318043517_38kfs DE0013 2026-03-19T12:11:30.461Z 2026-03-26T12:37:41.611Z

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