participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,995 rows where station_code = "AU001E" 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 |
---|---|---|---|---|---|
5097130 | 5097130 | 20240912150205_6Eq2j | AU001E | 2024-09-16T12:16:46.126Z | 2024-09-16T12:17:32.042Z |
5097099 | 5097099 | 20240912143751_8ho4E | AU001E | 2024-09-16T12:16:44.982Z | 2024-09-16T12:17:32.033Z |
5097055 | 5097055 | 20240912140758_3hKIE | AU001E | 2024-09-16T12:16:43.682Z | 2024-09-16T12:17:32.015Z |
5097044 | 5097044 | 20240912140159_Wkz32 | AU001E | 2024-09-16T12:16:43.385Z | 2024-09-16T12:17:32.011Z |
5097016 | 5097016 | 20240912134045_PDL3Z | AU001E | 2024-09-16T12:16:42.325Z | 2024-09-16T12:17:31.997Z |
5096994 | 5096994 | 20240912132327_yvRhg | AU001E | 2024-09-16T12:16:41.834Z | 2024-09-16T12:17:31.991Z |
5096976 | 5096976 | 20240912131511_JQ5yD | AU001E | 2024-09-16T12:16:41.099Z | 2024-09-16T12:17:31.986Z |
5096951 | 5096951 | 20240912124659_Wk8ZQ | AU001E | 2024-09-16T12:16:40.130Z | 2024-09-16T12:17:31.975Z |
5096928 | 5096928 | 20240912123055_RZv11 | AU001E | 2024-09-16T12:16:38.315Z | 2024-09-16T12:17:31.967Z |
5096734 | 5096734 | 20240912113533_SfKe3 | AU001E | 2024-09-16T12:16:33.351Z | 2024-09-16T12:17:31.878Z |
5084745 | 5084745 | 20240912200958_KkxrK | AU001E | 2024-09-16T12:02:52.025Z | 2024-09-16T12:17:04.444Z |
5084694 | 5084694 | 20240912200706_xh37U | AU001E | 2024-09-16T12:02:48.874Z | 2024-09-16T12:17:04.427Z |
5084369 | 5084369 | 20240912193032_RcsQs | AU001E | 2024-09-16T12:01:58.707Z | 2024-09-16T12:17:04.273Z |
5084365 | 5084365 | 20240912192958_JEgrI | AU001E | 2024-09-16T12:01:58.001Z | 2024-09-16T12:17:04.270Z |
5084310 | 5084310 | 20240912191713_tNZC5 | AU001E | 2024-09-16T12:01:51.047Z | 2024-09-16T12:17:04.242Z |
5084246 | 5084246 | 20240912190300_lBG0A | AU001E | 2024-09-16T12:01:41.452Z | 2024-09-16T12:17:04.201Z |
5084197 | 5084197 | 20240912185425_x2QKH | AU001E | 2024-09-16T12:01:33.916Z | 2024-09-16T12:17:04.172Z |
5084112 | 5084112 | 20240912181657_vyTVN | AU001E | 2024-09-16T12:01:11.047Z | 2024-09-16T12:17:04.101Z |
5084059 | 5084059 | 20240912175549_hlLRI | AU001E | 2024-09-16T12:01:02.289Z | 2024-09-16T12:17:04.069Z |
5083758 | 5083758 | 20240912151123_NvE91 | AU001E | 2024-09-16T12:00:16.447Z | 2024-09-16T12:17:03.880Z |
5083753 | 5083753 | 20240912150757_39Jq5 | AU001E | 2024-09-16T12:00:15.395Z | 2024-09-16T12:17:03.874Z |
5083332 | 5083332 | 20240911125648_CndFU | AU001E | 2024-09-15T12:18:39.580Z | 2024-09-16T12:19:18.009Z |
5082967 | 5082967 | 20240911113649_1R7iN | AU001E | 2024-09-15T12:18:32.080Z | 2024-09-16T12:19:16.151Z |
5082962 | 5082962 | 20240911113643_dG6Ap | AU001E | 2024-09-15T12:18:31.763Z | 2024-09-16T12:19:16.138Z |
5072874 | 5072874 | 20240911204501_254Sw | AU001E | 2024-09-15T12:06:14.549Z | 2024-09-16T12:17:29.165Z |
5072130 | 5072130 | 20240911194028_SYpqR | AU001E | 2024-09-15T12:04:44.180Z | 2024-09-16T12:17:29.031Z |
5071983 | 5071983 | 20240911191712_v7bLS | AU001E | 2024-09-15T12:04:12.039Z | 2024-09-16T12:17:28.996Z |
5071965 | 5071965 | 20240911191204_uvNFs | AU001E | 2024-09-15T12:04:09.132Z | 2024-09-16T12:17:28.991Z |
5071954 | 5071954 | 20240911191044_vBqVh | AU001E | 2024-09-15T12:04:07.367Z | 2024-09-16T12:17:28.988Z |
5071869 | 5071869 | 20240911184250_DDBNB | AU001E | 2024-09-15T12:03:53.340Z | 2024-09-16T12:17:28.963Z |
5071749 | 5071749 | 20240911181032_2pAMl | AU001E | 2024-09-15T12:03:24.795Z | 2024-09-16T12:17:28.920Z |
5071729 | 5071729 | 20240911180323_IzPRb | AU001E | 2024-09-15T12:03:21.421Z | 2024-09-16T12:17:28.915Z |
5071681 | 5071681 | 20240911174832_suR6O | AU001E | 2024-09-15T12:03:14.116Z | 2024-09-16T12:17:28.895Z |
5071548 | 5071548 | 20240911171509_i94wW | AU001E | 2024-09-15T12:02:53.337Z | 2024-09-16T12:17:28.860Z |
5071491 | 5071491 | 20240911170519_bs1YV | AU001E | 2024-09-15T12:02:40.727Z | 2024-09-16T12:17:28.845Z |
5071451 | 5071451 | 20240911165716_13ALE | AU001E | 2024-09-15T12:02:35.181Z | 2024-09-16T12:17:28.832Z |
5071271 | 5071271 | 20240911162556_dmoFX | AU001E | 2024-09-15T12:02:07.785Z | 2024-09-16T12:17:28.774Z |
5071224 | 5071224 | 20240911161833_Cn3h6 | AU001E | 2024-09-15T12:01:57.583Z | 2024-09-16T12:17:28.761Z |
5071114 | 5071114 | 20240911160134_Jgmj1 | AU001E | 2024-09-15T12:01:43.821Z | 2024-09-16T12:17:28.739Z |
5071085 | 5071085 | 20240911155750_lvhIa | AU001E | 2024-09-15T12:01:37.198Z | 2024-09-16T12:17:28.729Z |
5068927 | 5068927 | 20240910130430_EQ32s | AU001E | 2024-09-14T12:19:22.992Z | 2024-09-16T12:20:15.774Z |
5068809 | 5068809 | 20240910123042_C192z | AU001E | 2024-09-14T12:19:21.682Z | 2024-09-16T12:20:15.362Z |
5068616 | 5068616 | 20240910115554_cZ3Yh | AU001E | 2024-09-14T12:19:19.548Z | 2024-09-16T12:20:14.490Z |
5068226 | 5068226 | 20240910111325_QClN1 | AU001E | 2024-09-14T12:19:11.066Z | 2024-09-16T12:20:13.171Z |
5068142 | 5068142 | 20240910110117_NPiUx | AU001E | 2024-09-14T12:19:09.736Z | 2024-09-16T12:20:12.968Z |
5060890 | 5060890 | 20240909131545_bieD3 | AU001E | 2024-09-14T12:09:53.718Z | 2024-09-16T12:19:28.046Z |
5060751 | 5060751 | 20240910210241_jNm88 | AU001E | 2024-09-14T12:09:29.094Z | 2024-09-16T12:18:18.531Z |
5060188 | 5060188 | 20240910200528_VZBsw | AU001E | 2024-09-14T12:08:28.870Z | 2024-09-16T12:18:13.863Z |
5060057 | 5060057 | 20240910194418_5EMVm | AU001E | 2024-09-14T12:08:06.282Z | 2024-09-16T12:18:12.169Z |
5060008 | 5060008 | 20240910193106_L3IK2 | AU001E | 2024-09-14T12:07:56.980Z | 2024-09-16T12:18:11.391Z |
5059997 | 5059997 | 20240910192821_Chkxj | AU001E | 2024-09-14T12:07:54.837Z | 2024-09-16T12:18:10.695Z |
5059790 | 5059790 | 20240910185332_xr6HN | AU001E | 2024-09-14T12:07:12.507Z | 2024-09-16T12:18:08.447Z |
5059687 | 5059687 | 20240910183222_7hk41 | AU001E | 2024-09-14T12:06:46.096Z | 2024-09-16T12:18:07.663Z |
5059674 | 5059674 | 20240910182903_8ZnnU | AU001E | 2024-09-14T12:06:44.268Z | 2024-09-16T12:18:07.453Z |
5059590 | 5059590 | 20240910181442_PmC53 | AU001E | 2024-09-14T12:06:32.564Z | 2024-09-16T12:18:06.322Z |
5059487 | 5059487 | 20240910175040_273Pc | AU001E | 2024-09-14T12:06:12.882Z | 2024-09-16T12:18:05.339Z |
5059453 | 5059453 | 20240910174552_7ig1s | AU001E | 2024-09-14T12:06:07.998Z | 2024-09-16T12:18:05.056Z |
5059438 | 5059438 | 20240910174230_3MkYo | AU001E | 2024-09-14T12:06:04.361Z | 2024-09-16T12:18:04.968Z |
5059436 | 5059436 | 20240910174217_diePG | AU001E | 2024-09-14T12:06:03.340Z | 2024-09-16T12:18:04.956Z |
5059403 | 5059403 | 20240910173721_CUP15 | AU001E | 2024-09-14T12:05:52.230Z | 2024-09-16T12:18:04.544Z |
5059171 | 5059171 | 20240910171941_Eco38 | AU001E | 2024-09-14T12:05:23.609Z | 2024-09-16T12:18:02.495Z |
5059114 | 5059114 | 20240910171344_b4Ofv | AU001E | 2024-09-14T12:05:15.701Z | 2024-09-16T12:18:01.912Z |
5059071 | 5059071 | 20240910171026_0WOkV | AU001E | 2024-09-14T12:05:11.454Z | 2024-09-16T12:18:01.554Z |
5058965 | 5058965 | 20240910170447_GevAY | AU001E | 2024-09-14T12:05:02.530Z | 2024-09-16T12:18:00.127Z |
5058861 | 5058861 | 20240910165306_71334 | AU001E | 2024-09-14T12:04:40.670Z | 2024-09-16T12:17:59.108Z |
5058585 | 5058585 | 20240910162906_Ebnzg | AU001E | 2024-09-14T12:04:04.008Z | 2024-09-16T12:17:56.286Z |
5058546 | 5058546 | 20240910162303_KxwfD | AU001E | 2024-09-14T12:03:55.569Z | 2024-09-16T12:17:55.904Z |
5057785 | 5057785 | 20240910151322_n0PQ3 | AU001E | 2024-09-14T12:02:01.273Z | 2024-09-16T12:17:47.632Z |
5057760 | 5057760 | 20240910151040_YleBk | AU001E | 2024-09-14T12:01:53.786Z | 2024-09-16T12:17:47.062Z |
5057633 | 5057633 | 20240910145803_xcPJU | AU001E | 2024-09-14T12:01:35.801Z | 2024-09-16T12:17:45.699Z |
5057601 | 5057601 | 20240910145439_UXCs1 | AU001E | 2024-09-14T12:01:30.871Z | 2024-09-16T12:17:45.267Z |
5050039 | 5050039 | 20240909123142_j2l4W | AU001E | 2024-09-13T12:12:37.562Z | 2024-09-16T12:20:45.267Z |
5050029 | 5050029 | 20240909123130_cn3Pz | AU001E | 2024-09-13T12:12:37.217Z | 2024-09-16T12:20:45.260Z |
5050010 | 5050010 | 20240909122154_gyCc4 | AU001E | 2024-09-13T12:12:36.099Z | 2024-09-16T12:20:45.203Z |
5049977 | 5049977 | 20240909121036_gC9ft | AU001E | 2024-09-13T12:12:34.726Z | 2024-09-16T12:20:44.988Z |
5049916 | 5049916 | 20240909115802_j2tAu | AU001E | 2024-09-13T12:12:31.559Z | 2024-09-16T12:20:44.830Z |
5045487 | 5045487 | 20240908171056_JhnO7 | AU001E | 2024-09-13T12:04:14.231Z | 2024-09-16T12:20:25.943Z |
5045475 | 5045475 | 20240908170955_MHEH3 | AU001E | 2024-09-13T12:04:13.037Z | 2024-09-16T12:20:25.928Z |
5044925 | 5044925 | 20240908155630_6Ll38 | AU001E | 2024-09-13T12:03:12.385Z | 2024-09-16T12:20:23.862Z |
5044891 | 5044891 | 20240908155252_AuT2D | AU001E | 2024-09-13T12:03:07.374Z | 2024-09-16T12:20:23.784Z |
5044842 | 5044842 | 20240908154922_s3di5 | AU001E | 2024-09-13T12:03:01.996Z | 2024-09-16T12:20:23.594Z |
5044114 | 5044114 | 20240908141446_ItT32 | AU001E | 2024-09-13T12:01:29.945Z | 2024-09-16T12:20:19.922Z |
5044098 | 5044098 | 20240908141337_3fC06 | AU001E | 2024-09-13T12:01:27.945Z | 2024-09-16T12:20:19.905Z |
5043808 | 5043808 | 20240908131436_ZT20c | AU001E | 2024-09-13T12:00:43.485Z | 2024-09-16T12:20:18.935Z |
5043598 | 5043598 | 20240908121846_EC0q1 | AU001E | 2024-09-13T12:00:11.577Z | 2024-09-16T12:20:18.203Z |
5038647 | 5038647 | 20240905211807_3Y82S | AU001E | 2024-09-12T12:14:52.977Z | 2024-09-14T12:22:57.022Z |
5038604 | 5038604 | 20240905210642_ohB4u | AU001E | 2024-09-12T12:14:50.238Z | 2024-09-14T12:22:56.563Z |
5038592 | 5038592 | 20240905210411_yEA9x | AU001E | 2024-09-12T12:14:49.787Z | 2024-09-14T12:22:56.553Z |
5038570 | 5038570 | 20240905205843_Alrcv | AU001E | 2024-09-12T12:14:48.280Z | 2024-09-14T12:22:56.426Z |
5038567 | 5038567 | 20240905205831_vIOYB | AU001E | 2024-09-12T12:14:48.248Z | 2024-09-14T12:22:56.422Z |
5038556 | 5038556 | 20240905205126_u3UMY | AU001E | 2024-09-12T12:14:47.739Z | 2024-09-14T12:22:56.405Z |
5038464 | 5038464 | 20240905202330_sbQ1A | AU001E | 2024-09-12T12:14:42.642Z | 2024-09-14T12:22:56.169Z |
5038441 | 5038441 | 20240905201557_x7wPT | AU001E | 2024-09-12T12:14:40.608Z | 2024-09-14T12:22:56.106Z |
5038399 | 5038399 | 20240905200047_kIt5e | AU001E | 2024-09-12T12:14:38.203Z | 2024-09-14T12:22:55.940Z |
5038146 | 5038146 | 20240905173122_Vw1yI | AU001E | 2024-09-12T12:14:24.279Z | 2024-09-14T12:22:55.224Z |
5037781 | 5037781 | 20240905165134_axnaw | AU001E | 2024-09-12T12:14:15.411Z | 2024-09-14T12:22:54.625Z |
5037756 | 5037756 | 20240905164659_iZPYG | AU001E | 2024-09-12T12:14:14.952Z | 2024-09-14T12:22:54.565Z |
5037613 | 5037613 | 20240905162240_33cio | AU001E | 2024-09-12T12:14:11.649Z | 2024-09-14T12:22:54.443Z |
5037600 | 5037600 | 20240905162020_vFGEe | AU001E | 2024-09-12T12:14:11.015Z | 2024-09-14T12:22:54.434Z |
5037569 | 5037569 | 20240905161008_2eH9b | AU001E | 2024-09-12T12:14:09.458Z | 2024-09-14T12:22:54.306Z |
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);