names

27 rows where place_id = 774517

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4510541 2203765 2203765 plaintiff Barre John   774517 774517 Barre, John, of Great Paxton, vicar 0
4613047 2235139 2235139 defendant Stratford John   774517 774517 Stratford, John, of Great Paxton 0
4708409 2267994 2267994 defendant Stretford John husbandman 774517 774517 Stretford, John, of Great Paxton, husbandman 1
4708523 2268033 2268033 defendant Stratford John husbandman 774517 774517 Stratford, John, of Great Paxton, husbandman 1
4772913 2287499 2287499 defendant Shepherd William   774517 774517 Shepherd, William, of Great Paxton 0
4772915 2287500 2287500 plaintiff Stratford John   774517 774517 Stratford, John, of Great Paxton 0
4773684 2287744 2287744 defendant Lowe Robert husbandman 774517 774517 Lowe, Robert, of Great Paxton, husbandman 0
4773685 2287744 2287744 defendant Hylton William husbandman 774517 774517 Hylton, William, of Great Paxton, husbandman 1
4773887 2287813 2287813 defendant Gore William husbandman 774517 774517 Gore, William, of Great Paxton, husbandman 0
4773888 2287813 2287813 defendant Gore John husbandman 774517 774517 Gore, John, of Great Paxton, husbandman 1
4773889 2287813 2287813 defendant Archedekene John husbandman 774517 774517 Archedekene, John, of Great Paxton, husbandman 2
4773891 2287813 2287813 defendant Gore William yeoman 774517 774517 (Gore, William, of Great Paxton, yeoman 4
4773892 2287813 2287813 defendant Gore John yeoman 774517 774517 Gore, John, of Great Paxton, yeoman 5
4802408 2296945 2296945 defendant Smyth Edmund yeoman 774517 774517 Smyth, Edmund, of Great Paxton, yeoman 0
4810920 2299533 2299533 defendant Touslond or Tonslond John husbandman 774517 774517 Touslond or Tonslond, John, of Great Paxton, husbandman 1
4810922 2299533 2299533 defendant Stratford John husbandman 774517 774517 Stratford, John, of Great Paxton, husbandman 3
4819749 2302250 2302250 defendant Stratford John husbandman 774517 774517 Stratford, John, of Great Paxton, husbandman 0
4837340 2307619 2307619 defendant Touslond John husbandman 774517 774517 Touslond, John, of Great Paxton, husbandman 2
4837342 2307619 2307619 defendant Stratford John husbandman 774517 774517 Stratford, John, of Great Paxton, husbandman 4
4850748 2311686 2311686 defendant Stretford John   774517 774517 Stretford, John, of Great Paxton, bailiff 4
5147065 2400280 2400280 defendant Gory John husbandman 774517 774517 Gory, John, of Great Paxton, husbandman 3
5187838 2412160 2412160 defendant Gore John butcher 774517 774517 Gore, John, of Great Paxton, butcher 3
5187839 2412160 2412160 defendant Gore William butcher 774517 774517 Gore, William, of Great Paxton, butcher 4
5202847 2416595 2416595 defendant Neve Roger carpenter 774517 774517 Neve, Roger, of Great Paxton, carpenter 14
5203195 2416696 2416696 defendant Gore John husbandman 774517 774517 Gore, John, of Great Paxton, husbandman 1
5205749 2417423 2417423 defendant Gore John butcher 774517 774517 Gore, John, of Great Paxton, butcher 3
5205750 2417423 2417423 defendant Gore William butcher 774517 774517 Gore, William, of Great Paxton, butcher 4

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