participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,595 rows where station_code = "AU000A" 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 |
---|---|---|---|---|---|
5097118 | 5097118 | 20240912144441_yCVmT | AU000A | 2024-09-16T12:16:45.641Z | 2024-09-16T12:17:32.039Z |
5097047 | 5097047 | 20240912140355_bP6dP | AU000A | 2024-09-16T12:16:43.541Z | 2024-09-16T12:17:32.012Z |
5097020 | 5097020 | 20240912134612_bv2Ci | AU000A | 2024-09-16T12:16:42.492Z | 2024-09-16T12:17:32.000Z |
5097018 | 5097018 | 20240912134342_6QPeE | AU000A | 2024-09-16T12:16:42.389Z | 2024-09-16T12:17:31.999Z |
5096981 | 5096981 | 20240912132218_jV61T | AU000A | 2024-09-16T12:16:41.477Z | 2024-09-16T12:17:31.988Z |
5096676 | 5096676 | 20240912112947_o1835 | AU000A | 2024-09-16T12:16:31.422Z | 2024-09-16T12:17:31.849Z |
5085310 | 5085310 | 20240912210731_X9IBG | AU000A | 2024-09-16T12:03:56.485Z | 2024-09-16T12:17:04.682Z |
5085248 | 5085248 | 20240912210414_Apyyu | AU000A | 2024-09-16T12:03:47.931Z | 2024-09-16T12:17:04.666Z |
5085240 | 5085240 | 20240912210225_qfvmI | AU000A | 2024-09-16T12:03:47.073Z | 2024-09-16T12:17:04.662Z |
5085203 | 5085203 | 20240912205852_yom3C | AU000A | 2024-09-16T12:03:43.157Z | 2024-09-16T12:17:04.644Z |
5085118 | 5085118 | 20240912204809_3ydGV | AU000A | 2024-09-16T12:03:34.085Z | 2024-09-16T12:17:04.596Z |
5085003 | 5085003 | 20240912203927_f0N83 | AU000A | 2024-09-16T12:03:25.080Z | 2024-09-16T12:17:04.551Z |
5084876 | 5084876 | 20240912202918_H9jMP | AU000A | 2024-09-16T12:03:07.940Z | 2024-09-16T12:17:04.508Z |
5084873 | 5084873 | 20240912202911_L32D2 | AU000A | 2024-09-16T12:03:07.532Z | 2024-09-16T12:17:04.507Z |
5084813 | 5084813 | 20240912201638_qzsxK | AU000A | 2024-09-16T12:02:57.010Z | 2024-09-16T12:17:04.467Z |
5084619 | 5084619 | 20240912195721_S4Zs4 | AU000A | 2024-09-16T12:02:39.615Z | 2024-09-16T12:17:04.392Z |
5084460 | 5084460 | 20240912194028_9GuSc | AU000A | 2024-09-16T12:02:06.349Z | 2024-09-16T12:17:04.315Z |
5084358 | 5084358 | 20240912192726_IedtR | AU000A | 2024-09-16T12:01:57.019Z | 2024-09-16T12:17:04.265Z |
5084048 | 5084048 | 20240912175329_Kq3rM | AU000A | 2024-09-16T12:01:00.393Z | 2024-09-16T12:17:04.061Z |
5084034 | 5084034 | 20240912174216_O7Fo2 | AU000A | 2024-09-16T12:00:58.521Z | 2024-09-16T12:17:04.054Z |
5083970 | 5083970 | 20240912171204_3y4tA | AU000A | 2024-09-16T12:00:45.146Z | 2024-09-16T12:17:04.008Z |
5083967 | 5083967 | 20240912171152_hDL7x | AU000A | 2024-09-16T12:00:44.843Z | 2024-09-16T12:17:04.006Z |
5083964 | 5083964 | 20240912171151_37O7r | AU000A | 2024-09-16T12:00:44.482Z | 2024-09-16T12:17:04.005Z |
5083835 | 5083835 | 20240912160954_BAouD | AU000A | 2024-09-16T12:00:29.192Z | 2024-09-16T12:17:03.934Z |
5083827 | 5083827 | 20240912160359_r3fYX | AU000A | 2024-09-16T12:00:27.684Z | 2024-09-16T12:17:03.930Z |
5083820 | 5083820 | 20240912155944_xlhlW | AU000A | 2024-09-16T12:00:27.029Z | 2024-09-16T12:17:03.927Z |
5083813 | 5083813 | 20240912155424_liNvU | AU000A | 2024-09-16T12:00:26.229Z | 2024-09-16T12:17:03.923Z |
5083398 | 5083398 | 20240911130856_0KLhs | AU000A | 2024-09-15T12:18:40.755Z | 2024-09-16T12:19:18.163Z |
5082896 | 5082896 | 20240911112345_pv7GV | AU000A | 2024-09-15T12:18:29.295Z | 2024-09-16T12:19:15.610Z |
5072989 | 5072989 | 20240911205133_XeGXg | AU000A | 2024-09-15T12:06:25.213Z | 2024-09-16T12:17:29.182Z |
5072876 | 5072876 | 20240911204503_tiA3r | AU000A | 2024-09-15T12:06:14.893Z | 2024-09-16T12:17:29.165Z |
5072688 | 5072688 | 20240911203709_g6z5a | AU000A | 2024-09-15T12:06:01.512Z | 2024-09-16T12:17:29.137Z |
5072445 | 5072445 | 20240911201014_KCKIr | AU000A | 2024-09-15T12:05:23.948Z | 2024-09-16T12:17:29.087Z |
5072168 | 5072168 | 20240911194308_2MSRa | AU000A | 2024-09-15T12:04:47.667Z | 2024-09-16T12:17:29.037Z |
5072038 | 5072038 | 20240911192542_8Hx4D | AU000A | 2024-09-15T12:04:30.291Z | 2024-09-16T12:17:29.009Z |
5072022 | 5072022 | 20240911192356_5JVro | AU000A | 2024-09-15T12:04:24.568Z | 2024-09-16T12:17:29.007Z |
5072004 | 5072004 | 20240911192015_Ew7FI | AU000A | 2024-09-15T12:04:17.681Z | 2024-09-16T12:17:29.001Z |
5071917 | 5071917 | 20240911190245_81KPK | AU000A | 2024-09-15T12:04:01.165Z | 2024-09-16T12:17:28.978Z |
5071617 | 5071617 | 20240911172957_Xm4be | AU000A | 2024-09-15T12:03:05.375Z | 2024-09-16T12:17:28.878Z |
5071546 | 5071546 | 20240911171421_OqBAB | AU000A | 2024-09-15T12:02:52.942Z | 2024-09-16T12:17:28.859Z |
5071512 | 5071512 | 20240911171016_7piOx | AU000A | 2024-09-15T12:02:45.870Z | 2024-09-16T12:17:28.851Z |
5071509 | 5071509 | 20240911170945_A9HWi | AU000A | 2024-09-15T12:02:44.869Z | 2024-09-16T12:17:28.850Z |
5071395 | 5071395 | 20240911164556_yZ7Nj | AU000A | 2024-09-15T12:02:27.190Z | 2024-09-16T12:17:28.801Z |
5071391 | 5071391 | 20240911164529_E2Iwb | AU000A | 2024-09-15T12:02:26.678Z | 2024-09-16T12:17:28.800Z |
5071389 | 5071389 | 20240911164513_ZhDFB | AU000A | 2024-09-15T12:02:26.278Z | 2024-09-16T12:17:28.799Z |
5071385 | 5071385 | 20240911164507_P7KLz | AU000A | 2024-09-15T12:02:25.855Z | 2024-09-16T12:17:28.798Z |
5071116 | 5071116 | 20240911160142_fjFHX | AU000A | 2024-09-15T12:01:44.320Z | 2024-09-16T12:17:28.740Z |
5070986 | 5070986 | 20240911153904_23PzJ | AU000A | 2024-09-15T12:01:18.750Z | 2024-09-16T12:17:28.707Z |
5070718 | 5070718 | 20240911150031_3taTY | AU000A | 2024-09-15T12:00:41.916Z | 2024-09-16T12:17:28.653Z |
5069033 | 5069033 | 20240910132601_mOlN0 | AU000A | 2024-09-14T12:19:24.291Z | 2024-09-16T12:20:16.209Z |
5068592 | 5068592 | 20240910115255_5Ht3j | AU000A | 2024-09-14T12:19:18.969Z | 2024-09-16T12:20:14.424Z |
5068159 | 5068159 | 20240910110524_oir3y | AU000A | 2024-09-14T12:19:10.140Z | 2024-09-16T12:20:13.026Z |
5062815 | 5062815 | 20240909183140_5Xm2k | AU000A | 2024-09-14T12:12:53.976Z | 2024-09-16T12:19:39.654Z |
5062727 | 5062727 | 20240909180743_l6Fzi | AU000A | 2024-09-14T12:12:45.711Z | 2024-09-16T12:19:39.133Z |
5062645 | 5062645 | 20240909175418_bzFBw | AU000A | 2024-09-14T12:12:40.351Z | 2024-09-16T12:19:38.292Z |
5062492 | 5062492 | 20240909173318_69OmM | AU000A | 2024-09-14T12:12:27.887Z | 2024-09-16T12:19:37.552Z |
5061520 | 5061520 | 20240909151920_1Y90n | AU000A | 2024-09-14T12:10:55.194Z | 2024-09-16T12:19:32.036Z |
5061388 | 5061388 | 20240909150051_c6GeH | AU000A | 2024-09-14T12:10:45.984Z | 2024-09-16T12:19:31.308Z |
5061339 | 5061339 | 20240909145010_KGzJx | AU000A | 2024-09-14T12:10:43.185Z | 2024-09-16T12:19:30.611Z |
5061192 | 5061192 | 20240909143027_BR17b | AU000A | 2024-09-14T12:10:33.655Z | 2024-09-16T12:19:29.720Z |
5061189 | 5061189 | 20240909142849_mQxCD | AU000A | 2024-09-14T12:10:32.892Z | 2024-09-16T12:19:29.719Z |
5061023 | 5061023 | 20240909135338_2QIZI | AU000A | 2024-09-14T12:10:06.689Z | 2024-09-16T12:19:28.668Z |
5060817 | 5060817 | 20240910211449_hfQSr | AU000A | 2024-09-14T12:09:36.764Z | 2024-09-16T12:18:19.671Z |
5060658 | 5060658 | 20240910204959_OgPXH | AU000A | 2024-09-14T12:09:19.061Z | 2024-09-16T12:18:17.321Z |
5060617 | 5060617 | 20240910204329_oGtLG | AU000A | 2024-09-14T12:09:13.116Z | 2024-09-16T12:18:16.775Z |
5059713 | 5059713 | 20240910183503_3KeTu | AU000A | 2024-09-14T12:06:50.544Z | 2024-09-16T12:18:07.812Z |
5059698 | 5059698 | 20240910183342_ojwup | AU000A | 2024-09-14T12:06:47.533Z | 2024-09-16T12:18:07.712Z |
5059595 | 5059595 | 20240910181519_KFfTc | AU000A | 2024-09-14T12:06:33.551Z | 2024-09-16T12:18:06.438Z |
5059379 | 5059379 | 20240910173528_OLilH | AU000A | 2024-09-14T12:05:49.688Z | 2024-09-16T12:18:04.273Z |
5059156 | 5059156 | 20240910171757_rFR2F | AU000A | 2024-09-14T12:05:20.421Z | 2024-09-16T12:18:02.268Z |
5059033 | 5059033 | 20240910170832_tbf6S | AU000A | 2024-09-14T12:05:07.743Z | 2024-09-16T12:18:01.200Z |
5058882 | 5058882 | 20240910165418_o0Tnz | AU000A | 2024-09-14T12:04:44.589Z | 2024-09-16T12:17:59.419Z |
5058866 | 5058866 | 20240910165307_wzswH | AU000A | 2024-09-14T12:04:41.666Z | 2024-09-16T12:17:59.225Z |
5058720 | 5058720 | 20240910163950_nenaI | AU000A | 2024-09-14T12:04:23.723Z | 2024-09-16T12:17:57.368Z |
5058451 | 5058451 | 20240910161314_qEyaP | AU000A | 2024-09-14T12:03:43.680Z | 2024-09-16T12:17:54.773Z |
5057527 | 5057527 | 20240910144106_8o2ax | AU000A | 2024-09-14T12:01:19.636Z | 2024-09-16T12:17:44.762Z |
5057241 | 5057241 | 20240910140402_PUgh5 | AU000A | 2024-09-14T12:00:37.922Z | 2024-09-16T12:17:41.658Z |
5056730 | 5056730 | 20240908111421_a4D98 | AU000A | 2024-09-13T12:17:38.573Z | 2024-09-16T12:21:26.915Z |
5056723 | 5056723 | 20240908111256_Kftd6 | AU000A | 2024-09-13T12:17:38.459Z | 2024-09-16T12:21:26.844Z |
5052579 | 5052579 | 20240907210850_2BaDr | AU000A | 2024-09-13T12:15:14.504Z | 2024-09-16T12:21:06.499Z |
5052509 | 5052509 | 20240907205721_WBavX | AU000A | 2024-09-13T12:15:12.140Z | 2024-09-16T12:21:06.028Z |
5052485 | 5052485 | 20240907205328_naY8H | AU000A | 2024-09-13T12:15:11.366Z | 2024-09-16T12:21:05.948Z |
5052318 | 5052318 | 20240907201824_muZ5e | AU000A | 2024-09-13T12:15:04.050Z | 2024-09-16T12:21:05.112Z |
5052207 | 5052207 | 20240907195912_VqKDX | AU000A | 2024-09-13T12:15:00.144Z | 2024-09-16T12:21:04.554Z |
5051645 | 5051645 | 20240907180333_8LXMc | AU000A | 2024-09-13T12:14:26.667Z | 2024-09-16T12:21:01.463Z |
5050164 | 5050164 | 20240907144225_IO0rn | AU000A | 2024-09-13T12:13:13.590Z | 2024-09-16T12:20:56.570Z |
5049808 | 5049808 | 20240909114457_EC7jf | AU000A | 2024-09-13T12:12:27.627Z | 2024-09-16T12:20:44.375Z |
5044065 | 5044065 | 20240908140949_XSj8F | AU000A | 2024-09-13T12:01:23.979Z | 2024-09-16T12:20:19.850Z |
5043975 | 5043975 | 20240908134236_neP34 | AU000A | 2024-09-13T12:01:07.267Z | 2024-09-16T12:20:19.577Z |
5043963 | 5043963 | 20240908134155_Ueoav | AU000A | 2024-09-13T12:01:04.199Z | 2024-09-16T12:20:19.569Z |
5043931 | 5043931 | 20240908133758_J8j2F | AU000A | 2024-09-13T12:01:00.389Z | 2024-09-16T12:20:19.534Z |
5043714 | 5043714 | 20240908125027_gu57A | AU000A | 2024-09-13T12:00:29.580Z | 2024-09-16T12:20:18.692Z |
5043689 | 5043689 | 20240908124052_XAFf5 | AU000A | 2024-09-13T12:00:24.816Z | 2024-09-16T12:20:18.522Z |
5042838 | 5042838 | 20240907125723_gEk6A | AU000A | 2024-09-12T12:17:18.809Z | 2024-09-16T12:20:54.585Z |
5042705 | 5042705 | 20240907122733_u3MVn | AU000A | 2024-09-12T12:17:16.950Z | 2024-09-16T12:20:53.962Z |
5042597 | 5042597 | 20240907120638_y3RlB | AU000A | 2024-09-12T12:17:15.600Z | 2024-09-16T12:20:53.685Z |
5042530 | 5042530 | 20240907115552_Y28jX | AU000A | 2024-09-12T12:17:14.564Z | 2024-09-16T12:20:53.495Z |
5038388 | 5038388 | 20240905195309_ozo4a | AU000A | 2024-09-12T12:14:37.543Z | 2024-09-14T12:22:55.923Z |
5038377 | 5038377 | 20240905195104_G8Yex | AU000A | 2024-09-12T12:14:36.336Z | 2024-09-14T12:22:55.835Z |
5038144 | 5038144 | 20240905173039_tsRRA | AU000A | 2024-09-12T12:14:24.200Z | 2024-09-14T12:22:55.221Z |
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);