names

35 rows where place_id = 589563

✎ 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
3598004 1866999 1866999 defendant Wakefeld William husbandman 589563 589563 Wakefeld, William, of Radwell, husbandman 1
3601973 1868274 1868274 defendant Ketyll Henry clerk 589563 589563 Ketyll, Henry, of Radwell, clerk 0
3631378 1904624 1904624 defendant Fermour William husbandman 589563 589563 Fermour, William, of Radwell, husbandman 3
3664046 1914704 1914704 defendant Cosyn William husbandman 589563 589563 Cosyn, William, of Radwell, husbandman 0
3673439 1917713 1917713 defendant Tappe John husbandman 589563 589563 Tappe, John, of Radwell, husbandman 3
3700954 1926547 1926547 defendant Tappe John husbandman 589563 589563 Tappe, John, of Radwell, husbandman 0
3700955 1926547 1926547 defendant Cosyn William husbandman 589563 589563 Cosyn, William, of Radwell, husbandman 1
4043343 2040086 2040086 defendant Tokefeyld Benedict husbandman 589563 589563 Tokefeyld, Benedict, of Radwell, husbandman 0
4043344 2040086 2040086 defendant Lylly Thomas husbandman 589563 589563 Lylly, Thomas, of Radwell, husbandman 1
4048803 2042020 2042020 plaintiff Tokefeylde Benedict yeoman 589563 589563 Tokefeylde, Benedict, of Radwell, yeoman 0
4075075 2051387 2051387 defendant Freman Thomas miller 589563 589563 Freman, Thomas, of Radwell, miller 1
4228938 2105602 2105602 defendant Rand Thomas gent 589563 589563 Rand, Thomas, of Radwell, gent 0
4378526 2157392 2157392 defendant Berrye John husbandman 589563 589563 Berrye, John, of Radwell, husbandman 0
4613805 2235334 2235334 defendant Tappe John   589563 589563 Tappe, John, of Radwell 3
4613806 2235334 2235334 defendant Gery John   589563 589563 Gery, John, of Radwell 4
4613811 2235335 2235335 defendant Grendon William   589563 589563 Grendon, William, of Radwell 0
4613813 2235335 2235335 defendant Arundell William   589563 589563 Arundell, William, of Radwell 2
4613814 2235335 2235335 defendant Kyng Richard   589563 589563 Kyng, Richard, of Radwell 3
4613815 2235335 2235335 defendant Cof_ John   589563 589563 Cof_, John, of Radwell 4
4626373 2239200 2239200 defendant Arundell William   589563 589563 Arundell, William, of Radwell 1
4626374 2239200 2239200 defendant Fynden Richard   589563 589563 Fynden, Richard, of Radwell 2
4656665 2247980 2247980 defendant Smyth William husbandman 589563 589563 Smyth, William, of Radwell, husbandman 0
4661977 2249586 2249586 defendant Arundell William tailor 589563 589563 Arundell, William, of Radwell, tailor 0
4710274 2268567 2268567 defendant Smyth William husbandman 589563 589563 Smyth, William, of Radwell, husbandman 0
4714866 2269983 2269983 defendant Thynden John husbandman 589563 589563 Thynden, John, of Radwell, husbandman 3
4774192 2287909 2287909 defendant Thyngden John husbandman 589563 589563 Thyngden, John, of Radwell, husbandman 4
4799193 2295928 2295928 defendant Thynden John husbandman 589563 589563 Thynden, John, of Radwell, husbandman 0
4799194 2295928 2295928 defendant Arundell William tailor 589563 589563 Arundell, William, of Radwell, tailor 1
4817377 2301520 2301520 defendant Brey John husbandman 589563 589563 Brey, John, of Radwell, husbandman 3
4817378 2301520 2301520 defendant More Lawrence   589563 589563 More, Lawrence, of Radwell, wright 4
4905247 2328237 2328237 defendant Tappe John husbandman 589563 589563 Tappe, John, of Radwell, husbandman 3
4905248 2328237 2328237 defendant Tappe Simon husbandman 589563 589563 Tappe, Simon, of Radwell, husbandman 4
4962710 2345753 2345753 defendant Edward William butcher 589563 589563 Edward, William, of Radwell, butcher 0
5218813 2421228 2421228 defendant Ronell or Rovell Hugh laborer 589563 589563 Ronell or Rovell, Hugh, of Radwell, laborer 2
5509235 2507745 2507745 defendant Wakefeld William husbandman 589563 589563 Wakefeld, William, of Radwell, husbandman 3

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