participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,698 rows where station_code = "NZ002S" 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 |
---|---|---|---|---|---|
5569531 | 5569531 | 20241121155912_ytPH4 | NZ002S | 2024-11-22T14:11:02.558Z | 2024-11-22T14:11:02.558Z |
5569442 | 5569442 | 20241121153215_BGTrZ | NZ002S | 2024-11-22T14:10:53.613Z | 2024-11-22T14:10:53.613Z |
5569295 | 5569295 | 20241121150651_qts2m | NZ002S | 2024-11-22T14:10:44.247Z | 2024-11-22T14:10:44.247Z |
5569270 | 5569270 | 20241121150353_T3ogZ | NZ002S | 2024-11-22T14:10:43.379Z | 2024-11-22T14:10:43.379Z |
5569245 | 5569245 | 20241121145929_XfNTQ | NZ002S | 2024-11-22T14:10:41.538Z | 2024-11-22T14:10:41.538Z |
5569223 | 5569223 | 20241121145359_enwWs | NZ002S | 2024-11-22T14:10:40.346Z | 2024-11-22T14:10:40.346Z |
5569211 | 5569211 | 20241121145324_OKKIX | NZ002S | 2024-11-22T14:10:38.561Z | 2024-11-22T14:10:38.561Z |
5569097 | 5569097 | 20241121143507_kUola | NZ002S | 2024-11-22T14:10:20.733Z | 2024-11-22T14:10:20.733Z |
5569058 | 5569058 | 20241121142516_KeKkO | NZ002S | 2024-11-22T14:10:15.820Z | 2024-11-22T14:10:15.820Z |
5568996 | 5568996 | 20241121141415_NBYT3 | NZ002S | 2024-11-22T14:10:09.780Z | 2024-11-22T14:10:09.780Z |
5568971 | 5568971 | 20241121141206_3nfpg | NZ002S | 2024-11-22T14:10:07.984Z | 2024-11-22T14:10:07.984Z |
5568803 | 5568803 | 20241121134151_kwFKt | NZ002S | 2024-11-22T14:09:46.552Z | 2024-11-22T14:09:46.552Z |
5568792 | 5568792 | 20241121133723_IVMR2 | NZ002S | 2024-11-22T14:09:43.073Z | 2024-11-22T14:09:43.073Z |
5568741 | 5568741 | 20241121132931_xwb17 | NZ002S | 2024-11-22T14:09:39.255Z | 2024-11-22T14:09:39.255Z |
5568715 | 5568715 | 20241121132644_aaRQg | NZ002S | 2024-11-22T14:09:36.261Z | 2024-11-22T14:09:36.261Z |
5568635 | 5568635 | 20241121131648_HwXzU | NZ002S | 2024-11-22T14:09:28.247Z | 2024-11-22T14:09:28.247Z |
5568604 | 5568604 | 20241121131041_uHFhH | NZ002S | 2024-11-22T14:09:25.296Z | 2024-11-22T14:09:25.296Z |
5568145 | 5568145 | 20241121115527_hBX1A | NZ002S | 2024-11-22T14:08:12.889Z | 2024-11-22T14:08:12.889Z |
5567717 | 5567717 | 20241121105649_HSgev | NZ002S | 2024-11-22T14:07:07.638Z | 2024-11-22T14:07:07.638Z |
5567092 | 5567092 | 20241121092011_porC8 | NZ002S | 2024-11-22T14:05:10.476Z | 2024-11-22T14:05:10.476Z |
5560915 | 5560915 | 20241120151934_59X9L | NZ002S | 2024-11-21T14:09:57.898Z | 2024-11-22T14:19:21.759Z |
5560867 | 5560867 | 20241120150402_vfRu6 | NZ002S | 2024-11-21T14:09:54.008Z | 2024-11-22T14:19:21.751Z |
5560864 | 5560864 | 20241120145913_G22pS | NZ002S | 2024-11-21T14:09:53.685Z | 2024-11-22T14:19:21.749Z |
5560823 | 5560823 | 20241120143620_9rsHm | NZ002S | 2024-11-21T14:09:48.695Z | 2024-11-22T14:19:21.740Z |
5560597 | 5560597 | 20241120132030_29p92 | NZ002S | 2024-11-21T14:09:12.080Z | 2024-11-22T14:19:21.693Z |
5559830 | 5559830 | 20241120112221_veMFv | NZ002S | 2024-11-21T14:07:17.907Z | 2024-11-22T14:19:21.533Z |
5555214 | 5555214 | 20241119121713_YTG0v | NZ002S | 2024-11-20T14:04:49.347Z | 2024-11-22T14:20:01.460Z |
5555086 | 5555086 | 20241119113849_NICF3 | NZ002S | 2024-11-20T14:04:26.191Z | 2024-11-22T14:19:58.184Z |
5554904 | 5554904 | 20241119105953_7mpz2 | NZ002S | 2024-11-20T14:03:47.007Z | 2024-11-22T14:19:53.761Z |
5554870 | 5554870 | 20241119105238_lnHw7 | NZ002S | 2024-11-20T14:03:40.566Z | 2024-11-22T14:19:52.829Z |
5554744 | 5554744 | 20241119102123_Rklby | NZ002S | 2024-11-20T14:03:10.701Z | 2024-11-22T14:19:50.467Z |
5554680 | 5554680 | 20241119100408_vOHNb | NZ002S | 2024-11-20T14:02:59.935Z | 2024-11-22T14:19:48.671Z |
5520442 | 5520442 | 20241111155621_JA2Zi | NZ002S | 2024-11-12T14:06:21.080Z | 2024-11-20T14:25:09.801Z |
5520399 | 5520399 | 20241111153507_qrpT9 | NZ002S | 2024-11-12T14:06:15.585Z | 2024-11-20T14:25:07.881Z |
5520165 | 5520165 | 20241111145306_0t21r | NZ002S | 2024-11-12T14:05:46.841Z | 2024-11-20T14:25:05.299Z |
5520149 | 5520149 | 20241111144752_XhUR5 | NZ002S | 2024-11-12T14:05:44.967Z | 2024-11-20T14:25:04.646Z |
5519874 | 5519874 | 20241111133943_d6Plj | NZ002S | 2024-11-12T14:05:14.390Z | 2024-11-20T14:25:00.305Z |
5519854 | 5519854 | 20241111133524_pt9Rc | NZ002S | 2024-11-12T14:05:11.273Z | 2024-11-20T14:24:59.970Z |
5500447 | 5500447 | 20241108154511_uh5hv | NZ002S | 2024-11-09T14:06:17.937Z | 2024-11-17T14:23:22.726Z |
5500427 | 5500427 | 20241108154202_SIVix | NZ002S | 2024-11-09T14:06:16.065Z | 2024-11-17T14:23:22.564Z |
5500358 | 5500358 | 20241108152716_Cev36 | NZ002S | 2024-11-09T14:06:10.294Z | 2024-11-17T14:23:22.113Z |
5500315 | 5500315 | 20241108151843_bycYs | NZ002S | 2024-11-09T14:06:06.252Z | 2024-11-17T14:23:21.509Z |
5500267 | 5500267 | 20241108150927_uAbGd | NZ002S | 2024-11-09T14:06:02.255Z | 2024-11-17T14:23:20.937Z |
5500220 | 5500220 | 20241108150557_2ot3C | NZ002S | 2024-11-09T14:05:59.385Z | 2024-11-17T14:23:20.224Z |
5499795 | 5499795 | 20241108133225_cO0ki | NZ002S | 2024-11-09T14:04:58.537Z | 2024-11-17T14:23:16.158Z |
5499761 | 5499761 | 20241108131821_C3j2M | NZ002S | 2024-11-09T14:04:55.327Z | 2024-11-17T14:23:15.870Z |
5499746 | 5499746 | 20241108131624_Kd233 | NZ002S | 2024-11-09T14:04:53.292Z | 2024-11-17T14:23:15.794Z |
5499715 | 5499715 | 20241108130736_TeeDR | NZ002S | 2024-11-09T14:04:48.616Z | 2024-11-17T14:23:14.708Z |
5499709 | 5499709 | 20241108130525_F3eXJ | NZ002S | 2024-11-09T14:04:47.667Z | 2024-11-17T14:23:14.666Z |
5499570 | 5499570 | 20241108123814_ra0xL | NZ002S | 2024-11-09T14:04:21.078Z | 2024-11-17T14:23:13.270Z |
5499430 | 5499430 | 20241108121812_bVMoj | NZ002S | 2024-11-09T14:04:05.930Z | 2024-11-17T14:23:11.608Z |
5494148 | 5494148 | 20241107160442_dPsDj | NZ002S | 2024-11-08T14:05:26.474Z | 2024-11-16T14:27:48.578Z |
5493922 | 5493922 | 20241107143719_oc5IP | NZ002S | 2024-11-08T14:04:55.684Z | 2024-11-16T14:27:43.018Z |
5480643 | 5480643 | 20241105142756_NIxTw | NZ002S | 2024-11-06T14:06:09.522Z | 2024-11-14T14:23:05.398Z |
5480551 | 5480551 | 20241105134428_ayNxD | NZ002S | 2024-11-06T14:05:54.441Z | 2024-11-14T14:23:04.799Z |
5480494 | 5480494 | 20241105131840_D4ogF | NZ002S | 2024-11-06T14:05:47.967Z | 2024-11-14T14:23:04.501Z |
5480458 | 5480458 | 20241105130609_Gp1DK | NZ002S | 2024-11-06T14:05:44.137Z | 2024-11-14T14:23:04.357Z |
5480352 | 5480352 | 20241105123212_uvKFs | NZ002S | 2024-11-06T14:05:19.678Z | 2024-11-14T14:23:03.933Z |
5480215 | 5480215 | 20241105120335_C8dWY | NZ002S | 2024-11-06T14:04:59.012Z | 2024-11-14T14:23:03.103Z |
5473967 | 5473967 | 20241103153102_GSduG | NZ002S | 2024-11-05T14:09:57.039Z | 2024-11-12T14:27:50.401Z |
5473736 | 5473736 | 20241103145711_QreSf | NZ002S | 2024-11-05T14:09:39.921Z | 2024-11-12T14:27:49.987Z |
5472937 | 5472937 | 20241103130228_D1OAq | NZ002S | 2024-11-05T14:07:53.732Z | 2024-11-12T14:27:47.319Z |
5472895 | 5472895 | 20241103125740_k7JPS | NZ002S | 2024-11-05T14:07:50.467Z | 2024-11-12T14:27:46.864Z |
5472844 | 5472844 | 20241103125210_2uB23 | NZ002S | 2024-11-05T14:07:47.349Z | 2024-11-12T14:27:46.820Z |
5472833 | 5472833 | 20241103125002_PfgGT | NZ002S | 2024-11-05T14:07:46.564Z | 2024-11-12T14:27:46.797Z |
5472785 | 5472785 | 20241103124115_XzPdx | NZ002S | 2024-11-05T14:07:42.569Z | 2024-11-12T14:27:46.730Z |
5472743 | 5472743 | 20241103123219_2oAGO | NZ002S | 2024-11-05T14:07:39.220Z | 2024-11-12T14:27:46.517Z |
5472313 | 5472313 | 20241104143713_3SSj2 | NZ002S | 2024-11-05T14:05:37.511Z | 2024-11-13T14:27:26.129Z |
5472082 | 5472082 | 20241104133518_YzWdy | NZ002S | 2024-11-05T14:05:05.036Z | 2024-11-13T14:27:25.689Z |
5471994 | 5471994 | 20241104132033_CgO1Z | NZ002S | 2024-11-05T14:04:55.952Z | 2024-11-13T14:27:25.560Z |
5471949 | 5471949 | 20241104130803_ObzJu | NZ002S | 2024-11-05T14:04:52.141Z | 2024-11-13T14:27:25.514Z |
5471821 | 5471821 | 20241104124710_vKawN | NZ002S | 2024-11-05T14:04:40.295Z | 2024-11-13T14:27:25.278Z |
5471772 | 5471772 | 20241104123530_0tGdk | NZ002S | 2024-11-05T14:04:34.732Z | 2024-11-13T14:27:25.075Z |
5471706 | 5471706 | 20241104122914_1B80G | NZ002S | 2024-11-05T14:04:27.623Z | 2024-11-13T14:27:24.980Z |
5471671 | 5471671 | 20241104122230_pgbjC | NZ002S | 2024-11-05T14:04:17.861Z | 2024-11-13T14:27:24.956Z |
5471455 | 5471455 | 20241104114645_ONFhv | NZ002S | 2024-11-05T14:03:45.452Z | 2024-11-13T14:27:24.324Z |
5471430 | 5471430 | 20241104114415_2FkTZ | NZ002S | 2024-11-05T14:03:43.625Z | 2024-11-13T14:27:24.276Z |
5471423 | 5471423 | 20241104114353_Loplv | NZ002S | 2024-11-05T14:03:43.087Z | 2024-11-13T14:27:24.273Z |
5471379 | 5471379 | 20241104113452_u2YM0 | NZ002S | 2024-11-05T14:03:34.287Z | 2024-11-13T14:27:24.168Z |
5471025 | 5471025 | 20241104103456_vPdOO | NZ002S | 2024-11-05T14:02:33.087Z | 2024-11-13T14:27:23.444Z |
5470930 | 5470930 | 20241104100816_GTBte | NZ002S | 2024-11-05T14:02:18.857Z | 2024-11-13T14:27:23.188Z |
5470910 | 5470910 | 20241104100248_E22fy | NZ002S | 2024-11-05T14:02:16.202Z | 2024-11-13T14:27:23.152Z |
5470653 | 5470653 | 20241104091350_WRJks | NZ002S | 2024-11-05T14:01:28.272Z | 2024-11-13T14:27:22.547Z |
5470475 | 5470475 | 20241104081438_7CBnR | NZ002S | 2024-11-05T14:00:50.299Z | 2024-11-13T14:27:22.176Z |
5465421 | 5465421 | 20241103115251_wev0L | NZ002S | 2024-11-04T14:03:41.314Z | 2024-11-12T14:27:46.202Z |
5465396 | 5465396 | 20241103114430_q4YEI | NZ002S | 2024-11-04T14:03:38.285Z | 2024-11-12T14:27:46.191Z |
5465379 | 5465379 | 20241103114044_HCsWQ | NZ002S | 2024-11-04T14:03:36.805Z | 2024-11-12T14:27:46.162Z |
5465270 | 5465270 | 20241103111438_88fdA | NZ002S | 2024-11-04T14:03:13.963Z | 2024-11-12T14:27:45.684Z |
5465260 | 5465260 | 20241103111303_qaduC | NZ002S | 2024-11-04T14:03:11.657Z | 2024-11-12T14:27:45.644Z |
5465171 | 5465171 | 20241103105549_jhvKH | NZ002S | 2024-11-04T14:03:00.109Z | 2024-11-12T14:27:45.341Z |
5464906 | 5464906 | 20241103095040_lsaUz | NZ002S | 2024-11-04T14:02:08.715Z | 2024-11-12T14:27:43.848Z |
5464837 | 5464837 | 20241103092930_RUf63 | NZ002S | 2024-11-04T14:01:48.390Z | 2024-11-12T14:27:43.329Z |
5464723 | 5464723 | 20241103090224_t2fI0 | NZ002S | 2024-11-04T14:01:30.010Z | 2024-11-12T14:27:43.112Z |
5464686 | 5464686 | 20241103085102_A7zg8 | NZ002S | 2024-11-04T14:01:20.977Z | 2024-11-12T14:27:42.982Z |
5464654 | 5464654 | 20241103084355_k2Cek | NZ002S | 2024-11-04T14:01:14.131Z | 2024-11-12T14:27:42.772Z |
5464515 | 5464515 | 20241103080016_Zmq6y | NZ002S | 2024-11-04T14:00:48.324Z | 2024-11-12T14:27:42.096Z |
5461161 | 5461161 | 20241101161841_Q3Oeh | NZ002S | 2024-11-03T14:14:46.475Z | 2024-11-10T14:26:26.894Z |
5461156 | 5461156 | 20241101161805_s8KNk | NZ002S | 2024-11-03T14:14:46.224Z | 2024-11-10T14:26:26.889Z |
5460776 | 5460776 | 20241101150155_BMGK1 | NZ002S | 2024-11-03T14:14:24.523Z | 2024-11-10T14:26:25.468Z |
5460729 | 5460729 | 20241101145709_SZik7 | NZ002S | 2024-11-03T14:14:18.174Z | 2024-11-10T14:26:25.200Z |
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);