names

60 rows where place_id = 611152

✎ 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
3687111 1922141 1922141 defendant Brokes John gent 611152 611152 Brokes, John, of Lytton, gent 0
3687113 1922142 1922142 defendant Brokes John gent 611152 611152 Brokes, John, of Lytton, gent 0
3778449 1950974 1950974 defendant Jamys Thomas husbandman 611152 611152 Jamys, Thomas, of Lytton, husbandman 1
3803961 1959154 1959154 defendant Bartlett John husbandman 611152 611152 (Bartlett, John, of Lytton, husbandman 1
3836178 1969228 1969228 defendant Newton Robert mercer 611152 611152 Newton, Robert, of Lytton, mercer 0
3900686 1990459 1990459 defendant Beke John gent 611152 611152 Beke, John, of Lytton, gent 0
3932942 2001306 2001306 defendant Clarke Robert husbandman 611152 611152 Clarke, Robert, of Lytton, husbandman 2
3972691 2015022 2015022 defendant Lytton William yeoman 611152 611152 Lytton, William, of Lytton, yeoman 2
3976080 2016202 2016202 defendant Prowt Edmund yeoman 611152 611152 Prowt, Edmund, of Lytton, yeoman 0
3981038 2017980 2017980 plaintiff Fawkener Henry yeoman 611152 611152 Fawkener, Henry, of Lytton, yeoman 2
3993494 2022417 2022417 defendant Grene William husbandman 611152 611152 Grene, William, of Lytton, husbandman 0
4018698 2031421 2031421 defendant Prowte Edmund yeoman 611152 611152 Prowte, Edmund, of Lytton, yeoman 0
4023152 2032993 2032993 defendant Eyre Ellen widow 611152 611152 Eyre, Ellen, of Lytton, widow 1
4023156 2032994 2032994 defendant Eyre Ellen widow 611152 611152 Eyre, Ellen, of Lytton, widow 1
4029483 2035180 2035180 defendant Buckett John husbandman 611152 611152 Buckett, John, of Lytton, husbandman 0
4042342 2039745 2039745 plaintiff Parker Thomas fuller 611152 611152 Parker, Thomas, of Lytton, fuller 0
4046077 2041036 2041036 plaintiff Shepard John husbandman 611152 611152 Shepard, John, of Lytton, husbandman 0
4046377 2041152 2041152 defendant Lytton William gent 611152 611152 Lytton, William, of Lytton, gent 0
4071896 2050249 2050249 defendant Lytton William gent 611152 611152 Lytton, William, of Lytton, gent 0
4071897 2050249 2050249 defendant Lytton Roland   611152 611152 Lytton, Roland, of Lytton, gent, his son 1
4078409 2052573 2052573 defendant Lytton William gent 611152 611152 Lytton, William, of Lytton, gent 0
4099946 2060306 2060306 defendant Lytton Roland   611152 611152 Lytton, Roland, of Lytton, gent, his son 1
4103704 2061599 2061599 defendant Lytton William, junior gent 611152 611152 Lytton, William, junior, of Lytton, gent 0
4225437 2104361 2104361 defendant Prestlye John husbandman 611152 611152 Prestlye, John, of Lytton, husbandman 1
4290164 2126550 2126550 defendant Fawkener Henry gent 611152 611152 Fawkener, Henry, of Lytton, gent 0
4294760 2128211 2128211 defendant Tymperley Roger miner 611152 611152 Tymperley, Roger, of Lytton, miner 3
4295985 2128663 2128663 defendant Clarke Richard husbandman 611152 611152 Clarke, Richard, of Lytton, husbandman 0
4308352 2133072 2133072 defendant Hurdynge John husbandman 611152 611152 Hurdynge, John, of Lytton, husbandman 1
4311350 2134116 2134116 defendant Lytton William gent 611152 611152 Lytton, William, of Lytton, gent 0
4360768 2151023 2151023 defendant Outfeld Robert husbandman 611152 611152 Outfeld, Robert, of Lytton, husbandman 2
4360769 2151023 2151023 defendant Hawkesworthe Peter husbandman 611152 611152 Hawkesworthe, Peter, of Lytton, husbandman 3
4360797 2151029 2151029 defendant Owtfeld Robert miner 611152 611152 Owtfeld, Robert, of Lytton, miner 1
4360798 2151029 2151029 defendant Owtfeld Edward miner 611152 611152 Owtfeld, Edward, of Lytton, miner 2
4360799 2151029 2151029 defendant Owtfeld Ralph miner 611152 611152 Owtfeld, Ralph, of Lytton, miner 3
4378424 2157356 2157356 defendant Outfeild or Oldfeld Elias miner 611152 611152 Outfeild or Oldfeld, Elias, of Lytton, husbandman, miner 3
4381721 2158564 2158564 defendant Heald John husbandman 611152 611152 Heald, John, of Lytton, husbandman 0
4385501 2159837 2159837 defendant Peake Elias miner 611152 611152 Peake, Elias, of Lytton, miner 1
4387575 2160482 2160482 defendant Owtefeld Elias husbandman 611152 611152 Owtefeld, Elias, of Lytton, husbandman 3
4471517 2191752 2191752 defendant Parkere Nicholas   611152 611152 Parkere, Nicholas, of Lytton 1
4520793 2206843 2206843 defendant Lytton John de   611152 611152 Lytton, John de, of Lytton 0
4532005 2210274 2210274 defendant Paddeley John   611152 611152 Paddeley, John, of Lytton 1
4551370 2216365 2216365 defendant Padley John   611152 611152 Padley, John, of Lytton 6
4580507 2225390 2225390 defendant del Croft John   611152 611152 del Croft, John, of Lytton 2
4629207 2240066 2240066 plaintiff Smyth John   611152 611152 Smyth, John, of Lytton 0
4686808 2261485 2261485 defendant Rodelane Robert clerk 611152 611152 Rodelane, Robert, of Lytton, clerk 0
4901305 2327018 2327018 defendant Payn James fletcher 611152 611152 Payn, James, of Lytton, fletcher 1
4991947 2354478 2354478 defendant Alyn Nicholas, sen husbandman 611152 611152 Alyn, Nicholas, sen, of Lytton, husbandman 9
5014283 2361030 2361030 defendant Derby John husbandman 611152 611152 Derby, John, of Lytton, husbandman 0
5097135 2385597 2385597 defendant Pyppyng Walter husbandman 611152 611152 Pyppyng, Walter, of Lytton, husbandman 0
5097137 2385598 2385598 defendant Pyppyng Walter husbandman 611152 611152 Pyppyng, Walter, of Lytton, husbandman 0
5127047 2394387 2394387 defendant Smyth Thomas smith 611152 611152 Smyth, Thomas, of Lytton, smith 0
5156287 2402992 2402992 defendant Pyppyng Walter husbandman 611152 611152 Pyppyng, Walter, of Lytton, husbandman 0
5240899 2427544 2427544 defendant Lake Richard husbandman 611152 611152 Lake, Richard, of Lytton, husbandman 0
5295607 2443705 2443705 defendant Combe Robert husbandman 611152 611152 Combe, Robert, of Lytton, husbandman 0
5408426 2477492 2477492 defendant Fyljoys Nicholas husbandman 611152 611152 Fyljoys, Nicholas, of Lytton, husbandman 0
5441270 2487304 2487304 defendant Saunders Thomas   611152 611152 Saunders, Thomas, of Lytton 2
5528799 2513530 2513530 defendant Takyll Thomas tailor 611152 611152 Takyll, Thomas, of Lytton, tailor 0
5583507 2529912 2529912 defendant Blakwall Henry laborer 611152 611152 Blakwall, Henry, of Lytton, laborer 2
5589677 2531769 2531769 defendant Pytman William husbandman 611152 611152 Pytman, William, of Lytton, husbandman 0
5617262 2549215 2549215 defendant Fythelere Robert   611152 611152 Fythelere, Robert, of Lytton 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);