names

39 rows where place_id = 611010

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686330 1921882 1921882 defendant Lucas Richard chapman 611010 611010 Lucas, Richard, of Grymesby, Lincs, chapman 0
3926234 1999098 1999098 defendant Bellowe John esq 611010 611010 Bellowe, John, of Grymesby, Lincs, esq 0
4188370 2091435 2091435 defendant Sutlyff John gent 611010 611010 Sutlyff, John, of Grymesby, Lincs, gent 1
4342360 2144601 2144601 defendant Sutcliff John gent 611010 611010 Sutcliff, John, of Grymesby, Lincs, gent 3
4657178 2248131 2248131 defendant Bolyngton Robert gent 611010 611010 Bolyngton, Robert, of Grymesby, Lincs, gent 1
4657184 2248132 2248132 defendant Bolyngton Robert gent 611010 611010 Bolyngton, Robert, of Grymesby, Lincs, gent 1
4739507 2277440 2277440 defendant Norton William husbandman 611010 611010 Norton, William, of Grymesby, Lincs, husbandman 3
4822016 2302958 2302958 plaintiff See John del merchant 611010 611010 See, John del, of Grymesby, Lincs, merchant 0
4852375 2312164 2312164 defendant Granesby Roger merchant 611010 611010 Granesby, Roger, of Grymesby, Lincs, merchant 0
4865700 2316237 2316237 defendant Wysford John carpenter 611010 611010 Wysford, John, of Grymesby, Lincs, or of Kyrkeby, Essex, carpenter 0
4876258 2319535 2319535 defendant Graynesby John mariner 611010 611010 Graynesby, John, of Grymesby, Lincs, mariner 0
4895489 2325257 2325257 defendant Pye Robert chaplain 611010 611010 Pye, Robert, of Grymesby, Lincs, chaplain 0
4909652 2329548 2329548 defendant Ofranby John shipman 611010 611010 Ofranby, John, of Grymesby, Lincs, shipman 0
4923741 2333867 2333867 defendant Gaunt William mariner 611010 611010 Gaunt, William, of Grymesby, Lincs, mariner 1
4951466 2342419 2342419 defendant Pye Robert chaplain 611010 611010 Pye, Robert, of Grymesby, Lincs, chaplain 0
4953420 2342989 2342989 plaintiff Shildon John chapman 611010 611010 Shildon, John, of Grymesby, Lincs, chapman 0
5004564 2358235 2358235 defendant Graynesby John merchant 611010 611010 Graynesby, John, of Grymesby, Lincs, merchant 1
5004565 2358235 2358235 defendant Cokke John   611010 611010 Cokke, John, of Grymesby, Lincs, glove maker 2
5007783 2359171 2359171 defendant Graynesby John merchant 611010 611010 Graynesby, John, of Grymesby, Linc, merchant 0
5007786 2359172 2359172 defendant Graynesby John merchant 611010 611010 Graynesby, John, of Grymesby, Lincs, merchant 0
5036028 2367394 2367394 defendant Barnardeston Roger (legal representative) 611010 611010 Barnardeston, Roger, of Grymesby, Lincs, executors of 0
5063283 2375549 2375549 defendant Pye John fishmonger 611010 611010 Pye, John, of Grymesby, Lincs, fishmonger 0
5073790 2378648 2378648 defendant Chapman William chapman 611010 611010 Chapman, William, of Grymesby, Lincs, chapman 1
5076603 2379505 2379505 defendant Chapman William yeoman 611010 611010 Chapman, William, of Grymesby, Lincs, yeoman 0
5082867 2381380 2381380 defendant Cokke John glover 611010 611010 Cokke, John, of Grymesby, Lincs, glover 0
5083208 2381474 2381474 defendant Cokke John glover 611010 611010 Cokke, John, of Grymesby, Lincs, glover 0
5099110 2386167 2386167 defendant Deen John merchant 611010 611010 Deen, John, of Grymesby, Lincs, merchant 1
5141132 2398530 2398530 defendant Neweport John esq 611010 611010 Neweport, John, of Grymesby, lIncs, esq 0
5143674 2399284 2399284 plaintiff Asseby (illegible)   611010 611010 Asseby, _, of Grymesby, Lincs 0
5161690 2404524 2404524 defendant Neweport John esq 611010 611010 Neweport, John, of Grymesby, Lincs, esq 0
5191545 2413269 2413269 defendant Wethern Robert yeoman 611010 611010 Wethern, Robert, of Grymesby, Lincs, yeoman 0
5193895 2413939 2413939 defendant Salys Robert merchant 611010 611010 Salys, Robert, of Grymesby, Lincs, merchant 1
5193898 2413940 2413940 defendant Salys Robert merchant 611010 611010 Salys, Robert, of Grymesby, Lincs, merchant 1
5193901 2413941 2413941 defendant Salys Robert merchant 611010 611010 Salys, Robert, of Grymesby, Lincs, merchant 1
5208448 2418197 2418197 defendant Salys Robert merchant 611010 611010 Salys, Robert, of Grymesby, Lincs, merchant 1
5311054 2448336 2448336 defendant Watton Robert mariner 611010 611010 Watton, Robert, of Grymesby, Lincs, mariner 0
5314347 2449311 2449311 defendant Rynson alias Ryngestede Walter husbandman 611010 611010 Rynson alias Ryngestede, Walter, of Grymesby, Lincs, husbandman 0
5348482 2459666 2459666 defendant Metcaulffe Edmund merchant 611010 611010 Metcaulffe, Edmund, of Grymesby, Lincs, merchant 0
5362604 2463950 2463950 defendant Berkyng Richard chapman 611010 611010 Berkyng, Richard, of Grymesby, Lincs, chapman 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);