participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
635 rows where station_code = "GR0008" sorted by created_at descending
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 |
---|---|---|---|---|---|
5565495 | 5565495 | 20241119000021_FfOgw | GR0008 | 2024-11-21T14:20:29.631Z | 2024-11-22T14:22:18.709Z |
5565069 | 5565069 | 20241120034921_hK42O | GR0008 | 2024-11-21T14:18:27.854Z | 2024-11-22T14:21:40.876Z |
5564972 | 5564972 | 20241120034320_JrZ2i | GR0008 | 2024-11-21T14:18:17.023Z | 2024-11-22T14:21:40.010Z |
5561185 | 5561185 | 20241119185407_UbX9V | GR0008 | 2024-11-21T14:12:34.073Z | 2024-11-22T14:20:24.768Z |
5557144 | 5557144 | 20241119040951_VaD57 | GR0008 | 2024-11-20T14:12:21.758Z | 2024-11-22T14:22:22.488Z |
5557048 | 5557048 | 20241119033115_WiwMH | GR0008 | 2024-11-20T14:12:04.373Z | 2024-11-22T14:22:21.894Z |
5557043 | 5557043 | 20241119033053_n83nl | GR0008 | 2024-11-20T14:12:03.755Z | 2024-11-22T14:22:21.886Z |
5557039 | 5557039 | 20241119033018_m5PdM | GR0008 | 2024-11-20T14:12:03.411Z | 2024-11-22T14:22:21.861Z |
5556994 | 5556994 | 20241119031709_4Wnd3 | GR0008 | 2024-11-20T14:11:55.751Z | 2024-11-22T14:22:21.505Z |
5556868 | 5556868 | 20241119022208_ESyj4 | GR0008 | 2024-11-20T14:11:35.375Z | 2024-11-22T14:22:20.510Z |
5556866 | 5556866 | 20241119022143_TCbo7 | GR0008 | 2024-11-20T14:11:35.060Z | 2024-11-22T14:22:20.461Z |
5556817 | 5556817 | 20241119020226_lG8GU | GR0008 | 2024-11-20T14:11:30.895Z | 2024-11-22T14:22:20.194Z |
5556798 | 5556798 | 20241119015549_HLUjD | GR0008 | 2024-11-20T14:11:29.186Z | 2024-11-22T14:22:20.030Z |
5556723 | 5556723 | 20241119013055_Opiaw | GR0008 | 2024-11-20T14:11:22.102Z | 2024-11-22T14:22:19.460Z |
5556716 | 5556716 | 20241119012902_1lpZ3 | GR0008 | 2024-11-20T14:11:21.158Z | 2024-11-22T14:22:19.403Z |
5556714 | 5556714 | 20241119012823_Zyr9U | GR0008 | 2024-11-20T14:11:20.918Z | 2024-11-22T14:22:19.374Z |
5556711 | 5556711 | 20241119012555_hIeF3 | GR0008 | 2024-11-20T14:11:20.815Z | 2024-11-22T14:22:19.373Z |
5556688 | 5556688 | 20241119010532_Y0g57 | GR0008 | 2024-11-20T14:11:18.079Z | 2024-11-22T14:22:19.286Z |
5556639 | 5556639 | 20241119003336_igilg | GR0008 | 2024-11-20T14:11:01.891Z | 2024-11-22T14:22:18.945Z |
5556588 | 5556588 | 20241118234420_UJ6Ds | GR0008 | 2024-11-20T14:10:47.578Z | 2024-11-22T14:22:18.568Z |
5556584 | 5556584 | 20241118234409_eXvji | GR0008 | 2024-11-20T14:10:47.483Z | 2024-11-22T14:22:18.554Z |
5556377 | 5556377 | 20241118202007_OxqDj | GR0008 | 2024-11-20T14:10:15.730Z | 2024-11-22T14:22:16.595Z |
5556292 | 5556292 | 20241118175847_73b3l | GR0008 | 2024-11-20T14:09:48.089Z | 2024-11-22T14:22:14.646Z |
5556283 | 5556283 | 20241118173728_1D9FY | GR0008 | 2024-11-20T14:09:46.115Z | 2024-11-22T14:22:14.411Z |
5553046 | 5553046 | 20241118002841_8TuAd | GR0008 | 2024-11-19T14:09:58.904Z | 2024-11-22T14:22:49.992Z |
5552479 | 5552479 | 20241117165719_4uTNG | GR0008 | 2024-11-19T14:08:07.063Z | 2024-11-22T14:22:40.114Z |
5517531 | 5517531 | 20241110035822_KpAj1 | GR0008 | 2024-11-11T14:14:32.998Z | 2024-11-18T14:26:37.000Z |
5517338 | 5517338 | 20241110032751_1Bbqs | GR0008 | 2024-11-11T14:14:16.572Z | 2024-11-18T14:26:35.994Z |
5517336 | 5517336 | 20241110032729_cTSRi | GR0008 | 2024-11-11T14:14:16.385Z | 2024-11-18T14:26:35.993Z |
5517314 | 5517314 | 20241110032226_bDKpW | GR0008 | 2024-11-11T14:14:13.671Z | 2024-11-18T14:26:35.838Z |
5517177 | 5517177 | 20241110025930_Ks3YD | GR0008 | 2024-11-11T14:14:01.653Z | 2024-11-18T14:26:35.114Z |
5517128 | 5517128 | 20241110025054_z2KC2 | GR0008 | 2024-11-11T14:13:57.091Z | 2024-11-18T14:26:34.809Z |
5516955 | 5516955 | 20241110022609_rnfJc | GR0008 | 2024-11-11T14:13:37.171Z | 2024-11-18T14:26:33.995Z |
5516918 | 5516918 | 20241110022002_jwEHQ | GR0008 | 2024-11-11T14:13:32.801Z | 2024-11-18T14:26:33.806Z |
5516909 | 5516909 | 20241110021835_qeJcx | GR0008 | 2024-11-11T14:13:31.558Z | 2024-11-18T14:26:33.739Z |
5516813 | 5516813 | 20241110020631_Y3sG0 | GR0008 | 2024-11-11T14:13:24.231Z | 2024-11-18T14:26:33.445Z |
5516797 | 5516797 | 20241110020432_7sGgq | GR0008 | 2024-11-11T14:13:23.041Z | 2024-11-18T14:26:33.347Z |
5516751 | 5516751 | 20241110015436_Y7cTi | GR0008 | 2024-11-11T14:13:18.253Z | 2024-11-18T14:26:33.147Z |
5516742 | 5516742 | 20241110015258_zcxHr | GR0008 | 2024-11-11T14:13:17.839Z | 2024-11-18T14:26:33.090Z |
5516707 | 5516707 | 20241110014641_EAX2N | GR0008 | 2024-11-11T14:13:16.100Z | 2024-11-18T14:26:32.897Z |
5516570 | 5516570 | 20241110012318_x5obS | GR0008 | 2024-11-11T14:13:09.277Z | 2024-11-18T14:26:32.075Z |
5516452 | 5516452 | 20241110010246_4HlyT | GR0008 | 2024-11-11T14:13:01.833Z | 2024-11-18T14:26:31.255Z |
5516438 | 5516438 | 20241110005934_xqAM1 | GR0008 | 2024-11-11T14:13:01.264Z | 2024-11-18T14:26:31.229Z |
5516312 | 5516312 | 20241110003719_PWrj7 | GR0008 | 2024-11-11T14:12:43.346Z | 2024-11-18T14:26:30.633Z |
5516263 | 5516263 | 20241110002511_0GsYX | GR0008 | 2024-11-11T14:12:36.810Z | 2024-11-18T14:26:30.368Z |
5516261 | 5516261 | 20241110002420_mUgNt | GR0008 | 2024-11-11T14:12:36.393Z | 2024-11-18T14:26:30.365Z |
5516184 | 5516184 | 20241110000945_u8UEE | GR0008 | 2024-11-11T14:12:23.407Z | 2024-11-18T14:26:29.993Z |
5516005 | 5516005 | 20241109233137_W2GzK | GR0008 | 2024-11-11T14:11:56.930Z | 2024-11-18T14:26:28.891Z |
5515968 | 5515968 | 20241109232051_4pQat | GR0008 | 2024-11-11T14:11:51.476Z | 2024-11-18T14:26:28.693Z |
5515934 | 5515934 | 20241109231455_f0Gov | GR0008 | 2024-11-11T14:11:48.099Z | 2024-11-18T14:26:28.537Z |
5515910 | 5515910 | 20241109231123_M1j5F | GR0008 | 2024-11-11T14:11:46.242Z | 2024-11-18T14:26:28.422Z |
5515827 | 5515827 | 20241109225250_Q4R7f | GR0008 | 2024-11-11T14:11:33.727Z | 2024-11-18T14:26:28.124Z |
5515786 | 5515786 | 20241109224357_e3c3J | GR0008 | 2024-11-11T14:11:28.249Z | 2024-11-18T14:26:27.958Z |
5515676 | 5515676 | 20241109222126_Hh4Sr | GR0008 | 2024-11-11T14:11:21.048Z | 2024-11-18T14:26:27.361Z |
5515540 | 5515540 | 20241109215332_b7chw | GR0008 | 2024-11-11T14:11:11.947Z | 2024-11-18T14:26:26.648Z |
5515474 | 5515474 | 20241109213209_o6Az2 | GR0008 | 2024-11-11T14:11:06.979Z | 2024-11-18T14:26:26.187Z |
5515456 | 5515456 | 20241109212707_IYdMh | GR0008 | 2024-11-11T14:11:05.990Z | 2024-11-18T14:26:26.115Z |
5515355 | 5515355 | 20241109204947_lOMfL | GR0008 | 2024-11-11T14:10:49.694Z | 2024-11-18T14:26:25.671Z |
5515205 | 5515205 | 20241109195240_ClkOr | GR0008 | 2024-11-11T14:10:19.995Z | 2024-11-18T14:26:24.913Z |
5515104 | 5515104 | 20241109192413_9pTtj | GR0008 | 2024-11-11T14:10:05.055Z | 2024-11-18T14:26:24.307Z |
5515015 | 5515015 | 20241109190005_ICN5x | GR0008 | 2024-11-11T14:09:53.734Z | 2024-11-18T14:26:23.823Z |
5515000 | 5515000 | 20241109185517_2nmrP | GR0008 | 2024-11-11T14:09:52.500Z | 2024-11-18T14:26:23.744Z |
5514876 | 5514876 | 20241109181226_V2zE3 | GR0008 | 2024-11-11T14:09:39.212Z | 2024-11-18T14:26:23.032Z |
5514824 | 5514824 | 20241109174637_icO85 | GR0008 | 2024-11-11T14:09:21.968Z | 2024-11-18T14:26:22.680Z |
5511017 | 5511017 | 20241109040809_hTaTU | GR0008 | 2024-11-10T14:16:04.405Z | 2024-11-17T14:24:03.433Z |
5510916 | 5510916 | 20241109035436_tfUEe | GR0008 | 2024-11-10T14:15:54.512Z | 2024-11-17T14:24:02.545Z |
5510885 | 5510885 | 20241109034816_FKILa | GR0008 | 2024-11-10T14:15:50.350Z | 2024-11-17T14:24:02.198Z |
5510883 | 5510883 | 20241109034811_tt67j | GR0008 | 2024-11-10T14:15:49.501Z | 2024-11-17T14:24:02.153Z |
5510702 | 5510702 | 20241109032749_UBCYA | GR0008 | 2024-11-10T14:15:34.959Z | 2024-11-17T14:24:00.553Z |
5510640 | 5510640 | 20241109031756_lMvQa | GR0008 | 2024-11-10T14:15:31.066Z | 2024-11-17T14:23:59.894Z |
5510631 | 5510631 | 20241109031632_8RZFQ | GR0008 | 2024-11-10T14:15:30.499Z | 2024-11-17T14:23:59.862Z |
5510531 | 5510531 | 20241109025518_P0Hd8 | GR0008 | 2024-11-10T14:15:25.016Z | 2024-11-17T14:23:58.728Z |
5510526 | 5510526 | 20241109025359_kKrXm | GR0008 | 2024-11-10T14:15:24.663Z | 2024-11-17T14:23:58.559Z |
5510479 | 5510479 | 20241109024552_8LRIN | GR0008 | 2024-11-10T14:15:20.158Z | 2024-11-17T14:23:58.147Z |
5510458 | 5510458 | 20241109024322_0hS2t | GR0008 | 2024-11-10T14:15:17.339Z | 2024-11-17T14:23:57.935Z |
5510181 | 5510181 | 20241109015551_wSB8j | GR0008 | 2024-11-10T14:14:45.331Z | 2024-11-17T14:23:53.746Z |
5510134 | 5510134 | 20241109014724_TWuL9 | GR0008 | 2024-11-10T14:14:38.700Z | 2024-11-17T14:23:53.168Z |
5510030 | 5510030 | 20241109013025_EW3U1 | GR0008 | 2024-11-10T14:14:28.726Z | 2024-11-17T14:23:52.234Z |
5510024 | 5510024 | 20241109012944_yRzLA | GR0008 | 2024-11-10T14:14:27.904Z | 2024-11-17T14:23:52.048Z |
5509899 | 5509899 | 20241109010535_yMG49 | GR0008 | 2024-11-10T14:14:11.734Z | 2024-11-17T14:23:50.508Z |
5509858 | 5509858 | 20241109005449_rsbzG | GR0008 | 2024-11-10T14:14:07.380Z | 2024-11-17T14:23:50.059Z |
5509850 | 5509850 | 20241109005023_ufyAq | GR0008 | 2024-11-10T14:14:06.940Z | 2024-11-17T14:23:50.029Z |
5509837 | 5509837 | 20241109004818_455gE | GR0008 | 2024-11-10T14:14:05.483Z | 2024-11-17T14:23:49.684Z |
5509810 | 5509810 | 20241109004425_pOMSg | GR0008 | 2024-11-10T14:14:02.719Z | 2024-11-17T14:23:49.472Z |
5509766 | 5509766 | 20241109003010_hqgOE | GR0008 | 2024-11-10T14:13:58.280Z | 2024-11-17T14:23:48.959Z |
5509760 | 5509760 | 20241109002939_WC86p | GR0008 | 2024-11-10T14:13:57.662Z | 2024-11-17T14:23:48.834Z |
5509736 | 5509736 | 20241109002523_h7cJh | GR0008 | 2024-11-10T14:13:55.051Z | 2024-11-17T14:23:48.627Z |
5509734 | 5509734 | 20241109002518_KOdeD | GR0008 | 2024-11-10T14:13:55.036Z | 2024-11-17T14:23:48.625Z |
5509726 | 5509726 | 20241109002322_uBBwd | GR0008 | 2024-11-10T14:13:54.482Z | 2024-11-17T14:23:48.589Z |
5509712 | 5509712 | 20241109001657_erSr2 | GR0008 | 2024-11-10T14:13:53.147Z | 2024-11-17T14:23:48.495Z |
5509690 | 5509690 | 20241109001102_P7eY1 | GR0008 | 2024-11-10T14:13:51.398Z | 2024-11-17T14:23:48.279Z |
5509603 | 5509603 | 20241108235320_zk06g | GR0008 | 2024-11-10T14:13:39.197Z | 2024-11-17T14:23:47.744Z |
5509572 | 5509572 | 20241108234742_DthEW | GR0008 | 2024-11-10T14:13:36.070Z | 2024-11-17T14:23:46.957Z |
5509454 | 5509454 | 20241108231942_tvPsi | GR0008 | 2024-11-10T14:13:24.285Z | 2024-11-17T14:23:44.598Z |
5509450 | 5509450 | 20241108231941_RQsVe | GR0008 | 2024-11-10T14:13:24.256Z | 2024-11-17T14:23:44.597Z |
5509185 | 5509185 | 20241108221613_aLRJ8 | GR0008 | 2024-11-10T14:12:49.864Z | 2024-11-17T14:23:41.220Z |
5509108 | 5509108 | 20241108215230_XQRXJ | GR0008 | 2024-11-10T14:12:34.006Z | 2024-11-17T14:23:40.319Z |
5509105 | 5509105 | 20241108215228_55Z6g | GR0008 | 2024-11-10T14:12:33.874Z | 2024-11-17T14:23:40.315Z |
5509056 | 5509056 | 20241108213604_fLUDc | GR0008 | 2024-11-10T14:12:25.681Z | 2024-11-17T14:23:39.832Z |
5509046 | 5509046 | 20241108213410_y6EV2 | GR0008 | 2024-11-10T14:12:24.513Z | 2024-11-17T14:23:39.753Z |
Advanced export
JSON shape: default, array, newline-delimited
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);