names

49 rows where place_id = 593852

✎ 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
3613598 1871899 1871899 defendant Pygge John husbandman 593852 593852 Pygge, John, of Wysbech, Cams, husbandman 1
3673133 1917608 1917608 defendant Gotys John innholder 593852 593852 Gotys, John, of Wysbech, Cams, innholder 0
3757720 1944396 1944396 defendant Dennys John tailor 593852 593852 Dennys, John, of Wysbech, Cams, tailor 1
4779914 2289718 2289718 defendant Jowele William yeoman 593852 593852 Jowele, William, of Wysbech, Cams, yeoman 0
4791470 2293425 2293425 defendant Fuster William husbandman 593852 593852 Fuster, William, of Wysbech, Cams, husbandman 0
4888113 2323087 2323087 defendant Awebell Ralph cooper 593852 593852 Awebell, Ralph, of Wysbech, Cams, cooper 3
4889756 2323590 2323590 defendant Hiptoft Thomas gent 593852 593852 Hiptoft, Thomas, of Wysbech, Cams, gent 0
4892743 2324454 2324454 defendant Lyly John chaplain 593852 593852 (Lyly, John, of Wysbech, Cams, chaplain 1
4955612 2343644 2343644 defendant Keep John brewer 593852 593852 Keep, John, of Wysbech, Cams, brewer 0
4957941 2344344 2344344 defendant Hunt William butcher 593852 593852 Hunt, William, of Wysbech, Cams, butcher 0
5021327 2363144 2363144 defendant Grey Geoffrey gent 593852 593852 Grey, Geoffrey, of Wysbech, Cams, gent 0
5037479 2367832 2367832 defendant Lambe Thomas husbandman 593852 593852 Lambe, Thomas, of Wysbech, Cams, husbandman 2
5059363 2374369 2374369 defendant Brasier William yeoman 593852 593852 Brasier, William, of Wysbech, Cams, yeoman 0
5069608 2377407 2377407 defendant Prykke John husbandman 593852 593852 Prykke, John, of Wysbech, Cams, husbandman 2
5080878 2380773 2380773 defendant Brasyer William butcher 593852 593852 Brasyer, William, of Wysbech, Cams, butcher 0
5087844 2382826 2382826 defendant Prest John, senior yeoman 593852 593852 Prest, John, senior, of Wysbech, Cams, yeoman 0
5093743 2384568 2384568 defendant Brasyer William butcher 593852 593852 Brasyer, William, of Wysbech, Cams, butcher 0
5100710 2386633 2386633 defendant Grey Robert yeoman 593852 593852 Grey, Robert, of Wysbech, Cams, yeoman 2
5102191 2387063 2387063 defendant Bunch William husbandman 593852 593852 Bunch, William, of Wysbech, Cams, husbandman 5
5111057 2389623 2389623 defendant Fraunceys Simon butcher 593852 593852 Fraunceys, Simon, of Wysbech, Cams, butcher 11
5119337 2392079 2392079 defendant Allard Thomas yeoman 593852 593852 Allard, Thomas, of Wysbech, Cams, yeoman 0
5227015 2423554 2423554 defendant Wolle Alice widow 593852 593852 Wolle, Alice, of Wysbech, Cams, widow 0
5234429 2425660 2425660 defendant Otesson William grocer 593852 593852 Otesson, William, of Wysbech, Cams, grocer 1
5236331 2426216 2426216 plaintiff Ely Simon chapman 593852 593852 Ely, Simon, of Wysbech, Cams, chapman 0
5236813 2426351 2426351 defendant Sorell John gent 593852 593852 Sorell, John, of Wysbech, Cams, gent 0
5236892 2426373 2426373 defendant Stoker Edward tailor 593852 593852 Stoker, Edward, of Wysbech, Cams, tailor 2
5241022 2427575 2427575 defendant Eliot Robert barker 593852 593852 Eliot, Robert, of Wysbech, Cams, barker 1
5254304 2431473 2431473 defendant Chapman John butcher 593852 593852 Chapman, John, of Wysbech, Cams, butcher 0
5259075 2432954 2432954 defendant Joly Thomas dyer 593852 593852 Joly, Thomas, of Wysbech, Cams, dyer 0
5281297 2439603 2439603 defendant Fooke John yeoman 593852 593852 Fooke, John, of Wysbech, Cams, yeoman 0
5286044 2440927 2440927 defendant Rassh Edmund   593852 593852 Rassh, Edmund, of Wysbech, Cams, mason 9
5287090 2441233 2441233 defendant Rassh Edmund   593852 593852 Rassh, Edmund, of Wysbech, Cams, mason 10
5290761 2442300 2442300 defendant Roray Geoffrey husbandman 593852 593852 Roray, Geoffrey, of Wysbech, Cams, husbandman 0
5293883 2443181 2443181 defendant Adamson alias Adham John brewer 593852 593852 Adamson alias Adham, John, of Wysbech, Cams, brewer 0
5318595 2450655 2450655 defendant Proud Martin laborer 593852 593852 Proud, Martin, of Wysbech, Cams, laborer 0
5326692 2453052 2453052 defendant Powdych John mercer 593852 593852 Powdych, John, of Wysbech, Cams, mercer 0
5332453 2454772 2454772 defendant Game John yeoman 593852 593852 Game, John, of Wysbech, Cams, yeoman 0
5344294 2458396 2458396 defendant Neyton William husbandman 593852 593852 Neyton, William, of Wysbech, Cams, husbandman 2
5351621 2460606 2460606 defendant Ingrame John, senior husbandman 593852 593852 Ingrame, John, senior, of Wysbech, Cams, husbandman 0
5357369 2462371 2462371 defendant Came or Caine John raffman 593852 593852 Came or Caine, John, of Wysbech, Cams, raffman 0
5487863 2501258 2501258 defendant Thornton John yeoman 593852 593852 Thornton, John, of Wysbech, Cams, yeoman 0
5500186 2505008 2505008 defendant Pygge Robert   593852 593852 Pygge, Robert, of Wysbech, Cams 0
5500188 2505009 2505009 defendant Pygge Robert husbandman 593852 593852 Pygge, Robert, of Wysbech, Cams, husbandman 0
5508221 2507453 2507453 plaintiff Drake John   593852 593852 Drake, John, of Wysbech, Cams, excecutrix of 0
5514745 2509451 2509451 defendant Pygge Robert husbandman 593852 593852 Pygge, Robert, of Wysbech, Cams, husbandman 0
5538440 2516506 2516506 defendant Geryng Richard husbandman 593852 593852 Geryng, Richard, of Wysbech, Cams, husbandman 1
5576494 2527698 2527698 defendant Gateford Margery widow 593852 593852 (Gateford, Margery, of Wysbech, Cams, widow 5
5633817 2554572 2554572 defendant Fysshere Thomas chapman 593852 593852 Fysshere, Thomas, of Wysbech, Cams, chapman 0
5633829 2554575 2554575 defendant Goldsmyth John yeoman 593852 593852 Goldsmyth, John, of Wysbech, Cams, yeoman 2

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);