names

53 rows where place_id = 644453

✎ 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
3879740 1983480 1983480 defendant Baynard Robert yeoman 644453 644453 (Baynard, Robert, of Colne, yeoman 1
4117454 2066538 2066538 defendant Willise Henry yeoman 644453 644453 Willise, Henry, of Colne, yeoman 1
4123788 2068805 2068805 defendant Robynson John yeoman 644453 644453 Robynson, John, of Colne, or of Stanroyde, Lancs, yeoman 0
4265198 2117997 2117997 defendant Hill Richard yeoman 644453 644453 Hill, Richard, of Colne, yeoman 0
4301009 2130464 2130464 defendant Phillipson Richard husbandman 644453 644453 Phillipson, Richard, of Colne, husbandman 1
4308895 2133261 2133261 defendant Cranwell John yeoman 644453 644453 Cranwell, John, of Colne, yeoman 1
4341296 2144229 2144229 defendant Hartley James yeoman 644453 644453 Hartley, James, of Colne, or of Troden, Lancs, yeoman 1
4351050 2147621 2147621 defendant Phillipson Richard husbandman 644453 644453 Phillipson, Richard, of Colne, husbandman 2
4359973 2150731 2150731 defendant Harmar Edmund yeoman 644453 644453 Harmar, Edmund, of Colne, yeoman 0
4359974 2150731 2150731 defendant Haremar Edmund butcher 644453 644453 Haremar, Edmund, of Colne, butcher 1
4414974 2169576 2169576 plaintiff Foulere Henery le   644453 644453 Foulere, Henery le, of Colne 0
4463734 2189343 2189343 defendant Michel John   644453 644453 Michel, John, of Colne 0
4463740 2189344 2189344 defendant Michel John   644453 644453 Michel, John, of Colne 0
4465974 2190018 2190018 defendant Naffyngton Robert de brother in the priory 644453 644453 Naffyngton, Robert de, of Colne, brother in the priory 0
4479426 2194220 2194220 plaintiff Hyne or Hyve Henry   644453 644453 Hyne or Hyve, Henry, of Colne 0
4479442 2194227 2194227 plaintiff Hyve Henry   644453 644453 Hyve, Henry, of Colne 0
4521363 2207025 2207025 defendant Gerveys John   644453 644453 Gerveys, John, of Colne 1
4528034 2209049 2209049 defendant Blankepayn Hugh   644453 644453 Blankepayn, Hugh, of Colne 0
4534824 2211174 2211174 defendant Smyth Thomas   644453 644453 Smyth, Thomas, of Colne 1
4549677 2215832 2215832 defendant Preston John   644453 644453 Preston, John, of Colne, prior 0
4562413 2219803 2219803 defendant Debynham Roger   644453 644453 Debynham, Roger, of Colne 0
4596876 2230262 2230262 defendant Yong John tailor 644453 644453 Yong, John, of Colne, tailor 0
4646338 2244996 2244996 defendant Langton John   644453 644453 Langton, John, of Colne 0
4693173 2263367 2263367 plaintiff Barbour John   644453 644453 Barbour, John, of Colne 0
4713326 2269492 2269492 defendant Taillour Robert (legal representative) 644453 644453 Taillour, Robert, of Colne, executors of 4
4751545 2280937 2280937 plaintiff Bray John   644453 644453 Bray, John, of Colne 1
4814392 2300611 2300611 defendant Tatirsall Richard yeoman 644453 644453 Tatirsall, Richard, of Colne, yeoman 1
4901850 2327186 2327186 defendant Sampson John yeoman 644453 644453 Sampson, John, of Colne, yeoman 0
4951642 2342469 2342469 defendant Parker John yeoman 644453 644453 Parker, John, of Colne, yeoman 4
4973494 2349018 2349018 defendant Yonge Thomas chapman 644453 644453 Yonge, Thomas, of Colne, chapman 3
5078489 2380064 2380064 defendant Donnold John, junior yeoman 644453 644453 Donnold, John, junior, of Colne, yeoman 0
5078490 2380064 2380064 defendant Yon John husbandman 644453 644453 Yon, John, of Colne, husbandman 1
5078491 2380064 2380064 defendant Preston Thomas husbandman 644453 644453 Preston, Thomas, of Colne, husbandman 2
5078492 2380064 2380064 defendant Pidle Robert husbandman 644453 644453 Pidle, Robert, of Colne, husbandman 3
5078493 2380064 2380064 defendant Herte John husbandman 644453 644453 Herte, John, of Colne, husbandman 4
5078494 2380064 2380064 defendant Yon Robert husbandman 644453 644453 Yon, Robert, of Colne, husbandman 5
5078495 2380064 2380064 defendant Sampson Roger husbandman 644453 644453 Sampson, Roger, of Colne, husbandman 6
5078496 2380064 2380064 defendant Sampson William husbandman 644453 644453 Sampson, William, of Colne, husbandman 7
5078499 2380065 2380065 defendant Yon John husbandman 644453 644453 Yon, John, of Colne, husbandman 1
5078500 2380065 2380065 defendant Preston Thomas husbandman 644453 644453 Preston, Thomas, of Colne, husbandman 2
5078501 2380065 2380065 defendant Pidle Robert husbandman 644453 644453 Pidle, Robert, of Colne, husbandman 3
5078502 2380065 2380065 defendant Hert John husbandman 644453 644453 Hert, John, of Colne, husbandman 4
5078503 2380065 2380065 defendant Yon Robert husbandman 644453 644453 Yon, Robert, of Colne, husbandman 5
5078504 2380065 2380065 defendant Sampson Roger husbandman 644453 644453 Sampson, Roger, of Colne, husbandman 6
5078505 2380065 2380065 defendant Sampson William husbandman 644453 644453 Sampson, William, of Colne, husbandman 7
5231518 2424802 2424802 defendant Dunhol John gent 644453 644453 Dunhol, John, of Colne, gent 0
5346971 2459211 2459211 defendant Haregreves James shoemaker 644453 644453 Haregreves, James, of Colne, shoemaker 1
5346980 2459214 2459214 defendant Haregreves James shoemaker 644453 644453 Haregreves, James, of Colne, shoemaker 1
5375895 2468052 2468052 defendant Waslyn William smith 644453 644453 Waslyn, William, of Colne, smith 4
5555165 2521514 2521514 defendant Wryght John husbandman 644453 644453 Wryght, John, of Colne, husbandman 8
5555166 2521514 2521514 defendant Cokke John husbandman 644453 644453 Cokke, John, of Colne, husbandman 9
5555167 2521514 2521514 defendant Sampson Richard husbandman 644453 644453 Sampson, Richard, of Colne, husbandman 10
5630460 2553538 2553538 plaintiff Salvage John   644453 644453 Salvage, John, of Colne 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);