names

60 rows where place_id = 594064

✎ 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
3614426 1872161 1872161 defendant Digges John esq 594064 594064 Digges, John, of Barham, esq 0
3637619 1906576 1906576 defendant Pykard John husbandman 594064 594064 Pykard, John, of Barham, husbandman 0
3668161 1915988 1915988 defendant Laurence William husbandman 594064 594064 Laurence, William, of Barham, husbandman 1
3669364 1916355 1916355 defendant Woderowe Robert husbandman 594064 594064 Woderowe, Robert, of Barham, husbandman 4
3671391 1917029 1917029 defendant Foldyngton John husbandman 594064 594064 Foldyngton, John, of Barham, husbandman 0
3695503 1924815 1924815 defendant Julle Nicholas husbandman 594064 594064 Julle, Nicholas, of Barham, husbandman 0
3732569 1936416 1936416 defendant Damme Robert gent 594064 594064 Damme, Robert, of Barham, gent 0
3778717 1951059 1951059 defendant Elyott Thomas yeoman 594064 594064 Elyott, Thomas, of Barham, yeoman 3
3778725 1951061 1951061 defendant Ellyott Thomas yeoman 594064 594064 Ellyott, Thomas, of Barham, yeoman 3
3797497 1957108 1957108 defendant Cloke Richard husbandman 594064 594064 Cloke, Richard, of Barham, husbandman 0
3813397 1962106 1962106 defendant Wykham John laborer 594064 594064 Wykham, John, of Barham, laborer 0
3813398 1962106 1962106 defendant Joe John laborer 594064 594064 Joe, John, of Barham, laborer 1
3813399 1962106 1962106 defendant Tooke Stephen laborer 594064 594064 Tooke, Stephen, of Barham, laborer 2
3820852 1964413 1964413 defendant Reynold Lionel husbandman 594064 594064 Reynold, Lionel, of Barham, husbandman 0
3874648 1981738 1981738 defendant Danyell Geoffrey yeoman 594064 594064 Danyell, Geoffrey, of Barham, yeoman 0
3876751 1982467 1982467 defendant Cocke John yeoman 594064 594064 Cocke, John, of Barham, yeoman 2
3901507 1990728 1990728 defendant Boot John husbandman 594064 594064 Boot, John, of Barham, husbandman 0
3945168 2005405 2005405 plaintiff Blomefeld William   594064 594064 Blomefeld, William, of Barham 0
3966601 2012954 2012954 defendant Seriaunt Richard carpenter 594064 594064 Seriaunt, Richard, of Barham, carpenter 1
3999446 2024565 2024565 defendant Dygg Christopher esq 594064 594064 Dygg, Christopher, of Barham, esq 0
4045674 2040905 2040905 defendant Awood Leonard glover 594064 594064 Awood, Leonard, of Barham, glover 2
4045679 2040906 2040906 defendant Awood Leonard glover 594064 594064 Awood, Leonard, of Barham, glover 2
4077063 2052082 2052082 defendant Barker Robert carpenter 594064 594064 Barker, Robert, of Barham, carpenter 2
4127805 2070233 2070233 defendant Royley William yeoman 594064 594064 Royley, William, of Barham, yeoman 1
4127806 2070233 2070233 defendant Bellamye Richard husbandman 594064 594064 Bellamye, Richard, of Barham, husbandman 2
4140802 2074947 2074947 defendant Cloke Thomas yeoman 594064 594064 Cloke, Thomas, of Barham, yeoman 0
4145373 2076542 2076542 defendant Fright William husbandman 594064 594064 Fright, William, of Barham, husbandman 0
4145379 2076543 2076543 defendant Scott Thomas smith 594064 594064 Scott, Thomas, of Barham, smith 0
4145380 2076543 2076543 defendant Allen Alice spinster 594064 594064 Allen, Alice, of Barham, spinster 1
4145381 2076543 2076543 defendant Shore Elizabeth spinster 594064 594064 Shore, Elizabeth, of Barham, spinster 2
4145382 2076543 2076543 defendant Guldeford Elizabeth spinster 594064 594064 Guldeford, Elizabeth, of Barham, spinster 3
4145383 2076543 2076543 defendant Kecherell Katherine spinster 594064 594064 Kecherell, Katherine, of Barham, spinster 4
4275908 2121522 2121522 defendant Harington Robert gent 594064 594064 Harington, Robert, of Barham, gent 0
4301566 2130665 2130665 defendant Andrewes Thomas yeoman 594064 594064 Andrewes, Thomas, of Barham, yeoman 3
4306892 2132552 2132552 defendant Andrewes Thomas yeoman 594064 594064 Andrewes, Thomas, of Barham, yeoman 0
4339973 2143757 2143757 defendant Carlill Jonathan gent 594064 594064 Carlill, Jonathan, of Barham, gent 0
4359373 2150512 2150512 defendant Sympson John husbandman 594064 594064 Sympson, John, of Barham, husbandman 0
4359375 2150513 2150513 defendant Ricard Francis husbandman 594064 594064 Ricard, Francis, of Barham, husbandman 0
4368400 2153743 2153743 defendant Cullen Thomas yeoman 594064 594064 Cullen, Thomas, of Barham, or of Breeche, yeoman 0
4390415 2161414 2161414 defendant Ives Richard yeoman 594064 594064 Ives, Richard, of Barham, yeoman 3
4413077 2168961 2168961 defendant Bakele John le   594064 594064 Bakele, John le, of Barham, son of Simon 0
4519192 2206356 2206356 plaintiff Dygge John   594064 594064 Dygge, John, of Barham 0
4519193 2206356 2206356 plaintiff Lynch John   594064 594064 Lynch, John, of Barham 1
4577462 2224467 2224467 defendant Gylys Henry   594064 594064 Gylys, Henry, of Barham 2
4577464 2224467 2224467 defendant Lynche John   594064 594064 Lynche, John, of Barham 4
4696672 2264434 2264434 defendant Flesshware John husbandman 594064 594064 Flesshware, John, of Barham, husbandman 4
4698372 2264969 2264969 defendant Tely Walter   594064 594064 Tely, Walter, of Barham 0
4706193 2267314 2267314 defendant Tely Walter   594064 594064 Tely, Walter, of Barham 0
4730958 2274882 2274882 defendant Baker Walter baker 594064 594064 Baker, Walter, of Barham, baker 0
4848210 2310911 2310911 defendant atte Gate William butcher 594064 594064 atte Gate, William, of Barham, butcher 3
4996233 2355729 2355729 defendant Baker Richard yeoman 594064 594064 Baker, Richard, of Barham, yeoman 0
4996235 2355729 2355729 defendant Baker John smith 594064 594064 Baker, John, of Barham, smith 2
4997391 2356069 2356069 defendant Swetey John butcher 594064 594064 Swetey, John, of Barham, butcher 3
5308010 2447413 2447413 defendant C_ Robert husbandman 594064 594064 C_, Robert, of Barham, husbandman 0
5316527 2450027 2450027 plaintiff Digges John esq 594064 594064 Digges, John, of Barham, esq 0
5316763 2450100 2450100 defendant Baker John, junior laborer 594064 594064 Baker, John, junior, of Barham, laborer 0
5316764 2450100 2450100 defendant Tayllour Michael tailor 594064 594064 Tayllour, Michael, of Barham, tailor 1
5322816 2451905 2451905 defendant Pronere or Provere John husbandman 594064 594064 Pronere or Provere, John, of Barham, husbandman 1
5464912 2494420 2494420 defendant Knecchebole William husbandman 594064 594064 Knecchebole, William, of Barham, husbandman 1
5510130 2508003 2508003 defendant Smethe Thomas smith 594064 594064 Smethe, Thomas, of Barham, smith 4

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