names

50 rows where place_id = 591282

✎ 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
3603936 1868901 1868901 plaintiff Alysawndyr John   591282 591282 Alysawndyr, John, of Bishops Lynne 3
3629143 1903986 1903986 defendant Bull Richard merchant 591282 591282 Bull, Richard, of Bishops Lynne, merchant 1
3747422 1941108 1941108 defendant Elmham John clerk 591282 591282 Elmham, John, of Bishops Lynne, clerk 0
3783374 1952549 1952549 defendant Wyllyson John painter 591282 591282 Wyllyson, John, of Bishops Lynne, painter 2
3790822 1954956 1954956 plaintiff White Robert merchant 591282 591282 White, Robert, of Bishops Lynne, merchant 0
3819650 1964026 1964026 plaintiff Overende William   591282 591282 Overende, William, of Bishops Lynne 0
3864651 1978376 1978376 defendant Coo Christopher esq 591282 591282 Coo, Christopher, of Bishops Lynne, esq 0
3864653 1978377 1978377 defendant Coo Christopher esq 591282 591282 Coo, Christopher, of Bishops Lynne, esq 0
4875581 2319320 2319320 defendant Mullysworth William chapman 591282 591282 Mullysworth, William, of Bishops Lynne, chapman 1
4889738 2323585 2323585 defendant Robynesson William waterman 591282 591282 Robynesson, William, of Bishops Lynne, waterman 1
4890297 2323733 2323733 defendant Magg Edmund merchant 591282 591282 Magg, Edmund, of Bishops Lynne, merchant 0
4890298 2323733 2323733 defendant Childe John merchant 591282 591282 Childe, John, of Bishops Lynne, merchant 1
4890558 2323806 2323806 plaintiff Spycer Thomas merchant 591282 591282 Spycer, Thomas, of Bishops Lynne, merchant 0
4890559 2323806 2323806 plaintiff Costyn or Coscyn William merchant 591282 591282 Costyn or Coscyn, William, of Bishops Lynne, merchant 1
4890825 2323879 2323879 plaintiff Spycer Thomas merchant 591282 591282 Spycer, Thomas, of Bishops Lynne, merchant 0
4890826 2323879 2323879 plaintiff Costyn or Coscyn William merchant 591282 591282 Costyn or Coscyn, William, of Bishops Lynne, merchant 1
4890827 2323879 2323879 defendant Cook William merchant 591282 591282 Cook, William, of Bishops Lynne, merchant 0
4893077 2324553 2324553 defendant Botelesham John merchant 591282 591282 Botelesham, John, of Bishops Lynne, merchant 0
4901073 2326962 2326962 defendant Neuman Nicholas husbandman 591282 591282 Neuman, Nicholas, of Bishops Lynne, husbandman 0
4902348 2327346 2327346 defendant Tylneye Robert merchant 591282 591282 Tylneye, Robert, of Bishops Lynne, merchant 0
4902349 2327346 2327346 defendant Wythe William, junior merchant 591282 591282 Wythe, William, junior, of Bishops Lynne, merchant 1
4902350 2327346 2327346 defendant Steylle William merchant 591282 591282 Steylle, William, of Bishops Lynne, merchant 2
4905995 2328476 2328476 defendant Kyrkestede Edmund brewer 591282 591282 Kyrkestede, Edmund, of Bishops Lynne, brewer 0
4906113 2328505 2328505 defendant Whithe William, junior merchant 591282 591282 Whithe, William, junior, of Bishops Lynne, merchant 0
4938469 2338409 2338409 defendant Mullesworth William merchant 591282 591282 Mullesworth, William, of Bishops Lynne, merchant 0
4939011 2338593 2338593 defendant Westhorp Richard merchant 591282 591282 Westhorp, Richard, of Bishops Lynne, merchant 0
4942339 2339592 2339592 defendant Mullerworth William merchant 591282 591282 Mullerworth, William, of Bishops Lynne, merchant 0
4943518 2339941 2339941 defendant Westhorp Richard merchant 591282 591282 Westhorp, Richard, of Bishops Lynne, merchant 0
4946767 2340991 2340991 plaintiff Kyrton William merchant 591282 591282 Kyrton, William, of Bishops Lynne, merchant 0
4946768 2340991 2340991 plaintiff Croysse Hugh merchant 591282 591282 Croysse, Hugh, of Bishops Lynne, merchant 1
4966655 2346961 2346961 defendant Costyn William merchant 591282 591282 Costyn, William, of Bishops Lynne, merchant 0
4966656 2346961 2346961 defendant Neweman William merchant 591282 591282 Neweman, William, of Bishops Lynne, merchant 1
5017674 2362046 2362046 plaintiff Chumseux Thomas merchant 591282 591282 Chumseux, Thomas, of Bishops Lynne, merchant 0
5017675 2362046 2362046 plaintiff Sonneman John merchant 591282 591282 Sonneman, John, of Bishops Lynne, merchant 1
5020756 2362968 2362968 defendant Mullesworth William merchant 591282 591282 Mullesworth, William, of Bishops Lynne, merchant 4
5075990 2379312 2379312 defendant Wythe Margaret widow 591282 591282 (Wythe, Margaret, of Bishops Lynne, widow 1
5075991 2379312 2379312 defendant Mollesworth William merchant 591282 591282 Mollesworth, William, of Bishops Lynne, merchant 2
5117077 2391422 2391422 defendant Baxter Richard brewer 591282 591282 Baxter, Richard, of Bishops Lynne, brewer 0
5225365 2423091 2423091 defendant Johnson Frederic husbandman 591282 591282 Johnson, Frederic, of Bishops Lynne, husbandman 0
5228431 2423920 2423920 defendant Hard William merchant 591282 591282 Hard, William, of Bishops Lynne, merchant 3
5230959 2424663 2424663 defendant Benet John barber 591282 591282 Benet, John, of Bishops Lynne, barber 0
5483955 2500137 2500137 defendant Ade John yeoman 591282 591282 Ade, John, of Bishops Lynne, yeoman 3
5508961 2507658 2507658 defendant Chyrche John bowyer 591282 591282 Chyrche, John, of Bishops Lynne, bowyer 0
5514332 2509332 2509332 defendant Salter Ralph yeoman 591282 591282 Salter, Ralph, of Bishops Lynne, yeoman 0
5528880 2513553 2513553 defendant Smmyth Andrew merchant 591282 591282 Smmyth, Andrew, of Bishops Lynne, merchant 4
5528881 2513553 2513553 defendant Westerfeld Edmund chapman 591282 591282 Westerfeld, Edmund, of Bishops Lynne, chapman 5
5532965 2514853 2514853 defendant Smyth Andrew chapman 591282 591282 Smyth, Andrew, of Bishops Lynne, chapman 0
5559495 2522740 2522740 defendant Bastard Richard merchant 591282 591282 Bastard, Richard, of Bishops Lynne, merchant 0
5589644 2531757 2531757 defendant Bastard Richard merchant 591282 591282 Bastard, Richard, of Bishops Lynne, merchant 0
5590640 2532043 2532043 plaintiff Soome John (legal representative) 591282 591282 Soome, John, of Bishops Lynne, mercer, executor of 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);