names

30 rows where place_id = 589312

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597192 1866746 1866746 plaintiff Reed Thomas (legal representative) 589312 589312 Reed, Thomas, of Southfeld, executors of 0
3597195 1866746 1866746 defendant Suffeld alias Tebald Robert yeoman 589312 589312 Suffeld alias Tebald, Robert, of Southfeld, yeoman 0
3720362 1932647 1932647 plaintiff Howes Thomas   589312 589312 Howes, Thomas, of Southfeld 0
3816503 1963066 1963066 plaintiff Howes Thomas husbandman 589312 589312 Howes, Thomas, of Southfeld, husbandman 0
4225678 2104445 2104445 defendant Dellfe Robert miller 589312 589312 Dellfe, Robert, of Southfeld, miller 0
4468053 2190678 2190678 defendant Reed Thomas   589312 589312 Reed, Thomas, of Southfeld 0
4512628 2204381 2204381 defendant Pocok John   589312 589312 Pocok, John, of Southfeld 0
4526038 2208439 2208439 defendant Bengemyn Henry   589312 589312 Bengemyn, Henry, of Southfeld 0
4620038 2237250 2237250 defendant Rede Thomas   589312 589312 Rede, Thomas, of Southfeld 2
4636849 2242342 2242342 defendant Bemamyn or Beniamyn Henry   589312 589312 Bemamyn or Beniamyn, Henry, of Southfeld 0
4653557 2247045 2247045 defendant Reed Thomas butcher 589312 589312 Reed, Thomas, of Southfeld, butcher 0
4684894 2260869 2260869 defendant Heyword Robert   589312 589312 Heyword, Robert, of Southfeld 2
4708498 2268026 2268026 defendant Payn Thomas yeoman 589312 589312 Payn, Thomas, of Southfeld, yeoman 1
4708499 2268026 2268026 defendant symondes John husbandman 589312 589312 symondes, John, of Southfeld, husbandman 2
4710914 2268769 2268769 defendant Reed Thomas butcher 589312 589312 Reed, Thomas, of Southfeld, butcher 0
4730517 2274744 2274744 defendant Spycer Stephen yeoman 589312 589312 Spycer, Stephen, of Southfeld, yeoman 0
4740105 2277623 2277623 defendant Boyden Robert butcher 589312 589312 Boyden, Robert, of Southfeld, butcher 3
4740106 2277623 2277623 defendant Boydon John butcher 589312 589312 Boydon, John, of Southfeld, butcher 4
4857165 2313625 2313625 defendant Howes William husbandman 589312 589312 Howes, William, of Southfeld, husbandman 0
4902544 2327414 2327414 defendant Tebald John yeoman 589312 589312 Tebald, John, of Southfeld, yeoman 0
5014802 2361204 2361204 plaintiff Betynes William   589312 589312 Betynes, William, of Southfeld 0
5014803 2361204 2361204 defendant Howes William husbandman 589312 589312 Howes, William, of Southfeld, husbandman 0
5254447 2431514 2431514 defendant Worme John yeoman 589312 589312 Worme, John, of Southfeld, yeoman 3
5268416 2435888 2435888 defendant Fyssher Richard husbandman 589312 589312 Fyssher, Richard, of Southfeld, husbandman 3
5365756 2464946 2464946 defendant Suffeld alais Teobald Robert yeoman 589312 589312 Suffeld alais Teobald, Robert, of Southfeld, yeoman 1
5377793 2468638 2468638 plaintiff Symmes Nicholas   589312 589312 Symmes, Nicholas, of Southfeld 0
5408208 2477429 2477429 defendant Symmes Thomas husbandman 589312 589312 Symmes, Thomas, of Southfeld, husbandman 5
5496134 2503741 2503741 plaintiff Howes Edward   589312 589312 Howes, Edward, of Southfeld 0
5532636 2514753 2514753 defendant Broun Robert husbandman 589312 589312 Broun, Robert, of Southfeld, husbandman 1
5629988 2553380 2553380 defendant Reed Thomas butcher 589312 589312 Reed, Thomas, of Southfeld, butcher 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);