names

120 rows where place_id = 605966

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663547 1914525 1914525 defendant Strynger William butcher 605966 605966 Strynger, William, of Hampton, butcher 0
3676213 1918606 1918606 plaintiff Husee John merchant 605966 605966 Husee, John, of Hampton, merchant 0
3710747 1929682 1929682 defendant Cookys John husbandman 605966 605966 Cookys, John, of Hampton, husbandman 2
3711634 1929950 1929950 defendant Bogham William chaplain 605966 605966 Bogham, William, of Hampton, chaplain 1
3727158 1934765 1934765 defendant Harresfeld Walter husbandman 605966 605966 Harresfeld, Walter, of Hampton, husbandman 2
3746542 1940831 1940831 defendant Ely Thomas   605966 605966 Ely, Thomas, of Hampton, "Inkepar" 1
3749119 1941655 1941655 defendant Hubberd Thomas innkeeper 605966 605966 Hubberd, Thomas, of Hampton, innkeeper 0
3773655 1949478 1949478 defendant Cokkys Bernard yeoman 605966 605966 Cokkys, Bernard, of Hampton, yeoman 0
3781818 1952058 1952058 defendant Hubbard Thomas innholder 605966 605966 Hubbard, Thomas, of Hampton, innholder 0
3782283 1952213 1952213 defendant Kynnarton William gent 605966 605966 Kynnarton, William, of Hampton, gent 0
3782285 1952214 1952214 defendant Kynnarton William gent 605966 605966 Kynnarton, William, of Hampton, gent 0
3798080 1957296 1957296 defendant Kynaston Ralph gent 605966 605966 Kynaston, Ralph, of Hampton, gent 0
3834431 1968716 1968716 defendant Clay John smith 605966 605966 Clay, John, of Hampton, smith 1
3856361 1975611 1975611 defendant Whetston Henry mariner 605966 605966 Whetston, Henry, of Hampton, mariner 0
3863493 1977987 1977987 plaintiff Huttoft Henry   605966 605966 Huttoft, Henry, of Hampton 0
3877830 1982829 1982829 plaintiff Jamys William   605966 605966 Jamys, William, of Hampton 0
3885085 1985272 1985272 defendant Gravell Thomas laborer 605966 605966 Gravell, Thomas, of Hampton, laborer 0
3885086 1985272 1985272 defendant Ball Richard husbandman 605966 605966 Ball, Richard, of Hampton, husbandman 1
3885087 1985272 1985272 defendant Gravell John laborer 605966 605966 Gravell, John, of Hampton, laborer 2
3885091 1985272 1985272 defendant Glasyer Hugh laborer 605966 605966 Glasyer, Hugh, of Hampton, laborer 6
3889945 1986873 1986873 defendant Fowle Thomas husbandman 605966 605966 Fowle, Thomas, of Hampton, husbandman 3
3919252 1996769 1996769 defendant Strynger William carrier 605966 605966 Strynger, William, of Hampton, carrier 2
3961559 2011142 2011142 defendant Daye John clothier 605966 605966 Daye, John, of Hampton, or of Strowd, Glos, clothier 0
3962868 2011605 2011605 defendant Skyrne Thomas husbandman 605966 605966 Skyrne, Thomas, of Hampton, husbandman 0
3997754 2023953 2023953 defendant Hamon Robert gent 605966 605966 Hamon, Robert, of Hampton, gent 1
4001378 2025271 2025271 plaintiff Hamon Robert yeoman 605966 605966 Hamon, Robert, of Hampton, yeoman 0
4003651 2026071 2026071 plaintiff Huband alias Hybbott John esq 605966 605966 Huband alias Hybbott, John, of Hampton, esq 0
4006112 2026957 2026957 defendant Kynne Thomas gent 605966 605966 Kynne, Thomas, of Hampton, gent 0
4006114 2026958 2026958 defendant Kynne Thomas gent 605966 605966 Kynne, Thomas, of Hampton, gent 0
4077563 2052266 2052266 defendant Edwardes William yeoman 605966 605966 Edwardes, William, of Hampton, yeoman 0
4127945 2070285 2070285 defendant Gyles Thomas yeoman 605966 605966 Gyles, Thomas, of Hampton, yeoman 0
4151182 2078538 2078538 defendant Gyles Thomas yeoman 605966 605966 Gyles, Thomas, of Hampton, yeoman 0
4199117 2095248 2095248 defendant ap Thomas Thomas husbandman 605966 605966 ap Thomas, Thomas, of Hampton, husbandman 1
4217874 2101741 2101741 defendant Wheler John yeoman 605966 605966 Wheler, John, of Hampton, yeoman 0
4327892 2139653 2139653 defendant Langston Edmund gent 605966 605966 Langston, Edmund, of Hampton, gent 0
4327893 2139653 2139653 defendant Newett Roger yeoman 605966 605966 Newett, Roger, of Hampton, yeoman 1
4369980 2154320 2154320 defendant Wellington Thomas yeoman 605966 605966 Wellington, Thomas, of Hampton, yeoman 0
4405062 2166269 2166269 defendant Stapleton Thomas husbandman 605966 605966 Stapleton, Thomas, of Hampton, husbandman 0
4412809 2168879 2168879 defendant Colcombe Edward yeoman 605966 605966 Colcombe, Edward, of Hampton, yeoman 2
4422650 2171938 2171938 plaintiff atte Welle Richard   605966 605966 atte Welle, Richard, of Hampton 5
4438956 2181475 2181475 defendant Bisshop Petronella   605966 605966 Bisshop, Petronella, of Hampton 0
4443103 2182804 2182804 defendant atte Bere John   605966 605966 atte Bere, John, of Hampton 3
4452943 2185928 2185928 plaintiff Kyngton Thomas de (legal representative) 605966 605966 Kyngton, Thomas de, of Hampton, burgess & gardian of the brotherhood of the minor order in Southampton, executors of 0
4452948 2185929 2185929 plaintiff Kyngton Thomas de (legal representative) 605966 605966 Kyngton, Thomas de, of Hampton, burgess & gardian of the brotherhood of the minor order in Southampton, executors of 0
4455832 2186839 2186839 defendant atte Bere John   605966 605966 atte Bere, John, of Hampton, burgess 0
4467634 2190554 2190554 defendant Clerk John (legal representative) 605966 605966 Clerk, John, of Hampton, mariner, executors of 0
4467636 2190555 2190555 plaintiff Bagge Thomas (legal representative) 605966 605966 Bagge, Thomas, of Hampton, merchant, executrix of 0
4467638 2190555 2190555 defendant Clerk John (legal representative) 605966 605966 Clerk, John, of Hampton, mariner, executor of 0
4474358 2192632 2192632 plaintiff Baget John   605966 605966 Baget, John, of Hampton 1
4474361 2192633 2192633 plaintiff Bagot John   605966 605966 Bagot, John, of Hampton 1
4481874 2195039 2195039 plaintiff Mapill William   605966 605966 Mapill, William, of Hampton 0
4490423 2197704 2197704 defendant Pyngiston John   605966 605966 Pyngiston, John, of Hampton 3
4491798 2198116 2198116 defendant Cartere John   605966 605966 Cartere, John, of Hampton 2
4505221 2202161 2202161 defendant Barker John   605966 605966 Barker, John, of Hampton 6
4511710 2204110 2204110 defendant Bakewall William   605966 605966 Bakewall, William, of Hampton 0
4511712 2204111 2204111 defendant Bakewall William   605966 605966 Bakewall, William, of Hampton 0
4530070 2209693 2209693 defendant Brasyer John   605966 605966 Brasyer, John, of Hampton 2
4540065 2212802 2212802 defendant Bagot John   605966 605966 Bagot, John, of Hampton 0
4541092 2213120 2213120 defendant Bagot John   605966 605966 Bagot, John, of Hampton 0
4569193 2221953 2221953 defendant Taillour Thomas   605966 605966 Taillour, Thomas, of Hampton 8
4569585 2222068 2222068 defendant Walsheman William   605966 605966 Walsheman, William, of Hampton 7
4578578 2224790 2224790 plaintiff Clyfford Richard   605966 605966 Clyfford, Richard, of Hampton, formerly parson of the church 0
4605540 2232852 2232852 plaintiff Armyner Thomas grocer 605966 605966 Armyner, Thomas, of Hampton, grocer 0
4618829 2236884 2236884 defendant Parker Michael   605966 605966 Parker, Michael, of Hampton 2
4622760 2238094 2238094 defendant Soper William   605966 605966 Soper, William, of Hampton 4
4628252 2239763 2239763 defendant Hewstere Robert   605966 605966 Hewstere, Robert, of Hampton 0
4628253 2239763 2239763 defendant Bron John   605966 605966 Bron, John, of Hampton 1
4653506 2247029 2247029 defendant Rygate John chapman 605966 605966 Rygate, John, of Hampton, chapman 3
4656765 2248009 2248009 defendant Smyth John   605966 605966 Smyth, John, of Hampton 1
4656766 2248009 2248009 defendant Jurdan Clement   605966 605966 Jurdan, Clement, of Hampton 2
4676901 2258394 2258394 defendant Marchall Henry (legal representative) 605966 605966 Marchall, Henry, of Hampton, administratrix of 2
4703972 2266619 2266619 defendant Charnebury John husbandman 605966 605966 Charnebury, John, of Hampton, husbandman 0
4707339 2267673 2267673 defendant Jurdon Clement husbandman 605966 605966 Jurdon, Clement, of Hampton, husbandman 0
4707343 2267674 2267674 defendant Leveson William gent 605966 605966 Leveson, William, of Hampton, gent 0
4707344 2267674 2267674 defendant Jurdon Clement yeoman 605966 605966 Jurdon, Clement, of Hampton, yeoman 1
4707345 2267674 2267674 defendant Pypard John chaplain 605966 605966 Pypard, John, of Hampton, chaplain 2
4707352 2267677 2267677 defendant Leueson William gent 605966 605966 Leueson, William, of Hampton, gent 0
4707353 2267677 2267677 defendant Jurdan Clement yeoman 605966 605966 Jurdan, Clement, of Hampton, yeoman 1
4707355 2267677 2267677 defendant Smyth John smith 605966 605966 Smyth, John, of Hampton, smith 3
4718207 2271034 2271034 plaintiff Averey John   605966 605966 Averey, John, of Hampton 0
4735406 2276217 2276217 defendant Spycer John spicer 605966 605966 Spycer, John, of Hampton, spicer 1
4738315 2277079 2277079 defendant Somer John butcher 605966 605966 Somer, John, of Hampton, butcher 1
4800183 2296232 2296232 plaintiff Wales Henry   605966 605966 Wales, Henry, of Hampton 0
4830906 2305692 2305692 plaintiff Botton alias Burton Robert (legal representative) 605966 605966 Botton alias Burton, Robert, of Hampton, merchant, executors of 0
4861118 2314836 2314836 plaintiff Cook William   605966 605966 Cook, William, of Hampton 0
4868931 2317256 2317256 defendant Compton John   605966 605966 Compton, John, of Hampton 0
4882394 2321405 2321405 plaintiff Michell Thomas clerk 605966 605966 Michell, Thomas, of Hampton, clerk 2
4883812 2321843 2321843 defendant Smyth Richard husbandman 605966 605966 Smyth, Richard, of Hampton under Dunmore, husbandman 2
4883813 2321843 2321843 defendant Richard son of Smyth Richard husbandman 605966 605966 Richard son of Smyth, Richard, of Hampton under Dunmore, husbandman 3
4955409 2343578 2343578 defendant Hare John smith 605966 605966 Hare, John, of Hampton, smith 0
4973489 2349017 2349017 defendant Hampton John   605966 605966 Hampton, John, of Hampton, mason 0
4997517 2356109 2356109 defendant Fyssher John husbandman 605966 605966 Fyssher, John, of Hampton, husbandman 1
5004745 2358291 2358291 defendant Warose Thomas chapman 605966 605966 Warose, Thomas, of Hampton, chapman 2
5074879 2378993 2378993 defendant Brown Richard fuller 605966 605966 Brown, Richard, of Hampton, fuller 1
5139218 2397962 2397962 defendant Dode or Bode William   605966 605966 Dode or Bode, William, of Hampton 0
5142568 2398954 2398954 defendant Hampton Richard husbandman 605966 605966 Hampton, Richard, of Hampton Waser, husbandman 0
5160115 2404059 2404059 defendant Dode William   605966 605966 Dode, William, of Hampton 0
5213025 2419547 2419547 defendant Edwardes John yeoman 605966 605966 Edwardes, John, of Hampton, yeoman 0
5213581 2419704 2419704 defendant Ede John husbandman 605966 605966 Ede, John, of Hampton, husbandman 0
5256773 2432241 2432241 plaintiff Kokette John yeoman 605966 605966 Kokette, John, of Hampton, yeoman 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);