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,435 rows where station_code = "GR0006" 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
8675105 8675105 20251202040119_trpM7 GR0006 2025-12-03T14:23:02.810Z 2025-12-05T14:28:11.261Z
8675018 8675018 20251202035245_AJzdP GR0006 2025-12-03T14:22:50.922Z 2025-12-05T14:28:09.362Z
8674550 8674550 20251202024750_h3jdj GR0006 2025-12-03T14:21:53.307Z 2025-12-05T14:27:55.528Z
8674230 8674230 20251202015057_E2O5n GR0006 2025-12-03T14:21:16.236Z 2025-12-05T14:27:33.399Z
8673922 8673922 20251202003157_BBRQk GR0006 2025-12-03T14:20:23.160Z 2025-12-05T14:27:23.091Z
8673891 8673891 20251202002051_l7QVk GR0006 2025-12-03T14:20:15.647Z 2025-12-05T14:27:21.892Z
8673639 8673639 20251201205135_SY7R7 GR0006 2025-12-03T14:19:36.448Z 2025-12-05T14:26:57.179Z
8673624 8673624 20251201204350_LwnYG GR0006 2025-12-03T14:19:28.979Z 2025-12-05T14:26:56.282Z
8673571 8673571 20251201200830_YlBFh GR0006 2025-12-03T14:19:20.605Z 2025-12-05T14:26:53.288Z
8673481 8673481 20251201192559_kPCWV GR0006 2025-12-03T14:18:58.584Z 2025-12-05T14:26:47.810Z
8664899 8664899 20251201020014_fQ9A8 GR0006 2025-12-02T14:22:24.640Z 2025-12-05T14:35:35.645Z
8663782 8663782 20251130220217_AoJO1 GR0006 2025-12-02T14:19:06.926Z 2025-12-05T14:34:31.919Z
8663772 8663772 20251130215629_tk13l GR0006 2025-12-02T14:19:04.878Z 2025-12-05T14:34:31.405Z
8663147 8663147 20251130201534_zOfuF GR0006 2025-12-02T14:17:31.671Z 2025-12-05T14:33:58.352Z
8662992 8662992 20251130195238_NiCfQ GR0006 2025-12-02T14:17:15.084Z 2025-12-05T14:33:54.301Z
8662990 8662990 20251130195213_p052H GR0006 2025-12-02T14:17:14.577Z 2025-12-05T14:33:54.202Z
8662879 8662879 20251130194413_s3v5S GR0006 2025-12-02T14:16:55.035Z 2025-12-05T14:33:50.918Z
8662631 8662631 20251130191554_CCw2Y GR0006 2025-12-02T14:16:03.714Z 2025-12-05T14:33:41.634Z
8652752 8652752 20251130013001_gkOSb GR0006 2025-12-01T14:22:04.410Z 2025-12-05T14:42:51.526Z
8604452 8604452 20251124033231_SEMqg GR0006 2025-11-26T14:36:21.038Z 2025-12-02T15:12:56.476Z
8604448 8604448 20251124032256_r4xV4 GR0006 2025-11-26T14:36:18.352Z 2025-12-02T15:12:55.841Z
8604446 8604446 20251124031450_gBNPy GR0006 2025-11-26T14:36:16.937Z 2025-12-02T15:12:55.591Z
8604440 8604440 20251124023517_9hNA4 GR0006 2025-11-26T14:35:45.773Z 2025-12-02T15:12:46.359Z
8604438 8604438 20251124022500_Q93eW GR0006 2025-11-26T14:35:29.454Z 2025-12-02T15:12:42.743Z
8604436 8604436 20251124021640_w92uY GR0006 2025-11-26T14:35:27.756Z 2025-12-02T15:12:41.515Z
8604423 8604423 20251124015733_HaJ3d GR0006 2025-11-26T14:35:22.701Z 2025-12-02T15:12:37.019Z
8604407 8604407 20251124012109_urzkS GR0006 2025-11-26T14:35:13.796Z 2025-12-02T15:12:18.388Z
8604403 8604403 20251124002143_0DOmY GR0006 2025-11-26T14:34:49.549Z 2025-12-02T15:11:50.026Z
8604400 8604400 20251124000658_BpYaG GR0006 2025-11-26T14:34:35.008Z 2025-12-02T15:11:49.213Z
8604393 8604393 20251123231950_mokjA GR0006 2025-11-26T14:34:26.057Z 2025-12-02T15:11:25.206Z
8604384 8604384 20251123221125_QU5R7 GR0006 2025-11-26T14:34:14.456Z 2025-12-02T15:11:16.567Z
8604382 8604382 20251123220932_h8wTc GR0006 2025-11-26T14:34:13.867Z 2025-12-02T15:11:13.815Z
8604380 8604380 20251123220801_xzQF2 GR0006 2025-11-26T14:34:13.657Z 2025-12-02T15:11:13.723Z
8604372 8604372 20251123213728_9KKSH GR0006 2025-11-26T14:34:06.785Z 2025-12-02T15:11:09.608Z
8604361 8604361 20251123203941_CG9zT GR0006 2025-11-26T14:33:22.508Z 2025-12-02T15:11:02.050Z
8604359 8604359 20251123203528_RUfqW GR0006 2025-11-26T14:33:21.908Z 2025-12-02T15:11:01.710Z
8604357 8604357 20251123201449_5C2Vd GR0006 2025-11-26T14:33:18.738Z 2025-12-02T15:10:56.200Z
8604353 8604353 20251123200710_ZSQNf GR0006 2025-11-26T14:33:17.274Z 2025-12-02T15:10:55.014Z
8604351 8604351 20251123200103_O2a46 GR0006 2025-11-26T14:33:16.651Z 2025-12-02T15:10:52.484Z
8604348 8604348 20251123194420_623dM GR0006 2025-11-26T14:33:14.544Z 2025-12-02T15:10:48.531Z
8604344 8604344 20251123192616_HrjtC GR0006 2025-11-26T14:33:12.134Z 2025-12-02T15:10:45.869Z
8604342 8604342 20251123190456_9VyCJ GR0006 2025-11-26T14:33:10.467Z 2025-12-02T15:10:45.295Z
8604335 8604335 20251123185302_9gC5Z GR0006 2025-11-26T14:33:08.450Z 2025-12-02T15:10:44.389Z
8604332 8604332 20251123181003_QumAV GR0006 2025-11-26T14:33:00.295Z 2025-12-02T15:10:34.744Z
8604328 8604328 20251123174908_1nwQv GR0006 2025-11-26T14:32:50.554Z 2025-12-02T15:10:21.057Z
8604322 8604322 20251123172802_mMELM GR0006 2025-11-26T14:32:15.338Z 2025-12-02T15:10:08.369Z
8604317 8604317 20251123171343_YTH2X GR0006 2025-11-26T14:31:59.009Z 2025-12-02T15:10:05.005Z
8591604 8591604 20251124043116_eKPwn GR0006 2025-11-25T14:24:37.223Z 2025-12-02T15:12:59.633Z
8591572 8591572 20251124042541_TgnxA GR0006 2025-11-25T14:24:33.135Z 2025-12-02T15:12:59.366Z
8591366 8591366 20251124040901_sHxXO GR0006 2025-11-25T14:24:00.194Z 2025-12-02T15:12:58.366Z
8591323 8591323 20251124040425_JXOUS GR0006 2025-11-25T14:23:54.067Z 2025-12-02T15:12:57.946Z
8591266 8591266 20251124035914_kyHjT GR0006 2025-11-25T14:23:49.143Z 2025-12-02T15:12:57.704Z
8591077 8591077 20251124034417_CEJ0c GR0006 2025-11-25T14:23:34.718Z 2025-12-02T15:12:57.007Z
8591019 8591019 20251124033658_mTll2 GR0006 2025-11-25T14:23:16.168Z 2025-12-02T15:12:56.683Z
8590989 8590989 20251124033237_T6Mik GR0006 2025-11-25T14:23:11.870Z 2025-12-02T15:12:56.478Z
8590658 8590658 20251124030044_fl5G2 GR0006 2025-11-25T14:22:21.135Z 2025-12-02T15:12:53.739Z
8590629 8590629 20251124025928_lOec0 GR0006 2025-11-25T14:22:19.296Z 2025-12-02T15:12:53.259Z
8590613 8590613 20251124025656_AuodC GR0006 2025-11-25T14:22:17.928Z 2025-12-02T15:12:53.124Z
8590510 8590510 20251124024826_fWPZc GR0006 2025-11-25T14:22:08.501Z 2025-12-02T15:12:49.163Z
8590419 8590419 20251124023955_Uu3h9 GR0006 2025-11-25T14:21:52.044Z 2025-12-02T15:12:47.331Z
8590128 8590128 20251124022507_Te26O GR0006 2025-11-25T14:21:27.031Z 2025-12-02T15:12:42.765Z
8590105 8590105 20251124022246_Swxpd GR0006 2025-11-25T14:21:23.956Z 2025-12-02T15:12:42.420Z
8590061 8590061 20251124021850_OyyPW GR0006 2025-11-25T14:21:19.933Z 2025-12-02T15:12:41.692Z
8589999 8589999 20251124021527_BkPtH GR0006 2025-11-25T14:21:06.361Z 2025-12-02T15:12:41.342Z
8589961 8589961 20251124021158_Z5lgC GR0006 2025-11-25T14:21:01.382Z 2025-12-02T15:12:40.670Z
8589895 8589895 20251124020331_joy7I GR0006 2025-11-25T14:20:53.594Z 2025-12-02T15:12:39.465Z
8589881 8589881 20251124020146_gxYme GR0006 2025-11-25T14:20:52.139Z 2025-12-02T15:12:38.975Z
8589404 8589404 20251124013113_YAgpY GR0006 2025-11-25T14:19:53.030Z 2025-12-02T15:12:25.519Z
8589387 8589387 20251124012946_KTnui GR0006 2025-11-25T14:19:48.318Z 2025-12-02T15:12:22.939Z
8589333 8589333 20251124012434_nyIYu GR0006 2025-11-25T14:19:39.732Z 2025-12-02T15:12:19.364Z
8589331 8589331 20251124012428_LwvRw GR0006 2025-11-25T14:19:39.401Z 2025-12-02T15:12:19.329Z
8589287 8589287 20251124012136_CuhWv GR0006 2025-11-25T14:19:36.324Z 2025-12-02T15:12:18.425Z
8589279 8589279 20251124012023_2RoQO GR0006 2025-11-25T14:19:35.488Z 2025-12-02T15:12:17.237Z
8589267 8589267 20251124011904_57w2k GR0006 2025-11-25T14:19:34.477Z 2025-12-02T15:12:14.634Z
8589253 8589253 20251124011841_uaDmu GR0006 2025-11-25T14:19:33.614Z 2025-12-02T15:12:14.584Z
8589198 8589198 20251124011340_z9rJz GR0006 2025-11-25T14:19:26.672Z 2025-12-02T15:12:10.994Z
8588958 8588958 20251124004819_DwN8t GR0006 2025-11-25T14:18:49.199Z 2025-12-02T15:12:03.078Z
8588941 8588941 20251124004644_huKYI GR0006 2025-11-25T14:18:47.841Z 2025-12-02T15:12:02.047Z
8588521 8588521 20251124000508_XAHzb GR0006 2025-11-25T14:17:42.505Z 2025-12-02T15:11:48.783Z
8588410 8588410 20251123235429_DZ2rX GR0006 2025-11-25T14:17:31.807Z 2025-12-02T15:11:41.487Z
8588247 8588247 20251123233441_82mbQ GR0006 2025-11-25T14:17:07.862Z 2025-12-02T15:11:38.530Z
8587982 8587982 20251123230618_gcNDM GR0006 2025-11-25T14:16:31.592Z 2025-12-02T15:11:23.562Z
8587946 8587946 20251123230256_FrFPa GR0006 2025-11-25T14:16:29.055Z 2025-12-02T15:11:22.806Z
8587861 8587861 20251123225421_4zgBs GR0006 2025-11-25T14:16:19.927Z 2025-12-02T15:11:21.813Z
8587786 8587786 20251123224357_vLxEr GR0006 2025-11-25T14:16:04.164Z 2025-12-02T15:11:19.879Z
8586730 8586730 20251123203737_vGsLR GR0006 2025-11-25T14:13:40.156Z 2025-12-02T15:11:01.987Z
8586562 8586562 20251123200808_4tYGs GR0006 2025-11-25T14:13:14.415Z 2025-12-02T15:10:55.069Z
8586513 8586513 20251123195756_g5v1C GR0006 2025-11-25T14:13:03.999Z 2025-12-02T15:10:51.001Z
8586079 8586079 20251123183957_0YM3Q GR0006 2025-11-25T14:11:47.517Z 2025-12-02T15:10:43.429Z
8586006 8586006 20251123182832_KlPuD GR0006 2025-11-25T14:11:36.708Z 2025-12-02T15:10:39.422Z
8579444 8579444 20251122234645_SzEMW GR0006 2025-11-24T14:14:22.574Z 2025-12-01T15:20:24.053Z
8566201 8566201 20251121233147_EIldo GR0006 2025-11-23T14:15:27.974Z 2025-11-30T15:05:36.571Z
8565787 8565787 20251121211602_FKmMs GR0006 2025-11-23T14:14:04.230Z 2025-11-30T15:05:10.008Z
8549245 8549245 20251120221005_Nr48x GR0006 2025-11-22T14:18:34.975Z 2025-11-29T14:54:24.353Z
8546685 8546685 20251120184724_P7Ley GR0006 2025-11-22T14:13:20.146Z 2025-11-29T14:54:17.374Z
8493657 8493657 20251117015711_LyVR6 GR0006 2025-11-18T14:22:41.114Z 2025-11-25T15:09:20.616Z
8492934 8492934 20251117010433_OU7oe GR0006 2025-11-18T14:20:58.291Z 2025-11-25T15:09:00.330Z
8492742 8492742 20251117004957_euyUt GR0006 2025-11-18T14:20:28.277Z 2025-11-25T15:08:56.397Z
8492445 8492445 20251117002621_Arc78 GR0006 2025-11-18T14:19:46.076Z 2025-11-25T15:08:51.925Z
8492405 8492405 20251117002403_hlMOu GR0006 2025-11-18T14:19:42.313Z 2025-11-25T15:08:51.732Z

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