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

3,946 rows where station_code = "ES001A" 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
8666543 8666543 20251201061849_vsRQb ES001A 2025-12-02T14:26:25.886Z 2025-12-06T14:42:39.508Z
8666499 8666499 20251201055621_IphNd ES001A 2025-12-02T14:26:19.959Z 2025-12-06T14:42:23.967Z
8666376 8666376 20251201052621_413PM ES001A 2025-12-02T14:25:54.796Z 2025-12-06T14:42:20.063Z
8666261 8666261 20251201050353_aZlef ES001A 2025-12-02T14:25:40.842Z 2025-12-06T14:42:15.860Z
8666129 8666129 20251201044031_YQtWS ES001A 2025-12-02T14:25:17.795Z 2025-12-06T14:42:12.497Z
8665993 8665993 20251201042038_3nE3S ES001A 2025-12-02T14:25:03.695Z 2025-12-06T14:42:09.096Z
8665976 8665976 20251201041611_9WRJI ES001A 2025-12-02T14:25:00.813Z 2025-12-06T14:42:08.299Z
8665937 8665937 20251201041154_rzc7A ES001A 2025-12-02T14:24:56.419Z 2025-12-06T14:42:07.263Z
8665868 8665868 20251201040411_ZWUzL ES001A 2025-12-02T14:24:36.939Z 2025-12-06T14:42:05.451Z
8665746 8665746 20251201035415_rBrsJ ES001A 2025-12-02T14:24:24.321Z 2025-12-06T14:41:47.966Z
8665487 8665487 20251201032518_tTDt3 ES001A 2025-12-02T14:23:46.117Z 2025-12-06T14:41:38.555Z
8665388 8665388 20251201031445_9L29p ES001A 2025-12-02T14:23:36.810Z 2025-12-06T14:41:36.671Z
8665136 8665136 20251201023518_rVpvW ES001A 2025-12-02T14:22:59.403Z 2025-12-06T14:41:27.715Z
8664554 8664554 20251201005603_bzN5C ES001A 2025-12-02T14:21:21.346Z 2025-12-06T14:40:50.753Z
8664516 8664516 20251201004405_KEghc ES001A 2025-12-02T14:21:14.621Z 2025-12-06T14:40:49.228Z
8664462 8664462 20251201003444_ScIXX ES001A 2025-12-02T14:21:08.162Z 2025-12-06T14:40:47.717Z
8663105 8663105 20251130201054_vHOkG ES001A 2025-12-02T14:17:27.946Z 2025-12-06T14:39:50.741Z
8662636 8662636 20251130191633_IO83l ES001A 2025-12-02T14:16:04.530Z 2025-12-06T14:39:24.626Z
8647942 8647942 20251129060614_sgaXj ES001A 2025-11-30T14:29:25.006Z 2025-12-06T14:56:58.771Z
8647829 8647829 20251129054000_YIMvH ES001A 2025-11-30T14:29:07.607Z 2025-12-06T14:56:48.740Z
8647796 8647796 20251129053425_VU3IZ ES001A 2025-11-30T14:28:55.731Z 2025-12-06T14:56:48.165Z
8647750 8647750 20251129051923_Q225M ES001A 2025-11-30T14:28:50.999Z 2025-12-06T14:56:46.436Z
8647295 8647295 20251129041621_nvBRc ES001A 2025-11-30T14:27:57.225Z 2025-12-06T14:56:36.087Z
8647282 8647282 20251129041506_C6CJ8 ES001A 2025-11-30T14:27:56.186Z 2025-12-06T14:56:35.802Z
8647216 8647216 20251129040627_2thPq ES001A 2025-11-30T14:27:51.415Z 2025-12-06T14:56:34.013Z
8647214 8647214 20251129040553_ylOtb ES001A 2025-11-30T14:27:51.232Z 2025-12-06T14:56:33.960Z
8647080 8647080 20251129033718_EfY39 ES001A 2025-11-30T14:27:28.020Z 2025-12-06T14:56:31.324Z
8646701 8646701 20251129023945_jkBXk ES001A 2025-11-30T14:26:40.871Z 2025-12-06T14:56:23.641Z
8646670 8646670 20251129023808_e2tLv ES001A 2025-11-30T14:26:38.867Z 2025-12-06T14:56:23.154Z
8646302 8646302 20251129014220_9nwNv ES001A 2025-11-30T14:25:48.716Z 2025-12-06T14:55:56.048Z
8646084 8646084 20251129010153_CRy2f ES001A 2025-11-30T14:25:10.122Z 2025-12-06T14:55:32.195Z
8646045 8646045 20251129005432_H4mMf ES001A 2025-11-30T14:25:06.210Z 2025-12-06T14:55:27.674Z
8646027 8646027 20251129005108_GbTA2 ES001A 2025-11-30T14:25:05.279Z 2025-12-06T14:55:27.007Z
8645932 8645932 20251129003015_E33Sf ES001A 2025-11-30T14:24:56.664Z 2025-12-06T14:55:16.058Z
8645924 8645924 20251129002853_cP1Ej ES001A 2025-11-30T14:24:55.484Z 2025-12-06T14:55:15.176Z
8645787 8645787 20251128235055_XlAEj ES001A 2025-11-30T14:24:31.884Z 2025-12-06T14:55:07.569Z
8645690 8645690 20251128232812_4XmbO ES001A 2025-11-30T14:24:24.148Z 2025-12-06T14:55:02.211Z
8643800 8643800 20251128182752_hIiVL ES001A 2025-11-30T14:20:41.553Z 2025-12-06T14:54:16.174Z
8638244 8638244 20251123053317_qI6rg ES001A 2025-11-29T14:49:08.540Z 2025-12-01T15:22:22.012Z
8638242 8638242 20251123052333_ZDQBj ES001A 2025-11-29T14:49:08.140Z 2025-12-01T15:22:21.401Z
8638226 8638226 20251123005034_jQh3N ES001A 2025-11-29T14:48:48.697Z 2025-12-01T15:20:55.970Z
8638224 8638224 20251123004850_Lh2xG ES001A 2025-11-29T14:48:48.599Z 2025-12-01T15:20:55.260Z
8638215 8638215 20251122223903_2haed ES001A 2025-11-29T14:48:45.158Z 2025-12-01T15:20:06.145Z
8638210 8638210 20251122205048_R8RkX ES001A 2025-11-29T14:48:42.124Z 2025-12-01T15:19:47.370Z
8638206 8638206 20251122195406_iJL58 ES001A 2025-11-29T14:48:40.188Z 2025-12-01T15:19:18.486Z
8637671 8637671 20251128060832_ruthp ES001A 2025-11-29T14:27:41.848Z 2025-12-06T15:04:02.509Z
8637662 8637662 20251128060720_HqexT ES001A 2025-11-29T14:27:40.873Z 2025-12-06T15:04:02.198Z
8637377 8637377 20251128053423_vH860 ES001A 2025-11-29T14:27:11.027Z 2025-12-06T15:03:59.450Z
8637229 8637229 20251128051654_TvhQh ES001A 2025-11-29T14:26:59.304Z 2025-12-06T15:03:57.807Z
8637014 8637014 20251128044930_N8upC ES001A 2025-11-29T14:26:32.847Z 2025-12-06T15:03:55.673Z
8636761 8636761 20251128042339_3zyHQ ES001A 2025-11-29T14:26:09.900Z 2025-12-06T15:03:40.825Z
8636497 8636497 20251128035230_0F849 ES001A 2025-11-29T14:25:34.960Z 2025-12-06T15:03:21.609Z
8635963 8635963 20251128030236_MnjX3 ES001A 2025-11-29T14:24:42.467Z 2025-12-06T15:02:54.642Z
8635542 8635542 20251128022414_I3G0I ES001A 2025-11-29T14:23:39.377Z 2025-12-06T15:02:46.227Z
8635482 8635482 20251128021740_Pajfg ES001A 2025-11-29T14:23:28.122Z 2025-12-06T15:02:45.108Z
8634920 8634920 20251128012623_HdyJG ES001A 2025-11-29T14:22:12.119Z 2025-12-06T15:02:37.703Z
8634732 8634732 20251128011504_4pW39 ES001A 2025-11-29T14:21:59.745Z 2025-12-06T15:02:34.354Z
8634270 8634270 20251128003347_W9O3T ES001A 2025-11-29T14:21:08.982Z 2025-12-06T15:01:56.938Z
8633810 8633810 20251127235717_OVfNT ES001A 2025-11-29T14:20:24.734Z 2025-12-06T15:01:48.792Z
8633583 8633583 20251127233409_rWIf9 ES001A 2025-11-29T14:19:56.112Z 2025-12-06T15:01:45.917Z
8633164 8633164 20251127224816_3ShNS ES001A 2025-11-29T14:19:11.521Z 2025-12-06T15:01:40.736Z
8632726 8632726 20251127214356_2dIO8 ES001A 2025-11-29T14:18:08.041Z 2025-12-06T15:01:32.765Z
8631984 8631984 20251127201738_hIDOx ES001A 2025-11-29T14:16:38.137Z 2025-12-06T15:00:48.802Z
8631723 8631723 20251127195417_X8LO3 ES001A 2025-11-29T14:16:15.660Z 2025-12-06T15:00:38.958Z
8569749 8569749 20251121061232_zmxRW ES001A 2025-11-23T14:32:27.485Z 2025-11-29T14:54:48.945Z
8569706 8569706 20251121061021_liOZ4 ES001A 2025-11-23T14:32:25.314Z 2025-11-29T14:54:48.803Z
8569652 8569652 20251121060551_eMA8E ES001A 2025-11-23T14:32:23.821Z 2025-11-29T14:54:48.668Z
8569253 8569253 20251121055007_kNodH ES001A 2025-11-23T14:32:07.312Z 2025-11-29T14:54:47.972Z
8568212 8568212 20251121050642_Yzp3V ES001A 2025-11-23T14:30:58.688Z 2025-11-29T14:54:46.379Z
8567373 8567373 20251122060921_y9VnR ES001A 2025-11-23T14:19:39.044Z 2025-11-30T15:07:07.583Z
8567369 8567369 20251122060755_8k1Ry ES001A 2025-11-23T14:19:37.800Z 2025-11-30T15:07:07.574Z
8567345 8567345 20251122054821_HLfeK ES001A 2025-11-23T14:19:33.829Z 2025-11-30T15:07:04.795Z
8567320 8567320 20251122053051_IFRYh ES001A 2025-11-23T14:19:30.472Z 2025-11-30T15:07:02.778Z
8567125 8567125 20251122041636_89M0v ES001A 2025-11-23T14:18:58.269Z 2025-11-30T15:06:41.347Z
8566911 8566911 20251122025819_jieh0 ES001A 2025-11-23T14:18:03.855Z 2025-11-30T15:06:16.357Z
8566783 8566783 20251122021930_4xvM3 ES001A 2025-11-23T14:17:31.014Z 2025-11-30T15:06:08.838Z
8566541 8566541 20251122010641_rdVf2 ES001A 2025-11-23T14:16:32.295Z 2025-11-30T15:05:51.531Z
8566539 8566539 20251122010453_5iHND ES001A 2025-11-23T14:16:31.864Z 2025-11-30T15:05:51.509Z
8566390 8566390 20251122002456_OvpzC ES001A 2025-11-23T14:16:02.601Z 2025-11-30T15:05:44.645Z
8566292 8566292 20251121235926_lvc6m ES001A 2025-11-23T14:15:42.244Z 2025-11-30T15:05:41.177Z
8566288 8566288 20251121235722_0d1LN ES001A 2025-11-23T14:15:41.372Z 2025-11-30T15:05:41.101Z
8566280 8566280 20251121235421_uiL1r ES001A 2025-11-23T14:15:39.911Z 2025-11-30T15:05:40.899Z
8566234 8566234 20251121234114_R6haB ES001A 2025-11-23T14:15:33.148Z 2025-11-30T15:05:38.035Z
8565903 8565903 20251121215923_j3GTv ES001A 2025-11-23T14:14:29.521Z 2025-11-30T15:05:15.341Z
8560164 8560164 20251121044413_nxyAF ES001A 2025-11-22T14:42:23.630Z 2025-11-29T14:54:45.149Z
8558924 8558924 20251121034555_YQZKB ES001A 2025-11-22T14:41:25.936Z 2025-11-29T14:54:36.840Z
8558521 8558521 20251121033153_C2ZpA ES001A 2025-11-22T14:41:07.075Z 2025-11-29T14:54:36.227Z
8558271 8558271 20251121032204_1gllQ ES001A 2025-11-22T14:41:02.240Z 2025-11-29T14:54:35.724Z
8557905 8557905 20251121030854_3yY1f ES001A 2025-11-22T14:40:52.889Z 2025-11-29T14:54:34.905Z
8557902 8557902 20251121030839_V5vR4 ES001A 2025-11-22T14:40:52.521Z 2025-11-29T14:54:34.879Z
8557208 8557208 20251121023756_J2LFu ES001A 2025-11-22T14:39:53.751Z 2025-11-29T14:54:33.597Z
8557032 8557032 20251121022931_qiozx ES001A 2025-11-22T14:39:49.933Z 2025-11-29T14:54:33.344Z
8556629 8556629 20251121020445_21M2O ES001A 2025-11-22T14:39:38.620Z 2025-11-29T14:54:32.694Z
8555865 8555865 20251121012806_3Wt9R ES001A 2025-11-22T14:38:53.997Z 2025-11-29T14:54:31.322Z
8555108 8555108 20251121005652_gAd4g ES001A 2025-11-22T14:38:02.190Z 2025-11-29T14:54:30.064Z
8555041 8555041 20251121005325_hJ9r6 ES001A 2025-11-22T14:37:53.922Z 2025-11-29T14:54:29.715Z
8554872 8554872 20251121004218_HS112 ES001A 2025-11-22T14:37:32.106Z 2025-11-29T14:54:29.217Z
8554728 8554728 20251121003631_ewWdM ES001A 2025-11-22T14:37:15.897Z 2025-11-29T14:54:28.736Z
8554720 8554720 20251121003602_ATQfG ES001A 2025-11-22T14:37:12.850Z 2025-11-29T14:54:28.721Z
8551317 8551317 20251121003454_23UeO ES001A 2025-11-22T14:22:24.547Z 2025-11-29T14:54:28.646Z

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