names

76 rows where place_id = 622259

✎ 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
3665644 1915204 1915204 defendant Arnold William   622259 622259 Arnold, William, of Aulton, inn holder 2
3746073 1940677 1940677 defendant Marson Lawrence mercer 622259 622259 Marson, Lawrence, of Aulton, mercer 1
3746074 1940677 1940677 defendant Galwey William mercer 622259 622259 Galwey, William, of Aulton, mercer 2
3762192 1945818 1945818 defendant Felder John clothier 622259 622259 Felder, John, of Aulton, clothier 5
3803475 1958990 1958990 defendant Dunnyng Edward   622259 622259 Dunnyng, Edward, of Aulton Westbroke, yailor 1
3991161 2021597 2021597 plaintiff Bowles Thomas   622259 622259 Bowles, Thomas, of Aulton 0
4005420 2026719 2026719 defendant Nelson John gent 622259 622259 Nelson, John, of Aulton, gent 1
4406608 2166775 2166775 defendant Cowper Thomas husbandman 622259 622259 Cowper, Thomas, of Aulton, or of Alpheton, husbandman 2
4419124 2170848 2170848 plaintiff atte Penne John   622259 622259 atte Penne, John, of Aulton 0
4419125 2170848 2170848 defendant Bolibet Richard   622259 622259 Bolibet, Richard, of Aulton 0
4426953 2173254 2173254 plaintiff Purchace John   622259 622259 Purchace, John, of Aulton 0
4426954 2173254 2173254 defendant Astal Walter   622259 622259 Astal, Walter, of Aulton 0
4426955 2173255 2173255 plaintiff Purchace John   622259 622259 Purchace, John, of Aulton 0
4435293 2175797 2175797 plaintiff Munk Robert de   622259 622259 Munk, Robert de, of Aulton 0
4435874 2175971 2175971 plaintiff Purchas John   622259 622259 Purchas, John, of Aulton 0
4435877 2175971 2175971 defendant Cumynges John   622259 622259 Cumynges, John, of Aulton 2
4435878 2175972 2175972 plaintiff Purchaz John   622259 622259 Purchaz, John, of Aulton 0
4435879 2175972 2175972 defendant Aftil Walter   622259 622259 Aftil, Walter, of Aulton 0
4435880 2175973 2175973 plaintiff Purchaz John   622259 622259 Purchaz, John, of Aulton 0
4435882 2175973 2175973 defendant Astil Walter   622259 622259 Astil, Walter, of Aulton 1
4479975 2194402 2194402 defendant Croklegg Henry   622259 622259 Croklegg, Henry, of Aulton 3
4480755 2194647 2194647 defendant Slater William   622259 622259 Slater, William, of Aulton 0
4489066 2197299 2197299 defendant Lynter William   622259 622259 Lynter, William, of Aulton 0
4491095 2197903 2197903 defendant Botewyll Thomas   622259 622259 Botewyll, Thomas, of Aulton 1
4509443 2203424 2203424 defendant atte Rode William smith 622259 622259 atte Rode, William, of Aulton, smith 0
4521158 2206954 2206954 defendant Broun John   622259 622259 Broun, John, of Aulton 0
4553340 2216979 2216979 defendant Parker William   622259 622259 Parker, William, of Aulton 0
4553559 2217044 2217044 defendant Boucher Robert   622259 622259 Boucher, Robert, of Aulton 0
4566676 2221152 2221152 plaintiff Sturmy William   622259 622259 Sturmy, William, of Aulton 0
4572663 2222989 2222989 plaintiff atte Rode William   622259 622259 atte Rode, William, of Aulton 0
4573305 2223184 2223184 defendant Smyth Richard   622259 622259 Smyth, Richard, of Aulton 1
4578773 2224848 2224848 defendant Sherwyn John   622259 622259 Sherwyn, John, of Aulton 0
4596988 2230301 2230301 defendant Chuandeler Adam   622259 622259 Chuandeler, Adam, of Aulton 0
4599384 2231023 2231023 plaintiff Sturmy William   622259 622259 Sturmy, William, of Aulton 0
4617728 2236545 2236545 defendant Porter Robert   622259 622259 Porter, Robert, of Aulton 0
4628957 2239987 2239987 defendant Boucher John   622259 622259 Boucher, John, of Aulton, son of Robert 3
4632276 2240983 2240983 defendant Basset Walter   622259 622259 Basset, Walter, of Aulton 0
4634301 2241572 2241572 defendant Lovelay Walter   622259 622259 Lovelay, Walter, of Aulton Berner 0
4639572 2243087 2243087 plaintiff Couper John   622259 622259 Couper, John, of Aulton 0
4639573 2243087 2243087 defendant Glover John   622259 622259 Glover, John, of Aulton 0
4655213 2247515 2247515 defendant Palmere William smith 622259 622259 Palmere, William, of Aulton, smith 0
4656893 2248052 2248052 defendant Wolf Richard   622259 622259 Wolf, Richard, of Aulton 7
4662602 2249772 2249772 defendant Knyght William clerk 622259 622259 Knyght, William, of Aulton, clerk 2
4668885 2255969 2255969 defendant Astill William   622259 622259 Astill, William, of Aulton, bailiff 0
4689219 2262187 2262187 defendant Palmere John smith 622259 622259 Palmere, John, of Aulton, smith 0
4698029 2264872 2264872 defendant Bregge Robert husbandman 622259 622259 Bregge, Robert, of Aulton, husbandman 2
4735551 2276268 2276268 defendant Swyndon Thomas   622259 622259 Swyndon, Thomas, of Aulton, Hants, auditor 0
4771167 2286965 2286965 defendant Symond Thomas   622259 622259 Symond, Thomas, of Aulton, shepherd 0
4780740 2289976 2289976 defendant Rouncevale Thomas hosteler 622259 622259 Rouncevale, Thomas, of Aulton, hosteler 0
4836013 2307245 2307245 plaintiff Dyghere Stephen merchant 622259 622259 Dyghere, Stephen, of Aulton, merchant 0
4836328 2307338 2307338 defendant Milward William   622259 622259 Milward, William, of Aulton, mill ward 0
4863398 2315522 2315522 plaintiff Dygher Stephen merchant 622259 622259 Dygher, Stephen, of Aulton, merchant 0
4872305 2318298 2318298 defendant Holwey John hosteler 622259 622259 Holwey, John, of Aulton, hosteler 0
4873888 2318774 2318774 defendant Hake John chapman 622259 622259 Hake, John, of Aulton, chapman 0
4902342 2327343 2327343 defendant Notull John   622259 622259 Notull, John, of Aulton, bailiff 0
4927102 2334910 2334910 defendant Notull John   622259 622259 Notull, John, of Aulton, bailiff 0
4942760 2339707 2339707 plaintiff Frye Richard   622259 622259 Frye, Richard, of Aulton 0
4978524 2350527 2350527 defendant Notull John   622259 622259 Notull, John, of Aulton, bailiff 0
4986583 2352915 2352915 defendant Stoke Robert husbandman 622259 622259 Stoke, Robert, of Aulton, husbandman 2
5013430 2360764 2360764 defendant Frye Roger baker 622259 622259 Frye, Roger, of Aulton, baker 0
5027736 2364990 2364990 plaintiff May Thomas   622259 622259 May, Thomas, of Aulton 0
5036716 2367609 2367609 defendant Sumner Reginald summoner 622259 622259 Sumner, Reginald, of Aulton, summoner 0
5037562 2367861 2367861 plaintiff Wodecok John   622259 622259 Wodecok, John, of Aulton 0
5071011 2377819 2377819 defendant Chamberleyn Thomas gent 622259 622259 Chamberleyn, Thomas, of Aulton, gent 0
5073303 2378504 2378504 defendant atte Mille Ralph   622259 622259 atte Mille, Ralph, of Aulton, or of Gretham, Hants, millward 3
5097998 2385845 2385845 defendant Balchyld David draper 622259 622259 Balchyld, David, of Aulton, draper 1
5179243 2409669 2409669 plaintiff Bentley Thomas   622259 622259 Bentley, Thomas, of Aulton 0
5315441 2449680 2449680 defendant Barbour John yeoman 622259 622259 Barbour, John, of Aulton, yeoman 0
5453152 2490826 2490826 plaintiff W_ Edward   622259 622259 W_, Edward, of Aulton 0
5529083 2513612 2513612 defendant Arnold William yeoman 622259 622259 Arnold, William, of Aulton, yeoman 5
5611261 2547252 2547252 defendant Bayllyf Richard   622259 622259 Bayllyf, Richard, of Aulton Berner 1
5611262 2547252 2547252 defendant Gylot Nicholas Berner 622259 622259 Gylot, Nicholas, of Aulton, Berner 2
5611265 2547252 2547252 defendant Edward John   622259 622259 Edward, John, of Aulton Berner 5
5626335 2552199 2552199 defendant Dyer Thomas ostler 622259 622259 Dyer, Thomas, of Aulton, ostler 0
5627169 2552462 2552462 defendant Dyer Thomas hosteler 622259 622259 Dyer, Thomas, of Aulton, hosteler 2
5636217 2555285 2555285 plaintiff Wollane William, junior   622259 622259 Wollane, William, junior, of Aulton 0

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);