names

47 rows where place_id = 593392

✎ 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
3611624 1871305 1871305 defendant Lyverey John husbandman 593392 593392 Lyverey, John, of St Nicholas, Isle of Thanet, husbandman 0
3690162 1923080 1923080 defendant Clyfton Richard yeoman 593392 593392 Clyfton, Richard, of St Nicholas, Isle of Thanet, yeoman 1
3791413 1955151 1955151 defendant Morton John butcher 593392 593392 Morton, John, of St Nicholas, Isle of Thanet, butcher 0
3802328 1958626 1958626 defendant Lyon Thomas husbandman 593392 593392 Lyon, Thomas, of St Nicholas, Isle of Thanet, husbandman 1
3863876 1978092 1978092 defendant Davye Gregory husbandman 593392 593392 Davye, Gregory, of St Nicholas, Isle of Thanet, husbandman 0
4006846 2027227 2027227 plaintiff Lowes William   593392 593392 Lowes, William, of St Nicholas, Isle of Thanet 0
4083236 2054294 2054294 defendant Norwood John yeoman 593392 593392 Norwood, John, of St Nicholas, Isle of Thanet, yeoman, son of William Norwood, of St Nicholas, Isle of Thanet, yeoman 0
4313036 2134682 2134682 defendant Paramore Henry gent 593392 593392 Paramore, Henry, of St Nicholas, Isle of Thanet, gent 1
4670247 2256401 2256401 defendant Broun John husbandman 593392 593392 Broun, John, of St Nicholas, Isle of Thanet, husbandman 0
4677103 2258455 2258455 defendant Bollok John thatcher 593392 593392 Bollok, John, of St Nicholas, Isle of Thanet, thatcher 0
4683778 2260534 2260534 defendant Broun John husbandman 593392 593392 Broun, John, of St Nicholas, Isle of Thanet, husbandman 0
4736062 2276419 2276419 defendant Excetre John esq 593392 593392 Excetre, John, of St Nicholas, Isle of Thanet, esq 0
4829682 2305330 2305330 defendant Scalon Thomas husbandman 593392 593392 Scalon, Thomas, of St Nicholas, Isle of Thanet, husbandman 0
4859810 2314437 2314437 defendant Hamon William husbandman 593392 593392 Hamon, William, of St Nicholas, Isle of Thanet, husbandman 1
4861413 2314940 2314940 defendant Edmond William yeoman 593392 593392 Edmond, William, of St Nicholas, Isle of Thanet, yeoman 0
4877540 2319933 2319933 defendant Besewyk John husbandman 593392 593392 Besewyk, John, of St Nicholas, Isle of Thanet, husbandman 0
4877541 2319933 2319933 defendant Dele Thomas husbandman 593392 593392 Dele, Thomas, of St Nicholas, Isle of Thanet, husbandman 1
4884740 2322130 2322130 plaintiff Salesbery Thomas (legal representative) 593392 593392 Salesbery, Thomas, of St Nicholas, Isle of Thanet, executors of 0
4900240 2326704 2326704 defendant Aleyn John husbandman 593392 593392 Aleyn, John, of St Nicholas, Isle of Thanet, husbandman 0
4906864 2328732 2328732 defendant Dorset William gent 593392 593392 Dorset, William, of St Nicholas, Isle of Thanet, gent 0
4907036 2328777 2328777 defendant Lillesden Robert husbandman 593392 593392 Lillesden, Robert, of St Nicholas, Isle of Thanet, husbandman 1
4942332 2339589 2339589 defendant Tredegold John miller 593392 593392 Tredegold, John, of St Nicholas, Isle of Thanet, miller 0
4967996 2347372 2347372 defendant Blythe John   593392 593392 Blythe, John, of St Nicholas, Isle of Thanet, holy water clerk 0
4967997 2347372 2347372 defendant Hayne Walter husbandman 593392 593392 Hayne, Walter, of St Nicholas, Isle of Thanet, husbandman 1
4980352 2351067 2351067 defendant Chaumbre William husbandman 593392 593392 Chaumbre, William, of St Nicholas, Isle of Thanet, husbandman 2
5001009 2357173 2357173 defendant Blachynden John husbandman 593392 593392 Blachynden, John, of St Nicholas, Isle of Thanet, husbandman 1
5005393 2358478 2358478 defendant Forstall John yeoman 593392 593392 Forstall, John, of St Nicholas, isle of Thanet, yeoman 0
5012082 2360381 2360381 defendant Larker William butcher 593392 593392 Larker, William, of St Nicholas, Isle of Thanet, butcher 2
5047729 2370937 2370937 defendant Chirche John husbandman 593392 593392 Chirche, John, of St Nicholas, Isle of Thanet, husbandman 0
5047731 2370937 2370937 defendant Thornton John husbandman 593392 593392 Thornton, John, of St Nicholas, Isle of Thanet, husbandman 2
5063904 2375737 2375737 defendant Canteys Thomas husbandman 593392 593392 Canteys, Thomas, of St Nicholas, Isle of Thanet, husbandman 0
5063905 2375737 2375737 defendant Chirche John husbandman 593392 593392 Chirche, John, of St Nicholas, Isle of Thanet, husbandman 1
5083906 2381688 2381688 defendant Sandewey John gent 593392 593392 Sandewey, John, of St Nicholas, Isle of Thanet, gent 0
5104754 2387828 2387828 defendant Forstall John yeoman 593392 593392 Forstall, John, of St Nicholas, Isle of Thanet, yeoman 0
5108927 2389031 2389031 defendant Thornton Robert husbandman 593392 593392 Thornton, Robert, of St Nicholas, Isle of Thanet, husbandman 3
5178375 2409383 2409383 defendant Thorneton Robert laborer 593392 593392 Thorneton, Robert, of St Nicholas, Isle of Thanet, laborer 0
5193984 2413974 2413974 defendant Sandeway John esq 593392 593392 Sandeway, John, of St Nicholas, Isle of Thanet, esq 0
5193986 2413975 2413975 defendant Sandeway John esq 593392 593392 Sandeway, John, of St Nicholas, Isle of Thanet, esq 0
5208481 2418211 2418211 defendant Sandeway John esq 593392 593392 Sandeway, John, of St Nicholas, Isle of Thanet, esq 0
5208483 2418212 2418212 defendant Sandeway John esq 593392 593392 Sandeway, John, of St Nicholas, Isle of Thanet, esq 0
5220567 2421711 2421711 defendant Sandeway John gent 593392 593392 Sandeway, John, of St Nicholas, Isle of Thanet, gent 0
5319428 2450903 2450903 defendant Horwell John butcher 593392 593392 Horwell, John, of St Nicholas, Isle of Thanet, butcher 1
5330283 2454131 2454131 defendant Carlys John husbandman 593392 593392 Carlys, John, of St Nicholas, Isle of Thanet, husbandman 3
5330288 2454132 2454132 defendant Carlys John husbandman 593392 593392 Carlys, John, of St Nicholas, Isle of Thanet, husbandman 3
5342424 2457826 2457826 defendant Haket John laborer 593392 593392 Haket, John, of St Nicholas, Isle of Thanet, laborer 0
5442688 2487726 2487726 defendant Andrewe John yeoman 593392 593392 Andrewe, John, of St Nicholas, Isle of Thanet, yeoman 2
5467006 2495078 2495078 defendant Forstall Thomas husbandman 593392 593392 Forstall, Thomas, of St Nicholas, Isle of Thanet, husbandman 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);