names

46 rows where place_id = 603062

✎ 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
3652932 1911244 1911244 defendant Nicolas Thomas yeoman 603062 603062 Nicolas, Thomas, of Estbourne, yeoman 0
3652933 1911244 1911244 defendant Mewe Simon yeoman 603062 603062 Mewe, Simon, of Estbourne, yeoman 1
3652934 1911244 1911244 defendant Bedyll John yeoman 603062 603062 Bedyll, John, of Estbourne, yeoman 2
3802332 1958628 1958628 defendant Mychelgrove Edward husbandman 603062 603062 Mychelgrove, Edward, of Estbourne, husbandman 0
3817042 1963242 1963242 defendant Russell John butcher 603062 603062 Russell, John, of Estbourne, butcher 0
3870959 1980539 1980539 defendant Hoo William clerk 603062 603062 Hoo, William, of Estbourne, clerk 0
4173984 2086358 2086358 defendant Butcher John yeoman 603062 603062 Butcher, John, of Estbourne, yeoman 0
4529099 2209377 2209377 defendant Pyk John   603062 603062 Pyk, John, of Estbourne 0
4585558 2226904 2226904 defendant Glover Walter   603062 603062 Glover, Walter, of Estbourne 0
4612613 2235011 2235011 defendant Taillour William   603062 603062 Taillour, William, of Estbourne 0
4651169 2246371 2246371 defendant Frankwell William husbandman 603062 603062 Frankwell, William, of Estbourne, husbandman 0
4651170 2246371 2246371 defendant Gardyner John butcher 603062 603062 Gardyner, John, of Estbourne, butcher 1
4665500 2250682 2250682 defendant See Richard fisher 603062 603062 See, Richard, of Estbourne, fisher 1
4671651 2256779 2256779 defendant Chaumberleyn John husbandman 603062 603062 Chaumberleyn, John, of Estbourne, husbandman 0
4790297 2293050 2293050 defendant Pays John shipman 603062 603062 Pays, John, of Estbourne, shipman 0
4843336 2309432 2309432 defendant atte Venell Henry husbandman 603062 603062 atte Venell, Henry, of Estbourne, husbandman 3
4861017 2314804 2314804 defendant atte Forde Richard smith 603062 603062 atte Forde, Richard, of Estbourne, smith 0
4866106 2316372 2316372 defendant Honynton alias Fyssher Geoffrey   603062 603062 Honynton alias Fyssher, Geoffrey, of Estbourne, ripiere or fishmonger 0
4874135 2318852 2318852 defendant Profot Thomas husbandman 603062 603062 Profot, Thomas, of Estbourne, husbandman 0
4874137 2318852 2318852 defendant Waleys John laborer 603062 603062 Waleys, John, of Estbourne, laborer 2
4894122 2324857 2324857 defendant atte Forde Richard smith 603062 603062 atte Forde, Richard, of Estbourne, smith 0
4925912 2334534 2334534 defendant Proset Thomas yeoman 603062 603062 Proset, Thomas, of Estbourne, yeoman 0
4934435 2337163 2337163 defendant Webbe John weaver 603062 603062 Webbe, John, of Estbourne, weaver 0
4934436 2337163 2337163 defendant Stokker John butcher 603062 603062 Stokker, John, of Estbourne, butcher 1
4951204 2342342 2342342 defendant Profot Thomas yeoman 603062 603062 Profot, Thomas, of Estbourne, yeoman 0
4951671 2342477 2342477 defendant Fenell or Fevell Simon husbandman 603062 603062 Fenell or Fevell, Simon, of Estbourne, husbandman 0
4956657 2343948 2343948 defendant Banastere Roger husbandman 603062 603062 Banastere, Roger, of Estbourne, husbandman 0
4968052 2347390 2347390 defendant Chersman John husbandman 603062 603062 Chersman, John, of Estbourne, husbandman 1
4981003 2351250 2351250 defendant Clerk Robert cordwainer 603062 603062 Clerk, Robert, of Estbourne, cordwainer 0
4981007 2351251 2351251 defendant Clerk Robert cordwainer 603062 603062 Clerk, Robert, of Estbourne, cordwainer 0
5017541 2362016 2362016 defendant atte Forde Richard husbandman 603062 603062 atte Forde, Richard, of Estbourne, husbandman 0
5024526 2364087 2364087 defendant atte Forde Richard husbandman 603062 603062 (atte Forde, Richard, of Estbourne, husbandman 1
5028320 2365163 2365163 defendant Quyk Robert rypyer or fishmonger 603062 603062 Quyk, Robert, of Estbourne, rypyer or fishmonger 1
5037569 2367862 2367862 defendant Shalston Richard gent 603062 603062 Shalston, Richard, of Estbourne, gent 0
5037570 2367862 2367862 defendant Profot Thomas husbandman 603062 603062 Profot, Thomas, of Estbourne, husbandman 1
5087284 2382662 2382662 defendant Forde Richard smith 603062 603062 Forde, Richard, of Estbourne, smith 0
5087285 2382662 2382662 defendant Budde John butcher 603062 603062 Budde, John, of Estbourne, butcher 1
5152514 2401872 2401872 defendant Burton John husbandman 603062 603062 Burton, John, of Estbourne, husbandman 0
5246174 2429041 2429041 defendant Wydger Richard laborer 603062 603062 Wydger, Richard, of Estbourne, laborer 0
5497056 2504057 2504057 defendant Fouler Henry yeoman 603062 603062 Fouler, Henry, of Estbourne, yeoman 0
5538673 2516577 2516577 defendant Peper Richard husbandman 603062 603062 Peper, Richard, of Estbourne, husbandman 3
5612815 2547765 2547765 plaintiff Claworth William   603062 603062 Claworth, William, of Estbourne 0
5627703 2552633 2552633 defendant Jan Simon shipman 603062 603062 Jan, Simon, of Estbourne, shipman 3
5636829 2555460 2555460 defendant Bedyll Walter yeoman 603062 603062 Bedyll, Walter, of Estbourne, yeoman 1
5636871 2555474 2555474 defendant Eyloff John husbandman 603062 603062 Eyloff, John, of Estbourne, husbandman 0
5636872 2555474 2555474 defendant Bedyll Walter yeoman 603062 603062 Bedyll, Walter, of Estbourne, yeoman 1

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