names

51 rows where place_id = 594108

✎ 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
3614616 1872220 1872220 defendant Palmer Thomas miller 594108 594108 Palmer, Thomas, of Egefeld, miller 1
3671568 1917092 1917092 defendant Cuttyng Richard husbandman 594108 594108 Cuttyng, Richard, of Egefeld, husbandman 0
3671571 1917092 1917092 defendant Bacon Henry clerk 594108 594108 Bacon, Henry, of Egefeld, clerk 3
3672736 1917479 1917479 defendant Baker Henry clerk 594108 594108 Baker, Henry, of Egefeld, clerk 0
3677100 1918877 1918877 defendant Bakon Henry clerk 594108 594108 Bakon, Henry, of Egefeld, clerk 0
3687420 1922243 1922243 defendant Bacon Henry clerk 594108 594108 Bacon, Henry, of Egefeld, clerk 1
3687677 1922315 1922315 plaintiff Cokerell Henry husbandman 594108 594108 Cokerell, Henry, of Egefeld, husbandman 0
3687678 1922315 1922315 defendant Feke William hairman 594108 594108 Feke, William, of Egefeld, hairman 0
3703256 1927289 1927289 defendant Mathewe Robert chaplain 594108 594108 Mathewe, Robert, of Egefeld, chaplain 1
3705635 1928044 1928044 defendant Mathewe William husbandman 594108 594108 Mathewe, William, of Egefeld, husbandman 0
3712592 1930253 1930253 defendant Bakon Henry clerk 594108 594108 Bakon, Henry, of Egefeld, clerk 0
3720101 1932563 1932563 defendant Byntre Simon plumber 594108 594108 Byntre, Simon, of Egefeld, plumber 0
3720902 1932832 1932832 defendant Bacon Henry   594108 594108 Bacon, Henry, of Egefeld chaplain 0
3760818 1945387 1945387 defendant Bacon Henry clerk 594108 594108 Bacon, Henry, of Egefeld, clerk 0
3771946 1948918 1948918 defendant Hartystong William yeoman 594108 594108 Hartystong, William, of Egefeld, yeoman 3
3780730 1951707 1951707 defendant Mathewe Peter husbandman 594108 594108 Mathewe, Peter, of Egefeld, husbandman 0
3781900 1952087 1952087 plaintiff Hertstong William, senior   594108 594108 Hertstong, William, senior, of Egefeld 0
3781903 1952087 1952087 defendant Cuttyng Robert husbandman 594108 594108 Cuttyng, Robert, of Egefeld, husbandman 2
3798291 1957363 1957363 plaintiff Hartestong William yeoman 594108 594108 Hartestong, William, of Egefeld, yeoman 0
3798592 1957464 1957464 defendant Bakon Henry clerk 594108 594108 Bakon, Henry, of Egefeld, clerk 0
3798594 1957465 1957465 defendant Bakon Henry clerk 594108 594108 Bakon, Henry, of Egefeld, clerk 0
3815437 1962744 1962744 defendant Mathewe Peter husbandman 594108 594108 Mathewe, Peter, of Egefeld, husbandman 1
3826460 1966124 1966124 defendant Otewey Godwin (legal representative) 594108 594108 Otewey, Godwin, of Egefeld, executors of 1
3826461 1966124 1966124 defendant Ryngsted John tanner 594108 594108 (Ryngsted, John, of Egefeld, tanner 2
3827248 1966389 1966389 defendant Rynsted John tanner 594108 594108 Rynsted, John, of Egefeld, tanner 0
3827250 1966389 1966389 defendant Mathewe Peter husbandman 594108 594108 Mathewe, Peter, of Egefeld, husbandman 2
3834020 1968581 1968581 defendant Bakon Henry clerk 594108 594108 Bakon, Henry, of Egefeld, clerk 0
3854172 1974942 1974942 defendant Mathewe Peter husbandman 594108 594108 Mathewe, Peter, of Egefeld, husbandman 3
3861510 1977311 1977311 defendant Elward Roger clerk 594108 594108 Elward, Roger, of Egefeld, clerk 0
3866447 1979008 1979008 defendant Edmondys Simon husbandman 594108 594108 Edmondys, Simon, of Egefeld, husbandman 2
3910240 1993739 1993739 defendant Bacon Henry   594108 594108 Bacon, Henry, of Egefeld, parson of Thornwyche 0
3919427 1996828 1996828 defendant Mathewe William   594108 594108 Mathewe, William, of Egefeld, wool chapman 0
3967150 2013136 2013136 defendant Gavell Roger clerk 594108 594108 Gavell, Roger, of Egefeld, clerk 2
4147156 2077144 2077144 defendant Hawke Robert laborer 594108 594108 Hawke, Robert, of Egefeld, laborer 2
4590772 2228466 2228466 defendant Dickes John   594108 594108 Dickes, John, of Egefeld 0
4590773 2228466 2228466 defendant Colyns Thomas   594108 594108 Colyns, Thomas, of Egefeld 1
4707292 2267658 2267658 defendant Boteld William   594108 594108 Boteld, William, of Egefeld, pedlar 0
5045673 2370340 2370340 defendant Gaunte or Gaunce John smith 594108 594108 (Gaunte or Gaunce, John, of Egefeld, smith 1
5053409 2372625 2372625 defendant Sevenpens Thomas husbandman 594108 594108 Sevenpens, Thomas, of Egefeld, husbandman 0
5088609 2383044 2383044 defendant Sevynpens Thomas pedder 594108 594108 Sevynpens, Thomas, of Egefeld, pedder 1
5497226 2504108 2504108 defendant Palmer Thomas miller 594108 594108 Palmer, Thomas, of Egefeld, miller 1
5521652 2511587 2511587 defendant Dey Simon husbandman 594108 594108 Dey, Simon, of Egefeld, husbandman 3
5525922 2512700 2512700 defendant Eamis Peter husbandman 594108 594108 Eamis, Peter, of Egefeld, husbandman 0
5527402 2513152 2513152 defendant Abbys John husbandman 594108 594108 Abbys, John, of Egefeld, husbandman 0
5527403 2513152 2513152 defendant Cuttyng Robert husbandman 594108 594108 Cuttyng, Robert, of Egefeld, husbandman 1
5527404 2513152 2513152 defendant Cuttyng John husbandman 594108 594108 Cuttyng, John, of Egefeld, husbandman 2
5530325 2513996 2513996 defendant Mathewe Nicholas husbandman 594108 594108 (Mathewe, Nicholas, of Egefeld, husbandman 1
5549279 2519840 2519840 defendant Hobberd John husbandman 594108 594108 Hobberd, John, of Egefeld, husbandman 1
5585979 2530663 2530663 defendant Hoberd William husbandman 594108 594108 Hoberd, William, of Egefeld, husbandman 9
5599478 2534728 2534728 defendant Cokerell Henry thatcher 594108 594108 Cokerell, Henry, of Egefeld, thatcher 0
5601954 2535505 2535505 defendant Pers John husbandman 594108 594108 Pers, John, of Egefeld, husbandman 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);