participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,968 rows where station_code = "NZ004H" 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 |
---|---|---|---|---|---|
5603407 | 5603407 | 20241125152114_r2ARU | NZ004H | 2024-11-26T14:11:04.002Z | 2024-11-26T14:11:04.002Z |
5603361 | 5603361 | 20241125151006_TtFJV | NZ004H | 2024-11-26T14:10:59.540Z | 2024-11-26T14:10:59.540Z |
5603283 | 5603283 | 20241125145040_HVfjV | NZ004H | 2024-11-26T14:10:49.837Z | 2024-11-26T14:10:49.837Z |
5603240 | 5603240 | 20241125144347_TPQad | NZ004H | 2024-11-26T14:10:36.647Z | 2024-11-26T14:10:36.647Z |
5603150 | 5603150 | 20241125142517_SzIOi | NZ004H | 2024-11-26T14:10:23.017Z | 2024-11-26T14:10:23.017Z |
5603148 | 5603148 | 20241125142330_drZDR | NZ004H | 2024-11-26T14:10:22.447Z | 2024-11-26T14:10:22.447Z |
5603032 | 5603032 | 20241125135138_NTs86 | NZ004H | 2024-11-26T14:10:09.124Z | 2024-11-26T14:10:09.124Z |
5603030 | 5603030 | 20241125135120_VPXUR | NZ004H | 2024-11-26T14:10:08.940Z | 2024-11-26T14:10:08.940Z |
5603004 | 5603004 | 20241125134744_RJbwx | NZ004H | 2024-11-26T14:10:06.532Z | 2024-11-26T14:10:06.532Z |
5602946 | 5602946 | 20241125133511_7cCmd | NZ004H | 2024-11-26T14:09:55.698Z | 2024-11-26T14:09:55.698Z |
5602934 | 5602934 | 20241125133302_NvCm5 | NZ004H | 2024-11-26T14:09:52.370Z | 2024-11-26T14:09:52.370Z |
5602905 | 5602905 | 20241125132504_95M35 | NZ004H | 2024-11-26T14:09:46.874Z | 2024-11-26T14:09:46.874Z |
5602898 | 5602898 | 20241125132306_fmHZG | NZ004H | 2024-11-26T14:09:45.644Z | 2024-11-26T14:09:45.644Z |
5602826 | 5602826 | 20241125130733_7mKv2 | NZ004H | 2024-11-26T14:09:37.059Z | 2024-11-26T14:09:37.059Z |
5602773 | 5602773 | 20241125125531_R2PPp | NZ004H | 2024-11-26T14:09:31.547Z | 2024-11-26T14:09:31.547Z |
5602764 | 5602764 | 20241125125511_wyHrL | NZ004H | 2024-11-26T14:09:30.879Z | 2024-11-26T14:09:30.879Z |
5602723 | 5602723 | 20241125124552_M2DDC | NZ004H | 2024-11-26T14:09:26.263Z | 2024-11-26T14:09:26.263Z |
5602623 | 5602623 | 20241125122704_S729z | NZ004H | 2024-11-26T14:09:03.069Z | 2024-11-26T14:09:03.069Z |
5602608 | 5602608 | 20241125122319_xteNZ | NZ004H | 2024-11-26T14:08:57.563Z | 2024-11-26T14:08:57.563Z |
5602525 | 5602525 | 20241125120846_nYQpF | NZ004H | 2024-11-26T14:08:44.091Z | 2024-11-26T14:08:44.091Z |
5602493 | 5602493 | 20241125120324_ZS58n | NZ004H | 2024-11-26T14:08:40.532Z | 2024-11-26T14:08:40.532Z |
5602480 | 5602480 | 20241125120107_FWzI5 | NZ004H | 2024-11-26T14:08:39.637Z | 2024-11-26T14:08:39.637Z |
5602358 | 5602358 | 20241125114233_Itdhg | NZ004H | 2024-11-26T14:08:27.071Z | 2024-11-26T14:08:27.071Z |
5602346 | 5602346 | 20241125114057_QXG5O | NZ004H | 2024-11-26T14:08:26.039Z | 2024-11-26T14:08:26.039Z |
5602327 | 5602327 | 20241125113448_zlRvf | NZ004H | 2024-11-26T14:08:23.269Z | 2024-11-26T14:08:23.269Z |
5602132 | 5602132 | 20241125110300_1z7Co | NZ004H | 2024-11-26T14:07:42.364Z | 2024-11-26T14:07:42.364Z |
5602113 | 5602113 | 20241125110036_qQ2h2 | NZ004H | 2024-11-26T14:07:40.154Z | 2024-11-26T14:07:40.154Z |
5602070 | 5602070 | 20241125105457_P818k | NZ004H | 2024-11-26T14:07:36.693Z | 2024-11-26T14:07:36.693Z |
5601863 | 5601863 | 20241125101924_FG5A0 | NZ004H | 2024-11-26T14:07:00.311Z | 2024-11-26T14:07:00.311Z |
5601861 | 5601861 | 20241125101900_kH3iq | NZ004H | 2024-11-26T14:06:59.717Z | 2024-11-26T14:06:59.717Z |
5601779 | 5601779 | 20241125100707_LlWqt | NZ004H | 2024-11-26T14:06:47.646Z | 2024-11-26T14:06:47.646Z |
5601754 | 5601754 | 20241125100300_m5KW3 | NZ004H | 2024-11-26T14:06:36.135Z | 2024-11-26T14:06:36.135Z |
5601744 | 5601744 | 20241125100127_C7Ip2 | NZ004H | 2024-11-26T14:06:33.897Z | 2024-11-26T14:06:33.897Z |
5601731 | 5601731 | 20241125095705_g8p4W | NZ004H | 2024-11-26T14:06:32.255Z | 2024-11-26T14:06:32.255Z |
5601701 | 5601701 | 20241125095202_bUJLD | NZ004H | 2024-11-26T14:06:27.509Z | 2024-11-26T14:06:27.509Z |
5601680 | 5601680 | 20241125094700_jyLnQ | NZ004H | 2024-11-26T14:06:24.888Z | 2024-11-26T14:06:24.888Z |
5601642 | 5601642 | 20241125093730_AZ7pH | NZ004H | 2024-11-26T14:06:18.145Z | 2024-11-26T14:06:18.145Z |
5597443 | 5597443 | 20241124152419_rg2lL | NZ004H | 2024-11-25T14:11:29.237Z | 2024-11-26T14:18:44.598Z |
5597423 | 5597423 | 20241124152251_aq9Pj | NZ004H | 2024-11-25T14:11:28.127Z | 2024-11-26T14:18:44.595Z |
5597396 | 5597396 | 20241124152042_owJBH | NZ004H | 2024-11-25T14:11:26.219Z | 2024-11-26T14:18:44.589Z |
5597353 | 5597353 | 20241124151856_chnw8 | NZ004H | 2024-11-25T14:11:24.123Z | 2024-11-26T14:18:44.583Z |
5597311 | 5597311 | 20241124151620_seSsc | NZ004H | 2024-11-25T14:11:21.580Z | 2024-11-26T14:18:44.576Z |
5597183 | 5597183 | 20241124150846_Pk6Y7 | NZ004H | 2024-11-25T14:11:14.456Z | 2024-11-26T14:18:44.557Z |
5597151 | 5597151 | 20241124150719_bPbNU | NZ004H | 2024-11-25T14:11:11.964Z | 2024-11-26T14:18:44.552Z |
5597036 | 5597036 | 20241124145656_zjV1W | NZ004H | 2024-11-25T14:10:59.489Z | 2024-11-26T14:18:44.537Z |
5596912 | 5596912 | 20241124144519_WkA07 | NZ004H | 2024-11-25T14:10:47.256Z | 2024-11-26T14:18:44.508Z |
5596809 | 5596809 | 20241124142944_UY2L7 | NZ004H | 2024-11-25T14:10:36.626Z | 2024-11-26T14:18:44.483Z |
5596744 | 5596744 | 20241124142109_byVMS | NZ004H | 2024-11-25T14:10:31.450Z | 2024-11-26T14:18:44.473Z |
5596718 | 5596718 | 20241124141741_tc3pW | NZ004H | 2024-11-25T14:10:29.695Z | 2024-11-26T14:18:44.469Z |
5596504 | 5596504 | 20241124135729_n3znf | NZ004H | 2024-11-25T14:10:11.953Z | 2024-11-26T14:18:44.437Z |
5596356 | 5596356 | 20241124134102_5c3BJ | NZ004H | 2024-11-25T14:09:51.332Z | 2024-11-26T14:18:44.414Z |
5596042 | 5596042 | 20241124130926_MhleP | NZ004H | 2024-11-25T14:09:24.352Z | 2024-11-26T14:18:44.365Z |
5596025 | 5596025 | 20241124130812_v5qvh | NZ004H | 2024-11-25T14:09:22.931Z | 2024-11-26T14:18:44.362Z |
5595573 | 5595573 | 20241124123229_dTQnZ | NZ004H | 2024-11-25T14:08:33.282Z | 2024-11-26T14:18:44.290Z |
5595508 | 5595508 | 20241124122639_z9YEd | NZ004H | 2024-11-25T14:08:23.902Z | 2024-11-26T14:18:44.279Z |
5595471 | 5595471 | 20241124122128_G59JF | NZ004H | 2024-11-25T14:08:18.040Z | 2024-11-26T14:18:44.273Z |
5595387 | 5595387 | 20241124121304_jIWFO | NZ004H | 2024-11-25T14:08:06.330Z | 2024-11-26T14:18:44.261Z |
5595160 | 5595160 | 20241124114903_Q32pU | NZ004H | 2024-11-25T14:07:40.763Z | 2024-11-26T14:18:44.217Z |
5594982 | 5594982 | 20241124112733_LFpbC | NZ004H | 2024-11-25T14:07:03.950Z | 2024-11-26T14:18:44.184Z |
5594976 | 5594976 | 20241124112613_dFRZ6 | NZ004H | 2024-11-25T14:07:03.570Z | 2024-11-26T14:18:44.183Z |
5584031 | 5584031 | 20241117153241_fDt63 | NZ004H | 2024-11-23T14:25:21.452Z | 2024-11-26T14:28:38.048Z |
5583679 | 5583679 | 20241118085536_eN5Bl | NZ004H | 2024-11-23T14:24:51.826Z | 2024-11-26T14:27:59.452Z |
5583059 | 5583059 | 20241120150306_T3Xzw | NZ004H | 2024-11-23T14:22:45.133Z | 2024-11-26T14:26:08.304Z |
5577351 | 5577351 | 20241121150821_WLzsm | NZ004H | 2024-11-23T14:14:57.056Z | 2024-11-26T14:24:33.678Z |
5577349 | 5577349 | 20241121150821_UIcRL | NZ004H | 2024-11-23T14:14:56.433Z | 2024-11-26T14:24:33.660Z |
5575778 | 5575778 | 20241122101603_mWBNC | NZ004H | 2024-11-23T14:07:34.813Z | 2024-11-26T14:22:43.861Z |
5575592 | 5575592 | 20241122094607_tnZnz | NZ004H | 2024-11-23T14:06:53.508Z | 2024-11-26T14:22:42.123Z |
5569422 | 5569422 | 20241121152627_JuTUs | NZ004H | 2024-11-22T14:10:51.700Z | 2024-11-26T14:24:34.262Z |
5569028 | 5569028 | 20241121142006_SRVjE | NZ004H | 2024-11-22T14:10:12.141Z | 2024-11-26T14:24:31.974Z |
5568963 | 5568963 | 20241121141102_PpPV5 | NZ004H | 2024-11-22T14:10:07.131Z | 2024-11-26T14:24:31.835Z |
5560885 | 5560885 | 20241120150918_xvBFn | NZ004H | 2024-11-21T14:09:55.245Z | 2024-11-26T14:26:08.400Z |
5560857 | 5560857 | 20241120145357_kk5lE | NZ004H | 2024-11-21T14:09:52.780Z | 2024-11-26T14:26:08.196Z |
5560759 | 5560759 | 20241120141600_FL4V6 | NZ004H | 2024-11-21T14:09:42.542Z | 2024-11-26T14:26:07.700Z |
5560689 | 5560689 | 20241120135605_EmGor | NZ004H | 2024-11-21T14:09:26.679Z | 2024-11-26T14:26:07.568Z |
5560073 | 5560073 | 20241120115410_PEGxc | NZ004H | 2024-11-21T14:07:59.455Z | 2024-11-26T14:26:02.993Z |
5559123 | 5559123 | 20241120092649_UJfzU | NZ004H | 2024-11-21T14:05:25.308Z | 2024-11-26T14:25:52.772Z |
5555280 | 5555280 | 20241119123220_3xAA2 | NZ004H | 2024-11-20T14:05:05.188Z | 2024-11-26T14:27:18.878Z |
5551814 | 5551814 | 20241118151946_cEkK6 | NZ004H | 2024-11-19T14:05:36.215Z | 2024-11-26T14:28:08.568Z |
5551776 | 5551776 | 20241118150832_4Vf3D | NZ004H | 2024-11-19T14:05:28.892Z | 2024-11-26T14:28:08.532Z |
5551559 | 5551559 | 20241118141300_szHDa | NZ004H | 2024-11-19T14:04:59.514Z | 2024-11-26T14:28:08.257Z |
5551506 | 5551506 | 20241118140043_rYtXK | NZ004H | 2024-11-19T14:04:54.643Z | 2024-11-26T14:28:08.159Z |
5551495 | 5551495 | 20241118135748_qfztP | NZ004H | 2024-11-19T14:04:53.439Z | 2024-11-26T14:28:08.148Z |
5550719 | 5550719 | 20241118111437_xi2Ef | NZ004H | 2024-11-19T14:02:58.158Z | 2024-11-26T14:28:03.597Z |
5550095 | 5550095 | 20241118092953_jyICJ | NZ004H | 2024-11-19T14:01:34.256Z | 2024-11-26T14:28:00.837Z |
5549883 | 5549883 | 20241118082913_9wkkc | NZ004H | 2024-11-19T14:01:05.730Z | 2024-11-26T14:27:59.077Z |
5546791 | 5546791 | 20241117124327_Of13k | NZ004H | 2024-11-18T14:04:14.272Z | 2024-11-26T14:28:33.837Z |
5546279 | 5546279 | 20241117101000_vvjfa | NZ004H | 2024-11-18T14:02:40.333Z | 2024-11-26T14:28:26.652Z |
5546004 | 5546004 | 20241117083925_sMQ0X | NZ004H | 2024-11-18T14:01:41.580Z | 2024-11-26T14:28:24.640Z |
5545997 | 5545997 | 20241117083837_oOyL3 | NZ004H | 2024-11-18T14:01:41.128Z | 2024-11-26T14:28:24.637Z |
5536083 | 5536083 | 20241112153441_w3uOC | NZ004H | 2024-11-14T14:09:10.914Z | 2024-11-21T14:25:56.618Z |
5536076 | 5536076 | 20241112153351_sjU4X | NZ004H | 2024-11-14T14:09:10.337Z | 2024-11-21T14:25:56.475Z |
5536049 | 5536049 | 20241112152927_I8YI9 | NZ004H | 2024-11-14T14:09:08.645Z | 2024-11-21T14:25:56.389Z |
5536036 | 5536036 | 20241112152806_iWmv0 | NZ004H | 2024-11-14T14:09:07.922Z | 2024-11-21T14:25:56.219Z |
5535467 | 5535467 | 20241112123401_g5Rtl | NZ004H | 2024-11-14T14:07:58.589Z | 2024-11-21T14:25:48.547Z |
5535350 | 5535350 | 20241112121819_jUShL | NZ004H | 2024-11-14T14:07:50.430Z | 2024-11-21T14:25:46.526Z |
5527050 | 5527050 | 20241112105416_EquN9 | NZ004H | 2024-11-13T14:04:55.818Z | 2024-11-21T14:25:40.802Z |
5519837 | 5519837 | 20241111132850_1r3DE | NZ004H | 2024-11-12T14:05:08.414Z | 2024-11-20T14:24:58.584Z |
5519799 | 5519799 | 20241111130705_IuEn2 | NZ004H | 2024-11-12T14:05:02.280Z | 2024-11-20T14:24:58.020Z |
5514445 | 5514445 | 20241110155113_2ViWX | NZ004H | 2024-11-11T14:06:38.258Z | 2024-11-19T14:21:47.939Z |
5500305 | 5500305 | 20241108151700_nI4bG | NZ004H | 2024-11-09T14:06:05.209Z | 2024-11-17T14:23:21.268Z |
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);