participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,398 rows where station_code = "NZ000G" 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 |
---|---|---|---|---|---|
5569197 | 5569197 | 20241121145101_VrCjj | NZ000G | 2024-11-22T14:10:34.120Z | 2024-11-22T14:10:34.120Z |
5569062 | 5569062 | 20241121142558_GLZoW | NZ000G | 2024-11-22T14:10:16.400Z | 2024-11-22T14:10:16.400Z |
5568594 | 5568594 | 20241121131018_kEEW1 | NZ000G | 2024-11-22T14:09:24.457Z | 2024-11-22T14:09:24.457Z |
5568576 | 5568576 | 20241121130609_3pRbs | NZ000G | 2024-11-22T14:09:22.661Z | 2024-11-22T14:09:22.661Z |
5568226 | 5568226 | 20241121120923_nZyUe | NZ000G | 2024-11-22T14:08:31.848Z | 2024-11-22T14:08:31.848Z |
5568103 | 5568103 | 20241121114906_kPwNp | NZ000G | 2024-11-22T14:08:06.504Z | 2024-11-22T14:08:06.504Z |
5567959 | 5567959 | 20241121113648_V2WkC | NZ000G | 2024-11-22T14:07:52.146Z | 2024-11-22T14:07:52.146Z |
5567227 | 5567227 | 20241121094600_tcJ24 | NZ000G | 2024-11-22T14:05:38.103Z | 2024-11-22T14:05:38.103Z |
5560893 | 5560893 | 20241120151311_ST4Wx | NZ000G | 2024-11-21T14:09:55.861Z | 2024-11-22T14:19:21.754Z |
5559301 | 5559301 | 20241120095835_6qP3Q | NZ000G | 2024-11-21T14:05:54.186Z | 2024-11-22T14:19:21.412Z |
5559277 | 5559277 | 20241120095423_vD22c | NZ000G | 2024-11-21T14:05:48.469Z | 2024-11-22T14:19:21.404Z |
5555731 | 5555731 | 20241119151727_VVLNH | NZ000G | 2024-11-20T14:06:29.985Z | 2024-11-22T14:20:13.247Z |
5555681 | 5555681 | 20241119144100_HGS1R | NZ000G | 2024-11-20T14:06:24.292Z | 2024-11-22T14:20:12.437Z |
5555670 | 5555670 | 20241119143307_vPBwG | NZ000G | 2024-11-20T14:06:22.927Z | 2024-11-22T14:20:12.206Z |
5555620 | 5555620 | 20241119140902_6lt0Q | NZ000G | 2024-11-20T14:06:08.811Z | 2024-11-22T14:20:10.998Z |
5555497 | 5555497 | 20241119133504_bLIRR | NZ000G | 2024-11-20T14:05:52.028Z | 2024-11-22T14:20:07.625Z |
5555421 | 5555421 | 20241119131023_3nRVl | NZ000G | 2024-11-20T14:05:35.935Z | 2024-11-22T14:20:05.797Z |
5555406 | 5555406 | 20241119130451_vr3LW | NZ000G | 2024-11-20T14:05:32.057Z | 2024-11-22T14:20:05.510Z |
5555385 | 5555385 | 20241119130228_T76o6 | NZ000G | 2024-11-20T14:05:25.187Z | 2024-11-22T14:20:05.026Z |
5551588 | 5551588 | 20241118142151_S5SRt | NZ000G | 2024-11-19T14:05:01.788Z | 2024-11-22T14:22:11.530Z |
5551496 | 5551496 | 20241118135805_fQLSu | NZ000G | 2024-11-19T14:04:53.837Z | 2024-11-22T14:22:11.037Z |
5551429 | 5551429 | 20241118133530_ne43Q | NZ000G | 2024-11-19T14:04:46.579Z | 2024-11-22T14:22:10.652Z |
5551319 | 5551319 | 20241118130626_bNAYR | NZ000G | 2024-11-19T14:04:24.415Z | 2024-11-22T14:22:10.040Z |
5551185 | 5551185 | 20241118124212_iK1k2 | NZ000G | 2024-11-19T14:04:04.935Z | 2024-11-22T14:22:09.019Z |
5550904 | 5550904 | 20241118114710_p1EaY | NZ000G | 2024-11-19T14:03:23.506Z | 2024-11-22T14:22:06.699Z |
5550416 | 5550416 | 20241118101818_F38mG | NZ000G | 2024-11-19T14:02:18.943Z | 2024-11-22T14:22:02.820Z |
5547047 | 5547047 | 20241117142841_GlKxJ | NZ000G | 2024-11-18T14:04:49.185Z | 2024-11-22T14:22:36.597Z |
5547041 | 5547041 | 20241117142724_jhWJH | NZ000G | 2024-11-18T14:04:46.584Z | 2024-11-22T14:22:36.563Z |
5547020 | 5547020 | 20241117141804_Y9HWr | NZ000G | 2024-11-18T14:04:43.008Z | 2024-11-22T14:22:36.468Z |
5547011 | 5547011 | 20241117141335_fAyJ4 | NZ000G | 2024-11-18T14:04:42.393Z | 2024-11-22T14:22:36.400Z |
5546994 | 5546994 | 20241117140631_oCPmx | NZ000G | 2024-11-18T14:04:40.789Z | 2024-11-22T14:22:36.294Z |
5546866 | 5546866 | 20241117130912_NM2XL | NZ000G | 2024-11-18T14:04:23.056Z | 2024-11-22T14:22:35.231Z |
5546821 | 5546821 | 20241117125104_Ac25m | NZ000G | 2024-11-18T14:04:17.485Z | 2024-11-22T14:22:34.793Z |
5546733 | 5546733 | 20241117122950_lvtSD | NZ000G | 2024-11-18T14:04:04.080Z | 2024-11-22T14:22:34.313Z |
5546667 | 5546667 | 20241117121006_fdaJX | NZ000G | 2024-11-18T14:03:46.707Z | 2024-11-22T14:22:33.726Z |
5546479 | 5546479 | 20241117110835_bdYKg | NZ000G | 2024-11-18T14:03:12.230Z | 2024-11-22T14:22:32.237Z |
5546477 | 5546477 | 20241117110834_sK6qz | NZ000G | 2024-11-18T14:03:11.989Z | 2024-11-22T14:22:32.228Z |
5536050 | 5536050 | 20241112153059_A9N4A | NZ000G | 2024-11-14T14:09:08.865Z | 2024-11-21T14:25:56.405Z |
5535985 | 5535985 | 20241112151150_p2Of2 | NZ000G | 2024-11-14T14:09:04.398Z | 2024-11-21T14:25:55.968Z |
5535975 | 5535975 | 20241112150845_1A9xS | NZ000G | 2024-11-14T14:09:03.504Z | 2024-11-21T14:25:55.685Z |
5535910 | 5535910 | 20241112145120_UJBDE | NZ000G | 2024-11-14T14:08:58.561Z | 2024-11-21T14:25:54.581Z |
5535857 | 5535857 | 20241112143753_yYlbJ | NZ000G | 2024-11-14T14:08:55.139Z | 2024-11-21T14:25:53.881Z |
5535818 | 5535818 | 20241112143053_INcD0 | NZ000G | 2024-11-14T14:08:52.035Z | 2024-11-21T14:25:53.574Z |
5520297 | 5520297 | 20241111151532_L2P33 | NZ000G | 2024-11-12T14:06:06.664Z | 2024-11-20T14:25:06.615Z |
5520205 | 5520205 | 20241111145800_C2v7B | NZ000G | 2024-11-12T14:05:57.678Z | 2024-11-20T14:25:05.804Z |
5520179 | 5520179 | 20241111145428_4V3wi | NZ000G | 2024-11-12T14:05:51.005Z | 2024-11-20T14:25:05.466Z |
5520118 | 5520118 | 20241111143827_zid68 | NZ000G | 2024-11-12T14:05:39.315Z | 2024-11-20T14:25:04.097Z |
5520073 | 5520073 | 20241111143127_OzQX3 | NZ000G | 2024-11-12T14:05:33.597Z | 2024-11-20T14:25:03.078Z |
5519971 | 5519971 | 20241111140720_SeewJ | NZ000G | 2024-11-12T14:05:24.450Z | 2024-11-20T14:25:01.316Z |
5519821 | 5519821 | 20241111131434_a3oEW | NZ000G | 2024-11-12T14:05:05.829Z | 2024-11-20T14:24:58.336Z |
5514379 | 5514379 | 20241110154058_zGDoy | NZ000G | 2024-11-11T14:06:33.943Z | 2024-11-19T14:21:46.981Z |
5514361 | 5514361 | 20241110153817_h25DV | NZ000G | 2024-11-11T14:06:32.679Z | 2024-11-19T14:21:46.740Z |
5514299 | 5514299 | 20241110152739_Wq13W | NZ000G | 2024-11-11T14:06:27.061Z | 2024-11-19T14:21:46.012Z |
5514072 | 5514072 | 20241110141241_yjPNX | NZ000G | 2024-11-11T14:06:00.857Z | 2024-11-19T14:21:43.003Z |
5514067 | 5514067 | 20241110141009_UzHJY | NZ000G | 2024-11-11T14:06:00.282Z | 2024-11-19T14:21:42.922Z |
5514024 | 5514024 | 20241110134601_lgZB6 | NZ000G | 2024-11-11T14:05:49.819Z | 2024-11-19T14:21:41.926Z |
5514002 | 5514002 | 20241110133251_1ohVP | NZ000G | 2024-11-11T14:05:47.068Z | 2024-11-19T14:21:41.629Z |
5514000 | 5514000 | 20241110132806_l2d0t | NZ000G | 2024-11-11T14:05:46.864Z | 2024-11-19T14:21:41.472Z |
5513991 | 5513991 | 20241110131922_iPb63 | NZ000G | 2024-11-11T14:05:45.944Z | 2024-11-19T14:21:41.275Z |
5513980 | 5513980 | 20241110131332_X0ewq | NZ000G | 2024-11-11T14:05:45.147Z | 2024-11-19T14:21:41.169Z |
5513962 | 5513962 | 20241110130016_uEbez | NZ000G | 2024-11-11T14:05:43.382Z | 2024-11-19T14:21:40.856Z |
5513960 | 5513960 | 20241110130004_WfWQS | NZ000G | 2024-11-11T14:05:42.946Z | 2024-11-19T14:21:40.838Z |
5513949 | 5513949 | 20241110125440_qY6gh | NZ000G | 2024-11-11T14:05:42.284Z | 2024-11-19T14:21:40.649Z |
5513881 | 5513881 | 20241110123604_37k3X | NZ000G | 2024-11-11T14:05:35.446Z | 2024-11-19T14:21:39.385Z |
5492907 | 5492907 | 20241107101856_z21jn | NZ000G | 2024-11-08T14:02:31.726Z | 2024-11-16T14:27:30.469Z |
5486949 | 5486949 | 20241106140854_QsbTx | NZ000G | 2024-11-07T14:04:26.795Z | 2024-11-15T14:24:36.073Z |
5486921 | 5486921 | 20241106140354_WIuF1 | NZ000G | 2024-11-07T14:04:23.918Z | 2024-11-15T14:24:35.884Z |
5486703 | 5486703 | 20241106130005_DV5yp | NZ000G | 2024-11-07T14:03:48.791Z | 2024-11-15T14:24:33.148Z |
5486701 | 5486701 | 20241106130003_PaZfc | NZ000G | 2024-11-07T14:03:48.355Z | 2024-11-15T14:24:33.129Z |
5486608 | 5486608 | 20241106123129_Gx3BX | NZ000G | 2024-11-07T14:03:29.766Z | 2024-11-15T14:24:32.080Z |
5480752 | 5480752 | 20241105152401_GclfR | NZ000G | 2024-11-06T14:06:29.282Z | 2024-11-14T14:23:06.345Z |
5480747 | 5480747 | 20241105152018_B2Cm2 | NZ000G | 2024-11-06T14:06:28.616Z | 2024-11-14T14:23:06.334Z |
5474069 | 5474069 | 20241103154804_TFrTB | NZ000G | 2024-11-05T14:10:06.195Z | 2024-11-12T14:27:50.498Z |
5464674 | 5464674 | 20241103084635_FvNwS | NZ000G | 2024-11-04T14:01:18.677Z | 2024-11-12T14:27:42.790Z |
5460940 | 5460940 | 20241101152311_DvKiw | NZ000G | 2024-11-03T14:14:35.339Z | 2024-11-10T14:26:25.968Z |
5460921 | 5460921 | 20241101152022_54f3m | NZ000G | 2024-11-03T14:14:34.357Z | 2024-11-10T14:26:25.854Z |
5460896 | 5460896 | 20241101151808_ZcBNC | NZ000G | 2024-11-03T14:14:33.375Z | 2024-11-10T14:26:25.734Z |
5460723 | 5460723 | 20241101145603_4BjVT | NZ000G | 2024-11-03T14:14:17.299Z | 2024-11-10T14:26:25.184Z |
5460684 | 5460684 | 20241101144854_9wguA | NZ000G | 2024-11-03T14:14:13.758Z | 2024-11-10T14:26:25.127Z |
5460384 | 5460384 | 20241101140145_SPyWH | NZ000G | 2024-11-03T14:13:41.049Z | 2024-11-10T14:26:23.747Z |
5460235 | 5460235 | 20241101132036_B5mW3 | NZ000G | 2024-11-03T14:13:30.485Z | 2024-11-10T14:26:23.069Z |
5458012 | 5458012 | 20241102155751_usACH | NZ000G | 2024-11-03T14:08:32.878Z | 2024-11-11T14:22:38.473Z |
5457902 | 5457902 | 20241102153818_aXX27 | NZ000G | 2024-11-03T14:08:19.861Z | 2024-11-11T14:22:37.240Z |
5457570 | 5457570 | 20241102144751_INIwE | NZ000G | 2024-11-03T14:07:40.661Z | 2024-11-11T14:22:35.556Z |
5457464 | 5457464 | 20241102143351_TrhXp | NZ000G | 2024-11-03T14:07:23.224Z | 2024-11-11T14:22:34.841Z |
5457452 | 5457452 | 20241102143318_Rid4v | NZ000G | 2024-11-03T14:07:21.400Z | 2024-11-11T14:22:34.838Z |
5457313 | 5457313 | 20241102140914_Gwmzb | NZ000G | 2024-11-03T14:07:06.331Z | 2024-11-11T14:22:34.127Z |
5457134 | 5457134 | 20241102133601_5qDdT | NZ000G | 2024-11-03T14:06:37.501Z | 2024-11-11T14:22:33.146Z |
5457033 | 5457033 | 20241102131543_728Wl | NZ000G | 2024-11-03T14:06:24.810Z | 2024-11-11T14:22:32.454Z |
5456978 | 5456978 | 20241102130441_15j4W | NZ000G | 2024-11-03T14:06:17.855Z | 2024-11-11T14:22:32.292Z |
5456829 | 5456829 | 20241102123414_VIqWg | NZ000G | 2024-11-03T14:05:46.196Z | 2024-11-11T14:22:31.731Z |
5456709 | 5456709 | 20241102120726_YGt3T | NZ000G | 2024-11-03T14:05:32.017Z | 2024-11-11T14:22:30.883Z |
5456587 | 5456587 | 20241102114726_dYRbH | NZ000G | 2024-11-03T14:05:03.156Z | 2024-11-11T14:22:29.860Z |
5456568 | 5456568 | 20241102114546_m3mXe | NZ000G | 2024-11-03T14:05:00.676Z | 2024-11-11T14:22:29.795Z |
5456392 | 5456392 | 20241102111214_S7LO3 | NZ000G | 2024-11-03T14:04:23.304Z | 2024-11-11T14:22:28.574Z |
5456375 | 5456375 | 20241102110831_as0pB | NZ000G | 2024-11-03T14:04:19.893Z | 2024-11-11T14:22:28.470Z |
5436422 | 5436422 | 20241030130522_h75Vy | NZ000G | 2024-11-01T12:07:32.478Z | 2024-11-08T14:22:54.036Z |
5435996 | 5435996 | 20241030121731_rgYSk | NZ000G | 2024-11-01T12:06:30.148Z | 2024-11-08T14:22:52.346Z |
5435836 | 5435836 | 20241030120158_AEP09 | NZ000G | 2024-11-01T12:06:02.529Z | 2024-11-08T14:22:51.784Z |
5427315 | 5427315 | 20241028145650_8g3n0 | NZ000G | 2024-10-31T12:13:25.961Z | 2024-11-06T14:27:11.636Z |
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);