names

45 rows where place_id = 664071

✎ 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
3971293 2014517 2014517 plaintiff Edge Godfrey yeoman 664071 664071 Edge, Godfrey, of High Holborne, Middx, yeoman 0
3994224 2022688 2022688 plaintiff Clyff Elizabeth (legal representative) 664071 664071 Clyff, Elizabeth, of High Holborne, Middx, or of Tateridge, widow, administrator of 0
3999165 2024460 2024460 plaintiff Freman Elizabeth (legal representative) 664071 664071 Freman, Elizabeth, of High Holborne, Middx, widow, executrix of Thomas Freman, of St Andrew in Holborne, Middx, gent, attorney of the bench, executor of 0
3999172 2024461 2024461 plaintiff Freman Elizabeth (legal representative) 664071 664071 Freman, Elizabeth, of High Holborne, Middx, widow, executrix of Thomas Freman, of St Andrew in Holborne, Middx, gent, attorney of the bench, executor of 0
3999180 2024462 2024462 plaintiff Freman Elizabeth (legal representative) 664071 664071 Freman, Elizabeth, of High Holborne, Middx, widow, executrix of Thomas Freman, of St Andrew in Holborne, Middx, gent, attorney of the bench, executor of 0
4011181 2028769 2028769 plaintiff Pery William tailor 664071 664071 Pery, William, of High Holborne, Middx, tailor 0
4011183 2028770 2028770 plaintiff Pery William tailor 664071 664071 Pery, William, of High Holborne, Middx, tailor 0
4017046 2030801 2030801 plaintiff Talbot John brickmaker 664071 664071 Talbot, John, of High Holborne, Middx, brickmaker 0
4027900 2034630 2034630 plaintiff Coke James (legal representative) 664071 664071 Coke, James, of High Holborne, Middx, yeoman, executors of 0
4048794 2042016 2042016 plaintiff Tisdale Thomas innholder 664071 664071 Tisdale, Thomas, of High Holborne, Middx, innholder 0
4049374 2042222 2042222 plaintiff Turtill or Turkell Roger tailor 664071 664071 Turtill or Turkell, Roger, of High Holborne, Middx, tailor 0
4049379 2042223 2042223 plaintiff Turtill Roger tailor 664071 664071 Turtill, Roger, of High Holborne, Middx, tailor 0
4072374 2050423 2050423 plaintiff Owen Richard tailor 664071 664071 Owen, Richard, of High Holborne, Middx, tailor 0
4072376 2050424 2050424 plaintiff Owen Richard tailor 664071 664071 Owen, Richard, of High Holborne, Middx, tailor 0
4079567 2052990 2052990 plaintiff Turkell Roger tailor 664071 664071 Turkell, Roger, of High Holborne, Middx, tailor 0
4085472 2055081 2055081 defendant Nickson John innholder 664071 664071 Nickson, John, of High Holborne, Middx, innholder 2
4097973 2059604 2059604 defendant Morrys Henry tailor 664071 664071 Morrys, Henry, of High Holborne, Middx, tailor 0
4146460 2076913 2076913 defendant Fytton George gent 664071 664071 Fytton, George, of High Holborne, Middx, gent 0
4167552 2084145 2084145 defendant Grove John gent 664071 664071 Grove, John, of High Holborne, Middx, gent 0
4184599 2090123 2090123 defendant Grislinge John gent 664071 664071 Grislinge, John, of High Holborne, Middx, gent 0
4188937 2091613 2091613 defendant Grove John gent 664071 664071 Grove, John, of High Holborne, Middx, gent 0
4204193 2097017 2097017 defendant Best Edward mercer 664071 664071 Best, Edward, of High Holborne, Middx, brewer, or of London, mercer 0
4206864 2097942 2097942 defendant Tysdale Thomas innholder 664071 664071 Tysdale, Thomas, of High Holborne, Middx, innholder 0
4239242 2109349 2109349 defendant Sturgys Thomas tailor 664071 664071 Sturgys, Thomas, of High Holborne, Middx, tailor 0
4244297 2111079 2111079 defendant Morrice Henry tailor 664071 664071 Morrice, Henry, of High Holborne, Middx, tailor 3
4252104 2113694 2113694 defendant Gyttyns Joan widow 664071 664071 Gyttyns, Joan, of High Holborne, Middx, widow 2
4252112 2113695 2113695 defendant Gyttyns Joan widow 664071 664071 Gyttyns, Joan, of High Holborne, Middx, widow 4
4255492 2114829 2114829 defendant Morrice Henry tailor 664071 664071 Morrice, Henry, of High Holborne, Middx, tailor 3
4262657 2117180 2117180 defendant Cartwright Edmund tailor 664071 664071 Cartwright, Edmund, of High Holborne, Middx, tailor 2
4264561 2117791 2117791 defendant Pigott Lewis gent 664071 664071 Pigott, Lewis, of High Holborne, Middx, gent 1
4273331 2120643 2120643 defendant Cartwright Edmund tailor 664071 664071 Cartwright, Edmund, of High Holborne, Middx, tailor 2
4297197 2129100 2129100 defendant Mestrell Francis tailor 664071 664071 Mestrell, Francis, of High Holborne, Middx, tailor 0
4305984 2132231 2132231 defendant Warde Nicholas baker 664071 664071 Warde, Nicholas, of High Holborne, Middx, baker 3
4316313 2135820 2135820 defendant Piggott Griffin innholder 664071 664071 Piggott, Griffin, of High Holborne, Middx, innholder 0
4330435 2140478 2140478 defendant Grymshawe William tailor 664071 664071 Grymshawe, William, of High Holborne, Middx, tailor 2
4331576 2140857 2140857 defendant Dikers William fletcher 664071 664071 Dikers, William, of High Holborne, Middx, fletcher 0
4344872 2145485 2145485 defendant Bease or Beaste Ralph (legal representative) 664071 664071 Bease or Beaste, Ralph, of High Holborne, Middx, butcher, executrix of 0
4346137 2145902 2145902 defendant Sherman Thomas victualer 664071 664071 Sherman, Thomas, of High Holborne, Middx, victualer 2
4369860 2154275 2154275 defendant Sherman Thomas victualer 664071 664071 Sherman, Thomas, of High Holborne, Middx, victualer 2
4391589 2161800 2161800 defendant Eryth Richard gent 664071 664071 Eryth, Richard, of High Holborne, Middx, gent 0
4392730 2162187 2162187 defendant Greasted Thomas yeoman 664071 664071 Greasted, Thomas, of High Holborne, Middx, yeoman 1
4394421 2162731 2162731 defendant Pattison Henry yeoman 664071 664071 Pattison, Henry, of High Holborne, Middx, yeoman 1
4397099 2163598 2163598 defendant Mestrell Francis tailor 664071 664071 Mestrell, Francis, of High Holborne, Middx, tailor 0
4402410 2165394 2165394 defendant Wrighte Ambrose tailor 664071 664071 Wrighte, Ambrose, of High Holborne, Middx, tailor 0
4408260 2167332 2167332 defendant Felton or Feltney Robert victualer 664071 664071 Felton or Feltney, Robert, of High Holborne, Middx, victualer 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);