names

50 rows where place_id = 586812

✎ 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
3589716 1864422 1864422 defendant Morgan John gent 586812 586812 Morgan, John, of St Lawrence, Isle of Thanet, gent 0
3589718 1864423 1864423 defendant Morgan Thomas gent 586812 586812 Morgan, Thomas, of St Lawrence, Isle of Thanet, gent 0
3606743 1869785 1869785 plaintiff Paulyn Roger   586812 586812 Paulyn, Roger, of St Lawrence, Isle of Thanet 0
3606761 1869789 1869789 plaintiff Pawlyn Roger yeoman 586812 586812 Pawlyn, Roger, of St Lawrence, Isle of Thanet, yeoman 0
3613829 1871980 1871980 defendant Noble Richard (legal representative) 586812 586812 Noble, Richard, of St Lawrence, Isle of Thanet, husbandman, executors of 5
3613830 1871980 1871980 defendant Curlyng William husbandman 586812 586812 (Curlyng, William, of St Lawrence, Isle of Thanet, husbandman 6
3634518 1905599 1905599 plaintiff Meycott John yeoman 586812 586812 Meycott, John, of St Lawrence, Isle of Thanet, yeoman 0
3639650 1907210 1907210 defendant Hyllys Nicholas gent 586812 586812 (Hyllys, Nicholas, of St Lawrence, Isle of Thanet, gent 1
3863878 1978092 1978092 defendant Barker Ralph   586812 586812 Barker, Ralph, of St Lawrence, Isle of Thanet 2
3877936 1982865 1982865 defendant Davy Gregory   586812 586812 Davy, Gregory, of St Lawrence, Isle of Thanet 0
3877939 1982866 1982866 defendant Davy Gregory   586812 586812 Davy, Gregory, of St Lawrence, Isle of Thanet 1
3980727 2017870 2017870 defendant Pyne Richard yeoman 586812 586812 Pyne, Richard, of St Lawrence, Isle of Thanet, yeoman 0
4029371 2035144 2035144 defendant Kyngsdowne John butcher 586812 586812 Kyngsdowne, John, of St Lawrence, Isle of Thanet, butcher 0
4191534 2092601 2092601 defendant Marshe John husbandman 586812 586812 Marshe, John, of St Lawrence, Isle of Thanet, husbandman 0
4345518 2145703 2145703 defendant Saunders Edward, junior yeoman 586812 586812 Saunders, Edward, junior, of St Lawrence, Isle of Thanet, yeoman 0
4378194 2157268 2157268 defendant Litherer Salomon yeoman 586812 586812 Litherer, Salomon, of St Lawrence, Isle of Thanet, yeoman 0
4669556 2256185 2256185 defendant Paulyn John husbandman 586812 586812 Paulyn, John, of St Lawrence, Isle of Thanet, husbandman 0
4832406 2306170 2306170 defendant Sandre John yeoman 586812 586812 Sandre, John, of St Lawrence, Isle of Thanet, yeoman 0
4907193 2328814 2328814 defendant Sandyr Robert yeoman 586812 586812 Sandyr, Robert, of St Lawrence, Isle of Thanet, yeoman 0
4980509 2351109 2351109 defendant Knoller John husbandman 586812 586812 Knoller, John, of St Lawrence, Isle of Thanet, husbandman 0
4980510 2351109 2351109 defendant Benet William husbandman 586812 586812 Benet, William, of St Lawrence, Isle of Thanet, husbandman 1
4980512 2351110 2351110 defendant Knoller John husbandman 586812 586812 Knoller, John, of St Lawrence, Isle of Thanet, husbandman 0
4980513 2351110 2351110 defendant Benet William husbandman 586812 586812 Benet, William, of St Lawrence, Isle of Thanet, husbandman 1
5011389 2360194 2360194 plaintiff White William   586812 586812 White, William, of St Lawrence, Isle of Thanet 0
5036571 2367559 2367559 defendant Houlot William husbandman 586812 586812 Houlot, William, of St Lawrence, Isle of Thanet, husbandman 0
5036573 2367560 2367560 defendant Houlot William husbandman 586812 586812 Houlot, William, of St Lawrence, Isle of Thanet, husbandman 0
5095188 2385008 2385008 defendant Panell William husbandman 586812 586812 Panell, William, of St Lawrence, Isle of Thanet, husbandman 1
5095189 2385008 2385008 defendant Panell John laborer 586812 586812 Panell, John, of St Lawrence, Isle of Thanet, laborer 2
5095190 2385008 2385008 defendant Panell Thomas laborer 586812 586812 Panell, Thomas, of St Lawrence, Isle of Thanet, laborer 3
5282028 2439815 2439815 defendant Harlewyn Thomas husbandman 586812 586812 Harlewyn, Thomas, of St Lawrence, Isle of Thanet, husbandman 3
5286129 2440950 2440950 defendant Oldberd Nicholas butcher 586812 586812 Oldberd, Nicholas, of St Lawrence, Isle of Thanet, butcher 4
5309823 2447977 2447977 defendant Thomelyn John husbandman 586812 586812 Thomelyn, John, of St Lawrence, Isle of Thanet, husbandman 0
5323489 2452103 2452103 defendant Shelley William laborer 586812 586812 Shelley, William, of St Lawrence, Isle of Thanet, laborer 1
5350360 2460234 2460234 defendant Ulbarn Nicholas   586812 586812 Ulbarn, Nicholas, of St Lawrence, Isle of Thanet 0
5350361 2460234 2460234 defendant Ulbarn John husbandman 586812 586812 Ulbarn, John, of St Lawrence, Isle of Thanet, husbandman 1
5351737 2460642 2460642 defendant Kynsey Richard cordwainer 586812 586812 Kynsey, Richard, of St Lawrence, Isle of Thanet, cordwainer 1
5417854 2480267 2480267 defendant Kyng Percival chaplain 586812 586812 Kyng, Percival, of St Lawrence, Isle of Thanet, chaplain 0
5466348 2494873 2494873 defendant Jurdan Thomas (legal representative) 586812 586812 Jurdan, Thomas, of St Lawrence, Isle of Thanet, yeoman, executors of 0
5466350 2494873 2494873 defendant Jurdan Alice   586812 586812 Jurdan, Alice, of St Lawrence, Isle of Thanet, widow, formerly wife of Thomas 2
5472747 2496817 2496817 defendant Kyng Thomas husbandman 586812 586812 Kyng, Thomas, of St Lawrence, Isle of Thanet, husbandman 0
5477660 2498337 2498337 defendant Jurdan Thomas (legal representative) 586812 586812 Jurdan, Thomas, of St Lawrence, Isle of Thanet, yeoman, executors of 0
5477664 2498338 2498338 defendant Tarrey Thomas yeoman 586812 586812 Tarrey, Thomas, of St Lawrence, Isle of Thanet, yeoman 0
5477665 2498338 2498338 defendant Tomlyn Robert husbandman 586812 586812 Tomlyn, Robert, of St Lawrence, Isle of Thanet, husbandman 1
5498255 2504434 2504434 defendant Theccher Stephen husbandman 586812 586812 Theccher, Stephen, of St Lawrence, Isle of Thanet, husbandman 1
5506408 2506914 2506914 defendant Morgan Thomas gent 586812 586812 Morgan, Thomas, of St Lawrence, Isle of Thanet, gent 0
5506409 2506914 2506914 defendant Morgan John gent 586812 586812 Morgan, John, of St Lawrence, Isle of Thanet, gent 1
5552270 2520709 2520709 defendant Dayman Wiliam gent 586812 586812 Dayman, Wiliam, of St Lawrence, Isle of Thanet, gent 0
5570301 2525879 2525879 defendant Meycotte John yeoman 586812 586812 Meycotte, John, of St Lawrence, Isle of Thanet, yeoman 0
5594951 2533392 2533392 defendant Morgan Thomas gent 586812 586812 Morgan, Thomas, of St Lawrence, Isle of Thanet, gent 1
5604606 2536301 2536301 defendant Morgan Thomas gent 586812 586812 Morgan, Thomas, of St Lawrence, Isle of Thanet, gent 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);