names

31 rows where place_id = 728058

✎ 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
4275010 2121213 2121213 defendant Yorke Henry husbandman 728058 728058 Yorke, Henry, of Kyslyngbury, husbandman 1
4275011 2121213 2121213 defendant Knowles Robert husbandman 728058 728058 Knowles, Robert, of Kyslyngbury, husbandman 2
4275012 2121213 2121213 defendant Burnell Sampson husbandman 728058 728058 Burnell, Sampson, of Kyslyngbury, husbandman 3
4315528 2135541 2135541 defendant Yorke Henry husbandman 728058 728058 Yorke, Henry, of Kyslyngbury, husbandman 0
4663013 2249897 2249897 plaintiff Gardyner Richard   728058 728058 Gardyner, Richard, of Kyslyngbury 0
4676758 2258353 2258353 defendant Gardyner Richard husbandman 728058 728058 Gardyner, Richard, of Kyslyngbury, husbandman 0
4692331 2263118 2263118 defendant Buffard John husbandman 728058 728058 Buffard, John, of Kyslyngbury, husbandman 0
4692332 2263118 2263118 defendant Raulyn Richard husbandman 728058 728058 Raulyn, Richard, of Kyslyngbury, husbandman 1
4750296 2280564 2280564 defendant Wryght William husbandman 728058 728058 Wryght, William, of Kyslyngbury, husbandman 0
4757238 2282637 2282637 plaintiff Bosworth John   728058 728058 Bosworth, John, of Kyslyngbury 0
4773634 2287725 2287725 defendant Boseworth John yeoman 728058 728058 Boseworth, John, of Kyslyngbury, yeoman 0
4776434 2288623 2288623 defendant Kyng John   728058 728058 Kyng, John, of Kyslyngbury, bailiff 2
4792983 2293897 2293897 defendant Boseworth John farmer 728058 728058 Boseworth, John, of Kyslyngbury, farmer 0
4792984 2293897 2293897 defendant Farnam Richard chaplain 728058 728058 Farnam, Richard, of Kyslyngbury, chaplain 1
4792985 2293897 2293897 defendant Bowele Edmund   728058 728058 Bowele, Edmund, of Kyslyngbury, bailiff 2
4792986 2293897 2293897 defendant Cartere Thomas carter 728058 728058 Cartere, Thomas, of Kyslyngbury, carter 3
4809949 2299272 2299272 defendant Smyth John smith 728058 728058 Smyth, John, of Kyslyngbury, smith 4
4814289 2300574 2300574 defendant Newebery John husbandman 728058 728058 Newebery, John, of Kyslyngbury, husbandman 1
4840958 2308705 2308705 defendant Newebery John husbandman 728058 728058 Newebery, John, of Kyslyngbury, husbandman 1
4880464 2320799 2320799 defendant Rawelyn Richard husbandman 728058 728058 Rawelyn, Richard, of Kyslyngbury, husbandman 0
4909757 2329573 2329573 defendant day Simon husbandman 728058 728058 day, Simon, of Kyslyngbury, husbandman 2
4944450 2340244 2340244 defendant Raulyns Richard yeoman 728058 728058 Raulyns, Richard, of Kyslyngbury, yeoman 0
4945330 2340515 2340515 defendant Busford John yeoman 728058 728058 Busford, John, of Kyslyngbury, yeoman 4
4990249 2353992 2353992 defendant Raulyns Richard yeoman 728058 728058 Raulyns, Richard, of Kyslyngbury, yeoman 2
5097267 2385630 2385630 defendant Fodryngay Henry smith 728058 728058 Fodryngay, Henry, of Kyslyngbury, smith 0
5097270 2385631 2385631 defendant Fodryngay Henry smith 728058 728058 Fodryngay, Henry, of Kyslyngbury, smith 0
5213767 2419755 2419755 defendant Rawlyns Richard yeoman 728058 728058 Rawlyns, Richard, of Kyslyngbury, yeoman 0
5246905 2429258 2429258 defendant Shirley John miller 728058 728058 Shirley, John, of Kyslyngbury, miller 0
5440424 2487039 2487039 defendant Wotton Robert walker 728058 728058 Wotton, Robert, of Kyslyngbury, walker 0
5465703 2494657 2494657 defendant Wetton Robert fuller 728058 728058 Wetton, Robert, of Kyslyngbury, fuller 0
5546346 2518934 2518934 defendant Frenche John husbandman 728058 728058 Frenche, John, of Kyslyngbury, 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);