names

39 rows where place_id = 609036

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676674 1918744 1918744 defendant Baker Thomas, junior butcher 609036 609036 Baker, Thomas, junior, of West Hanyngfeld, butcher 0
3796081 1956637 1956637 defendant Wade Robert husbandman 609036 609036 Wade, Robert, of West Hanyngfeld, husbandman 0
3796082 1956637 1956637 defendant Walker Thomas husbandman 609036 609036 Walker, Thomas, of West Hanyngfeld, husbandman 1
3803667 1959064 1959064 defendant Baker Thomas yeoman 609036 609036 Baker, Thomas, of West Hanyngfeld, yeoman 0
3807336 1960196 1960196 defendant Baker Thomas husbandman 609036 609036 Baker, Thomas, of West Hanyngfeld, husbandman 1
3821053 1964478 1964478 defendant Baker Thomas yeoman 609036 609036 Baker, Thomas, of West Hanyngfeld, yeoman 0
3822352 1964897 1964897 defendant Baker Thomas husbandman 609036 609036 Baker, Thomas, of West Hanyngfeld, husbandman 1
3835109 1968920 1968920 defendant Baker Thomas yeoman 609036 609036 Baker, Thomas, of West Hanyngfeld, yeoman 0
3838882 1970089 1970089 defendant Clovell Edward gent 609036 609036 Clovell, Edward, of West Hanyngfeld, gent 0
3838884 1970089 1970089 defendant Thurstell Nicholas yeoman 609036 609036 Thurstell, Nicholas, of West Hanyngfeld, yeoman 2
3838885 1970089 1970089 defendant Kyrkby Robert laborer 609036 609036 Kyrkby, Robert, of West Hanyngfeld, laborer 3
3885836 1985517 1985517 defendant Baker Thomas yeoman 609036 609036 Baker, Thomas, of West Hanyngfeld, yeoman 0
3944383 2005132 2005132 defendant Strutt Benedict carpenter 609036 609036 Strutt, Benedict, of West Hanyngfeld, carpenter 0
4555561 2217669 2217669 defendant Stovve Simon   609036 609036 Stovve, Simon, of West Hanyngfeld 1
4561903 2219656 2219656 defendant Nighteld John   609036 609036 Nighteld, John, of West Hanyngfeld 0
4601947 2231832 2231832 defendant Baron John   609036 609036 Baron, John, of West Hanyngfeld 7
4607115 2233341 2233341 plaintiff Beauchamp William   609036 609036 Beauchamp, William, of West Hanyngfeld 0
4622308 2237957 2237957 defendant Wyse Richard   609036 609036 Wyse, Richard, of West Hanyngfeld 0
4622309 2237957 2237957 defendant Scotte John   609036 609036 Scotte, John, of West Hanyngfeld 1
4696880 2264505 2264505 defendant Bode Geoffrey husbandman 609036 609036 Bode, Geoffrey, of West Hanyngfeld, husbandman 0
4716157 2270363 2270363 defendant Meller John   609036 609036 Meller, John, of West Hanyngfeld, glove maker 0
4726800 2273653 2273653 defendant Gilberd Lawrence yeoman 609036 609036 Gilberd, Lawrence, of West Hanyngfeld, yeoman 2
4754754 2281870 2281870 defendant Helman Thomas husbandman 609036 609036 Helman, Thomas, of West Hanyngfeld, husbandman 1
4838096 2307838 2307838 defendant Holman William fisherman 609036 609036 Holman, William, of West Hanyngfeld, fisherman 0
4909434 2329490 2329490 defendant Orvell Thomas husbandman 609036 609036 Orvell, Thomas, of West Hanyngfeld, husbandman 0
5016616 2361753 2361753 defendant Tanner William drover 609036 609036 Tanner, William, of West Hanyngfeld, drover 2
5016622 2361754 2361754 defendant Tanner William drover 609036 609036 Tanner, William, of West Hanyngfeld, drover 2
5087994 2382863 2382863 defendant Gylbert John husbandman 609036 609036 Gylbert, John, of West Hanyngfeld, husbandman 1
5255100 2431707 2431707 defendant Akastre Robert chaplain 609036 609036 Akastre, Robert, of West Hanyngfeld, chaplain 0
5257609 2432499 2432499 defendant Kent Henry drover 609036 609036 Kent, Henry, of West Hanyngfeld, drover 1
5313071 2448942 2448942 defendant Kent Henry drover 609036 609036 Kent, Henry, of West Hanyngfeld, drover 0
5313075 2448943 2448943 defendant Kent Henry drover 609036 609036 Kent, Henry, of West Hanyngfeld, drover 0
5315184 2449596 2449596 defendant Bencham or Beucham Margaret widow 609036 609036 Bencham or Beucham, Margaret, of West Hanyngfeld, widow 0
5342067 2457710 2457710 defendant Wyse Thomas husbandman 609036 609036 Wyse, Thomas, of West Hanyngfeld, husbandman 0
5397728 2474421 2474421 defendant Demp Stephen husbandman 609036 609036 Demp, Stephen, of West Hanyngfeld, husbandman Grey, Geoffrey, of Buttesbury, husbandman 3
5425020 2482449 2482449 defendant Kempe Stephen husbandman 609036 609036 Kempe, Stephen, of West Hanyngfeld, husbandman 3
5425024 2482450 2482450 defendant Kempe Stephen husbandman 609036 609036 Kempe, Stephen, of West Hanyngfeld, husbandman 1
5628688 2552942 2552942 defendant Neyghebour Roger husbandman 609036 609036 Neyghebour, Roger, of West Hanyngfeld, husbandman 1
5635298 2555005 2555005 defendant Throstle Richard drover 609036 609036 Throstle, Richard, of West Hanyngfeld, drover 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);